How to get the order of a query result

[paolodipietro58]

I have a simple question I wasn't able to answer:

Imagine I have a query.

MATCH (x:X)
   WITH x 
   ORDER BY x.prop

return counter(x), X

where the counter is a number from 0/1 up to the number of the results.

In other words, I want to added a column which represent a counter, so I can later rearrange the results, but maintaining the original reference and then being able to directly access the array of the result.

Is a crazy idea or someone know how to achieve that?

Thanks

[Bennu · Accepted solution]

Hi @paolodipietro58 !

You may find this link useful!

github.com/neo4j/neo4j

Feature Request: Row Number for RETURN

opened 11:56PM - 17 Oct 18 UTC

closed 04:10PM - 04 Feb 19 UTC

graphadvantage

team-cypher

Hi A really useful feature for programatic control would be an introspectable… row_number object as parameter for RETURN or maybe row_number is a RETURN-able function like timestamp, this might be the cheapest way to implement. Thanks Michael ** added some notes below ***

Bennu

[paolodipietro58]

Well, seem to be too difficult to implement due to the parallelism.
I solved implementing it in javascript.
But is interesting to discover not to be alone into the universe 😉