Can't put a condition in the WITH. Please do something such as 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, l.eventEndDate + l.eventEndTime as endDateTime, l WHERE startDateTime >= timestamp() OR endDateTime>=timestamp() RETURN l ORDER BY startDateTime ASC SKIP 0 LIMIT 25;
(Also you don't appear to be using p) On Mon, Dec 30, 2013 at 3:36 PM, Sukaant Chaudhary < [email protected]> wrote: > 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.
