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 <[email protected]>: > 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 <[email protected]> > wrote: > Hi Sukaant, > > What's the error? > > -Luanne > > > On Mon, Dec 30, 2013 at 3:07 PM, Sukaant Chaudhary > <[email protected]> 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 [email protected]. > 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 [email protected]. > 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
