One more thing to add is that what I was doing for previous versions of
Neo4j and it was working (but it's not allowed anymore) is the following:
START
n1=({node})
MATCH
n1<-[r?:rel1]-n2
WHERE
n1.propertyA = {param1} AND (r is null OR n2.propertyB! = {param2})
RETURN
n1;
Thanks,
Matias.
On Monday, February 1, 2016 at 8:10:29 PM UTC-3, [email protected] wrote:
Hi all,
>
> I'm having a hard time building a query with optional relationship using
> Neo4j 2.3.2.
>
> My query is something like this:
>
> MATCH
> (n1:Label1)
> WHERE
> (n1.propertyA = {param1})
> OPTIONAL MATCH
> (n1)<-[r:rel1]-(n2:Label2)
> WHERE
> (NOT (n1)<-[r:rel1]-(n2) OR n2.propertyB = {param2})
> RETURN
>
n1;
>
> My intention is to return all n1 objets that don't have a relationship to
> n2 or if they have a relationship check for propertyB and filter by that.
> What I'm getting is all the n1 even when rel1 exists and propertyB !=
> {param2}
>
> Anyone sees what's the issue in this query? I can't see it...
>
> Thanks,
> Matias.
>
>
>
>
--
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/d/optout.
