Hey, Not sure I understand exactly what you're trying to do. Can you create a graphgist with a small example data set? http://gist.neo4j.org/
That transaction exception sounds weird though, how do you get that? How are you executing the query? Mark On 3 January 2014 06:33, Sukaant Chaudhary <[email protected]>wrote: > Hi Mark, > I tried the following query but still I'm not getting the nodes without > these three relations given, but I want the nodes which is not having that > relation as well. > > START n=node(*), m=node(2) MATCH > p=(m)-[r:FOLLOWED_BY|CREATED_BY|FOLLOW_PENDING]->(n) OPTIONAL MATCH > (m)-[s]->n WHERE has(n.timeBoardName) AND n.timeBoardName =~ "(?i).*" > RETURN r, s, n; > > -Sukaant Chaudhary > > > On Thu, Jan 2, 2014 at 8:16 PM, Mark Needham <[email protected]>wrote: > >> I wrote up an example of translating a query using ? to use OPTIONAL >> MATCH here - >> http://www.markhneedham.com/blog/2013/11/23/neo4j-2-0-0-m06-2-0-0-rc1-optional-relationships-with-optional-match/ >> >> Can you have a look at that and see whether you're able to follow the >> same reasoning I did to adjust your query? >> >> Cheers >> Mark >> >> >> On 2 January 2014 13:16, Sukaant Chaudhary >> <[email protected]>wrote: >> >>> Hi, >>> I want to search for all the nodes which have the given relation and >>> which does not have the given relations, for that what changes I need to do >>> in the following query? >>> It was working fine with previous versions by using "?". >>> >>> START n=node(*), m=node(2) MATCH >>> p=(m)-[r:FOLLOWED_BY|CREATED_BY|FOLLOW_PENDING*]->(n) WHERE >>> has(n.timeBoardName) AND n.timeBoardName =~ "(?i).*" RETURN r, n; >>> >>> >>> -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.
