Skip to content

Instantly share code, notes, and snippets.

@rvazarkar
Created March 28, 2018 18:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rvazarkar/1f7e5f99a9d6ade38edf361a6fb0593a to your computer and use it in GitHub Desktop.
Save rvazarkar/1f7e5f99a9d6ade38edf361a6fb0593a to your computer and use it in GitHub Desktop.
{
"name": "Users with Foreign Domain Group Membership",
"queryList": [
{
"final": false,
"title": "Select source domain...",
"query": "MATCH (n:Domain) RETURN n.name ORDER BY n.name DESC"
},
{
"final": true,
"query": "MATCH (n:User) WITH n MATCH (m:Group) WITH n,m MATCH p=(n)-[r:MemberOf]->(m) WHERE n.domain={result} AND NOT m.domain=n.domain RETURN p",
"startNode": "{}",
"allowCollapse": false
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment