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.
