I am new to Cypher and implementing a Financial Crime DB.
This is for a superannuation product and my schema is -
(Member), (BankAccount), (EmailAddress), (MobileNumber) and (IPAddress).
And relationships between all these nodes of USES.
I needed to derive for an email pattern any members with this email and did they have payments, this Cypher gave accurate results ( as the DBAs ran theirs in their OLTP database) but I am confused on what it is doing as I have not mentioned any 'real' nodes and in particular returns the EmailAddress node and has filtered the list to only those who have a BankAccount node.
It is just searching everything maybe ?
WITH ['.aol.com.', '.yandex.com.', '.fastemail.com.'] AS emaillist
UNWIND emaillist AS emailextension
match (email) -- (member) -- (bankaccount)
WITH emailextension, email
WHERE email.name =~ emailextension
and exists (bankaccount.name )
and member.status = 'Current'
RETURN * limit 10
Thanks in advance :)