This query is completely off, don't do m=node(*) and l=node(*) they are 
inferred from your first path:

I would also limit the variable length paths like [:FOLLOWED_BY*] to e.g. 5 or 
10 steps

> START n=node(2)
> MATCH (n)-[:FOLLOWED_BY*..5]->(m)
WITH distinct m
> MATCH (m)-[:PUBLISHED_UNDER*..5]->(l) 
> WHERE l.eventStartDate + l.eventStartTime >= timestamp() OR l.eventEndDate + 
> l.eventEndTime>=timestamp()
> RETURN l 
> ORDER BY l.eventStartDate + l.eventStartTime ASC 
> SKIP 0 LIMIT 25

Michael

Am 30.12.2013 um 11:06 schrieb Sukaant Chaudhary <sukaant.chaudh...@gmail.com>:

> Hi Luanne,
> I'm getting the following error:
> 
>  SyntaxException: Invalid input '>': expected whitespace, comment, ',', 
> Order, Skip, Limit or SingleQuery (line 1, column 164)
> 
> "START n=node(2), m=node(*), l=node(*) MATCH p=(n)-[r:FOLLOWED_BY*]->(m), 
> q=(m)-[r:PUBLISHED_UNDER*]->(l) WITH l.eventStartDate + l.eventStartTime as 
> startDateTime >= timestamp() OR l.eventEndDate + l.eventEndTime>=timestamp(), 
> l RETURN l ORDER BY startDateTime ASC SKIP 0 LIMIT 25"
> 
> -Sukaant Chaudhary
> 
> 
> On Mon, Dec 30, 2013 at 3:32 PM, Luanne Coutinho <luanne.couti...@gmail.com> 
> wrote:
> Hi Sukaant,
> 
> What's the error?
> 
> -Luanne
> 
> 
> On Mon, Dec 30, 2013 at 3:07 PM, Sukaant Chaudhary 
> <sukaant.chaudh...@gmail.com> wrote:
> Hi,
> Please help me to correct following query:
> 
> START n=node(2), m=node(*), l=node(*) MATCH p=(n)-[r:FOLLOWED_BY*]->(m), 
> q=(m)-[r:PUBLISHED_UNDER*]->(l) WITH l.eventStartDate + l.eventStartTime as 
> startDateTime >= timestamp() OR l.eventEndDate + l.eventEndTime>=timestamp(), 
> l RETURN l ORDER BY startDateTime ASC SKIP 0 LIMIT 25;
> 
> -Sukaant Chaudhary
> 
> -- 
> 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 neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
> 
> 
> -- 
> 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 neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
> 
> 
> -- 
> 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 neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to