On console.neo4j.org or rather neo4j-console-19.herokuapp.com you can use the node_auto_index which is automatically populated.
Perhaps you can share your create script. Perhaps you should do a query that lists all relationships and their end nodes of user 7 ? Michael Am 09.06.2014 um 09:15 schrieb Biswajit Kumar Das <[email protected]>: > Sorry I had missed one condition..... > Some more Insight > I felt, it is a lucene related problem. Because the value I was expecting > which is getting displayed If I Choose to use below query > CORRECT > START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5 OR UUID:6 > OR UUID:8) AND OBJECTTYPE:USER AND OF:APPLICATION"), > u=node(*) > MATCH n<-[r:FOLLOWS|KNOWS]-u > WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT > u.UUID) AS ALL > RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST > > > Again this is correct, I have seen if the node's are lesser than or equal to > five > CORRECT > START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4) AND OBJECTTYPE:USER > AND OF:APPLICATION"), > u=node:NODE("OBJECTTYPE:USER AND OF:APPLICATION") > MATCH n<-[r:FOLLOWS|KNOWS]-u > WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT > u.UUID) AS ALL > RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST > > Even this is correct, Where u has one condition missing > CORRECT > START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5 OR UUID:6 > OR UUID:8) AND OBJECTTYPE:USER AND OF:APPLICATION"), > u=node:NODE("OBJECTTYPE:USER") > MATCH n<-[r:FOLLOWS|KNOWS]-u > WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT > u.UUID) AS ALL > RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST > > > Where as below query is still coming wrong > WRONG > START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5 OR UUID:6 > OR UUID:8) AND OBJECTTYPE:USER"), > u=node:NODE("OBJECTTYPE:USER AND OF:APPLICATION") > MATCH n<-[r:FOLLOWS|KNOWS]-u > WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT > u.UUID) AS ALL > RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST > > > If you think it might be an index issue, I am able to do this > CORRECT > START root=node:NODE("OBJECTTYPE:USER AND OF:APPLICATION") > WHERE root.UUID = 7 > RETURN root > > This thing is making me nuts.....Any idea, where I am doing wrong? > How can I use http://www.neo4j.org/console to create Index, so that I can > make this output visible for all? > Yes I have tried this on newest version. > Regards > Biswajit > > On Wednesday, 14 May 2014 17:03:48 UTC+5:30, Biswajit Kumar Das wrote: > Hi > I am not so new in Neo4J, but our Neo4J engine is old (Neo4j - Graph Database > Kernel 1.9) We have a very simple query running as down below > Where I am trying to find out some user's total follow and know and whether a > specific user exist in them. Am I doing this wrong? :( > Because it behaves differently when the relationship increases. The TOTAL and > EXIST value starts coming wrong. I even checked out each relationship, > whether they exists or not, they do. Sometimes relations are between the > nodes of same set (Could this be any issue?). So I tried to decrease the > relations and again it starts coming correct. Where I am doing wrong? > > Thanks in advance > > Regards > Biswajit > > START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5) AND > OBJECTTYPE:USER"), > u=node:NODE("OBJECTTYPE:USER") > MATCH n<-[r:FOLLOWS|KNOWS]-u > WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT > u.UUID) AS ALL > RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
