CODEWITHSUNDEEP
neo4jcypher
JavaFXpert
JavaFXpert

Reputation: 23

How can I make the following Cypher query have the results that setting auto-complete control does?

I am doing the following Cypher query: MATCH (a) WHERE a.itemId IN ['Q2', 'Q24', 'Q30', 'Q23', 'Q16', 'Q20'] RETURN a

I'd like it to return the same results as when I set the Auto-Complete switch. This question was asked and answered 1 but I don't understand the answer. Can this be performed in one query, and if so, what would the modified query be?

Upvotes: 2

Views: 140

Answers (2)

Brian Underwood
Brian Underwood

Reputation: 10856

Got some separate clarification on the question about how to only return the relationships between the nodes that are matched. This should be possible like so:

MATCH (a)
WHERE a.itemId IN {itemIds}
OPTIONAL MATCH (a)-[rel]-(b)
WHERE b.itemId IN {itemIds}
RETURN a, collect(rel)

Again, you also might want to return the startNode/endNode of the relationships

Upvotes: 0

Brian Underwood
Brian Underwood

Reputation: 10856

Yeah, you should be able to do it all in one query. To get the nodes in question along with their relationships you can do:

MATCH (a)
WHERE a.itemId IN ['Q2', 'Q24', 'Q30', 'Q23', 'Q16', 'Q20']
OPTIONAL MATCH (a)-[rel]-()
RETURN a, collect(rel)

That will return you, for each node, an array of the relationships.

Depending on your library that you're using for Neo4j, that may or may not return you something useful to give you the startnode/endnode. You could also do:

MATCH (a)
WHERE a.itemId IN ['Q2', 'Q24', 'Q30', 'Q23', 'Q16', 'Q20']
OPTIONAL MATCH (a)-[rel]-()
RETURN a, collect({rel: rel, start_node: startNode(rel), end_node: endNode(rel)})

That would give you an array for each node containing objects/maps of the data.

Upvotes: 1

Related Questions