Looks like the left side is a date string, and the right side an integer or long?
/peter (snt)-[:frm]->(phn) On Dec 30, 2013 12:58 PM, "Sukaant Chaudhary" <sukaant.chaudh...@gmail.com> wrote: > 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 < > luanne.couti...@gmail.com> 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 < >> sukaant.chaudh...@gmail.com> 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 < >>> michael.hun...@neopersistence.com> 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 < >>>> 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. >>>> >>> >>> -- >>> 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.
