Extracting fraud ring based on client name

[vanshtuli1994]

Hi,

I am new to neo4j so I have a naïve query to ask.

I am using Fraud detection sandbox, and getting potential fraud rings out of it.
I am using the following query:

MATCH (c:Client)
WITH c.firstPartyFraudGroup AS fpGroupID, collect(c.id) AS fGroup
WITH *, size(fGroup) AS groupSize WHERE groupSize >= 9
WITH collect(fpGroupID) AS fraudRings
MATCH p=(c:Client)-[:HAS_SSN|HAS_EMAIL|HAS_PHONE]->()
WHERE c.firstPartyFraudGroup IN fraudRings
RETURN p

My output is:

Now I look forward query a potential fraud ring based on a particular name. Let's say I use a name (For example, 'David Poole') I want to output only the ring which has David Poole in it.

I tried multiple things but couldn't get them to work.

Help would be really appreciated!

Thanks in advance

[Joel]

Without knowing more, have you tried something like this?

MATCH (c:Client)
WHERE c.name='David Poole'
WITH c.firstPartyFraudGroup AS fpGroupID, collect(c.id) AS fGroup
WITH *, size(fGroup) AS groupSize WHERE groupSize >= 9
WITH collect(fpGroupID) AS fraudRings
MATCH p=(c:Client)-[:HAS_SSN|HAS_EMAIL|HAS_PHONE]->()
WHERE c.firstPartyFraudGroup IN fraudRings
RETURN p

Can you share what have you tried exactly? and what problems were observed in the output?