Hi Luanne, Sorry it was my mistake, copy paste issue. But still I'm getting the following exception:
SyntaxException: Don't know how to compare that. Left: 2013-12-1916:05:00; Right: 1388404459272 -Sukaant Chaudhary On Mon, Dec 30, 2013 at 5:22 PM, Luanne Coutinho <[email protected]>wrote: > 5 is the max hops (See Variable length relationships in > http://docs.neo4j.org/chunked/stable/query-match.html#_relationships_in_depth > ) > > > 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 > > Do you reallly have a > after your with distinct m? Or is it a copy paste > issue? > > > On Mon, Dec 30, 2013 at 4:44 PM, Sukaant Chaudhary < > [email protected]> wrote: > >> Hi Michael, >> Please explain what is "*..5*" in the following line: >> >> [:FOLLOWED_BY*..5] >> >> Also I'm getting the following exception now: >> >> >> SyntaxException: Invalid input ':': expected whitespace, an identifier, an >> expression or ']' (line 1, column 80) >> >> ==> "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" >> >> -Sukaant Chaudhary >> >> >> On Mon, Dec 30, 2013 at 4:31 PM, Michael Hunger < >> [email protected]> wrote: >> >>> 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. >>> >> >> -- >> 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.
