Skip to content
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
Clone this wiki locally