Hi thanks for your answer,
But din't understand, what are you trying to say. The thing I am trying to 
say, might not be built on console.neo4j.org or rather 
neo4j-console-19.herokuapp.com 
<http://www.google.com/url?q=http%3A%2F%2Fneo4j-console-19.herokuapp.com&sa=D&sntz=1&usg=AFQjCNG8fyshX6XdC2Izysfc5PnC62n-Zg>
 ....Or 
may be I do not know how to do that indexing. What did you mean by second 
index Lookup? I hope you are not implying about the filters. here *r.name *is 
the relationship name(Property of relation). I am not sure, why I skipped 
the *DISTINCT* part on count, but thanks.
So the question remains, Have anyone found anything with the indexer? 
*Hunger*, could you please give an example, how can I skip the multiple 
index lookup [Not changing the design :D]?
Thanks....
Thanks a ton *Hunger*....
I hope I get an answer.... :D

On Tuesday, 10 June 2014 23:02:22 UTC+5:30, Michael Hunger wrote:
>
> I think you don't need the second index lookup.
> It will faster to just let the matcher do it's job.
>
> It will only aggregate on n.UID, r.name
> (don't know what r.name is)
>
> please note that count(*) counts the total rows generated by the matcher, 
> not the distinct data elements.
>
> you probably want to use count(distinct u.UUID)
>
> Michael
>
> START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5) AND 
> 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
>
>
> Am 14.05.2014 um 13:33 schrieb Biswajit Kumar Das <[email protected] 
> <javascript:>>:
>
> 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] <javascript:>.
> 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.

Reply via email to