cancel
Showing results for 
Search instead for 
Did you mean: 

Select one node, when multiple nodes have same property

karora7190
Node Clone

Hello all,

I am working the below schema :

I want to fetch the Questions, but in case if the two questions have same QuestionLibraryId, I want either of the two returned.

So in the above scenario, I should only get one question in the output.

Any help would be really appreciated.

2 REPLIES 2

You can aggregate the questions by the library ID and take the head() of the resulting list:

... // assume q is in scope for the matched questions
WITH q.QuestionLibraryId as qID, collect(q) as questions
WITH head(questions) as question
...

Note that the questions list is all the questions for a given question library ID, so if for a given ID there is only one question, then the questions list will be size 1 for that row. After the last WITH you will have a row per question, and no two questions across those rows will share the same QuestionLibraryId.

Of course you'll need to adjust as needed for whatever else you have in scope.

If there can be many questions with the same id, and you want a random one, then if you have APOC Procedures installed you can use the apoc.coll.randomItem() function to take one from the list at random.

Thanks a ton @andrew.bowman .
This works perfectly.

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.