Improvement to the large query

[mgeeky]

Improvement to the large query

[mgeeky]

Didn't know it's possible to define params in web UI, that might in fact be far easier approach!

Looks cool to me. I'm gonna test it out in a spare minute and add it to the collection.

Thank you @AdrianVollmer - really appreciate it :-)

[mgeeky]

Awesome contribution @AdrianVollmer - thank you! :-)

I considered the use of Cypher variables before but the drawback I saw was that, the query utilising them might be unusable from Neo4j Web UI. That's why I opted for a tradeoff involving Find&Replace annoyance.

With that said, what do you think about putting two separately designed queries next to each other, giving auditor's choice depending on his use case?

Regards,
M.

[AdrianVollmer]

In the web UI you can set parameters with this command before executing the query:

:param domain => 'mydomain.local'

See https://neo4j.com/docs/cypher-manual/current/syntax/parameters/

I mean, you need to find and replace the domain name anyway. Not many domains are named contoso.local ;) might as well replace $domain instead of contoso.local.

I leave it up to you, maybe try it out a few times.