Hi all,
We observe unexplainable behaviour with Web Browser
Cypher query return only 3 relationships but the web browser display 5.
As you can see, on the right side we have this text : Displaying 4 Nodes, 3 rel
But the graph shows 5 rel.
The table Tab in the Web Browser shows 3 records.
And the cypher results return 3 rel
PS : we run 5.14.0 community version
regards,
Nizar
Interesting. Can you hover over each relationships in the pairs to see their ids? Are they the same or different ids?
We have different ids.
Any idea any suggestions
Thanks guys
I am confused. Your pattern is general (no restrictions on labels of 'm', type of 'r', and no direction for 'r'), except for the FinanceManager node is specific. As such, any relationships from the FinanceManager should be included your results. The graph would imply you should get back five rows of data.
What do you get with this query when you replace with the correct FinanceManager idRef: 3 or 5?
match (n:FinanceManager{idRef:"replace with idRef"})-[r]-(m)
return count(r)
Also, what do you get back if you run the query after disabling "Connect result nodes" in the settings (gear icon)?
Under the Relationship types it show '5' in the first box. The count 3 comes when you count relationship types, as you have 3 different types. For two types you have 2 relationships of same type. The difference is count of relationships vs count of relationship types.
Hi,
When I disable "Connect resulta nodes" and run this cypher I have the right graphe/right results/right rel
match (n:FinanceManager{idRef:"replace with idRef"})-[r]-(m)
return *
Interesting. That means those two relationships are not part of your query results, explaining the stats shown and the results returned. Now the question is why they are not part of your query results when there is no constraints in your pattern to eliminate them.
Another interesting thing I forgot to share :
We observe this behaviors with other queries, it's not only for the query shared here.
When we refresh the Neo4j WebBrowser (reload/refresh the chrome browser tab), sometimes we have the display with the right data, sometimes not
Any idea any suggestions
Thanks guys
The table show 4 nods, that's ok.
You have two "unknown" labels, attached to those two nods that have double relations (probably wrong insert query doubled with unknown label).
Also, you query don't ask for specific label, so all labels are returned and rendered. But result return nods, not labels and that's what you see in table result.
Everything is fine, as far as I can see.