Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics

Dashboard
Notifications
Mark all as read
Q&A

Union of queries depending on variable in list

+3
−0

I have a big Cypher query that is depending on a variable.

Example:

With REGION = 'Canada'

query

I want to execute this query several times based on different values on a list and return the UNION.

Something like:

regions = ['Canada','Europe']

query_with_Canada UNION query_with_Europe

Is there any way to achieve this in Cypher?

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

0 comments

1 answer

+3
−0

Yes, you can achieve this using UNWIND and CALL, in the following pattern:

UNWIND ['Canada', 'Europe'] AS region
CALL {
  WITH region
  query
}
RETURN *

You can replace RETURN * with any other end-of-query clause, of course, if you want to order or limit your results for example. But don't omit the WITH region inside the CALL subquery; without that explicit import, you won't be able to refer to region (or any outer query variables) inside the subquery.

Why does this post require moderator attention?
You might want to add some details to your flag.

0 comments

Sign up to answer this question »