Thanks Michael -Sukaant Chaudhary
[image: linkedinbutton]<http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479/> On Wed, Mar 5, 2014 at 4:31 PM, Michael Hunger < [email protected]> wrote: > Yes, why not? I assume that is a 1:1 relationship. > > Whatever m,q,k mean? you should probably use more descriptive names for > those :) > > Michael > > Am 05.03.2014 um 11:35 schrieb Sukaant Chaudhary < > [email protected]>: > > 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 > > <image002.jpg> <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. > > > -- > 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>>
