0
votes

Can we filter relationship property in MATCH clause?

I have one relationship like this.

[:friends] {"ApprovalStatus" : 1, "ApprovalDate" : "01-Apr-2013 10:10:10" }

Now I want to filter "ApprovalStatus" property like this.

MATCH other-[r:friends.ApprovalStatus = 1]-(mf)-[r1:friends] 

So, I can get mutual count with ApprovalStatus = 1 only.

Is it possible in cypher?

2

2 Answers

2
votes
MATCH other-[r:friends]-(mf)-[r1:friends] 
WHERE r.ApprovalStatus=1
2
votes

You can use:

MATCH other-[r:friends{ApprovalStatus:1}]-(mf)-[r1:friends]