-
Notifications
You must be signed in to change notification settings - Fork 0
Neo4j
Tak Tran edited this page Feb 1, 2019
·
3 revisions
Find all users with an uuid
MATCH (u:User {uuid: "[some-uud]"}) RETURN u
Find all users within a group of uuids
MATCH (u:User)
WHERE u.uuid IN [
"uuid-1",
"uuid-2",
"uuid-3"
] RETURN u
Number of licenses with 1 group
MATCH (l:License)-[member]->(g:Group)
WITH l, count(g) AS numGroups
WHERE numGroups = 1
RETURN count(l)
Licenses with no group with the same license uuid
MATCH (l:License)-[:member]->(g:Group)
WITH l, l.uuid AS licenceId, collect(g.uuid) AS groupIDs
WHERE NOT licenceId IN groupIDs
RETURN l