Hi Michael, I'll change the relation the way you suggested. Here in this query, I want to add *(q)-[l:LOCATION]->(t) *the way I'm doing is right or not? Please suggest.
START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH DISTINCT m MATCH (m)-[:PUBLISHED_UNDER*..5]->(q)<-[:PUBLISHED_BY*..5]-(k)*, (q)-[l:LOCATION]->(t) //Add This* WHERE (q.eventStartDate + q.eventStartTime >= "2014-03-0417:34:37" OR q.eventEndDate + q.eventEndTime >= "2014-03-0417:34:37") *AND has(l.locationType) AND (l.locationType = 'PERMANENT') ** //Add This* RETURN k,m,q ORDER BY q.eventStartDate + q.eventStartTime ASC SKIP 1 LIMIT 25; -Sukaant Chaudhary [image: linkedinbutton]<http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479/> On Wed, Mar 5, 2014 at 1:07 PM, Michael Hunger < [email protected]> wrote: > And what doesn't work? > > It might make sense to create a LOCATION_PERMANENT rel-type instead. to > speed things up. > > Michael > > Am 04.03.2014 um 13:33 schrieb Sukaant Chaudhary < > [email protected]>: > > Hi, > In the following query I want to add the highlighted conditions with bold, > Please help me how to add: > > START n=node(2) > MATCH (n)-[:FOLLOWED_BY*..5]->(m) > WITH DISTINCT m > > MATCH (m)-[:PUBLISHED_UNDER*..5]->(q)<-[:PUBLISHED_BY*..5]-(k)*, > (q)-[l:LOCATION]->(t) //Add This* > > WHERE (q.eventStartDate + q.eventStartTime >= "2014-03-0417:34:37" > OR q.eventEndDate + q.eventEndTime >= "2014-03-0417:34:37") > > *AND has(l.locationType) AND (l.locationType = 'PERMANENT') ** > //Add This* > > RETURN k,m,q > ORDER BY q.eventStartDate + q.eventStartTime ASC > SKIP 1 LIMIT 25; > > -Sukaant Chaudhary > > <image002.jpg> <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479/> > > -- > 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.
<<inline: image002.jpg>>
