On Thu, Dec 8, 2011 at 10:32 AM, Rickard Öberg <
rickard.ob...@neotechnology.com> wrote:

> Ok, so with:
>  >> start ou=node(1234)
>  >> match (ou)-[:CHILD_OU*0..100]->(child_ou)<-[:OWNER]-(case)
>  >> where case.status = "CLOSED"
>  >> return avg(case.completionTime)
>
> that would give me what I want?
>

I think so.


> Cool! Especially considering that this was A LOT OF WORK to do with
> MySQL (current solution), as I had to implemented nested set models and
> whatnot. If it is as easy as the above, oh man...


Nested sets is one of the reasons Cypher looks like it does. Friends don't
let friends store tree structures in relational databases, bro...

Andrés
_______________________________________________
NOTICE: THIS MAILING LIST IS BEING SWITCHED TO GOOGLE GROUPS, please register 
and consider posting at https://groups.google.com/forum/#!forum/neo4j

Neo4j mailing list
User@lists.neo4j.org
https://lists.neo4j.org/mailman/listinfo/user

Reply via email to