How to order data when collecting (collect)?

[Тарасов Константин]

My cypher query is

START root=node(1)
MATCH root-[r*..3]->tag
return collect(tag) as tags, collect(r) as rels

adding ORDER BY at the end cause syntax error:

ORDER BY tag.name

what is solution to order data when collecting?

[terrasoff]

Note, query above is faster than

START root=node(1)
MATCH root-[r*..3]->tag

return tag,r

sure, in this case ORDER isn't problem 

[Peter Neubauer]

Mmh,
good question. I think COLLECT does not make any guarantees about
ordering, it is an unordered collection. What is your us case? Why not
in that case return TAG, and order by TAG.name?

Cheers,

/peter neubauer

G: neubauer.peter
S: peter.neubauer
P: +46 704 106975
L: http://www.linkedin.com/in/neubauer
T: @peterneubauer

Wanna learn something new? Come to http://graphconnect.com

> --
>
>

[Wes Freeman]

My latest pull request should enable this use case:

https://github.com/neo4j/community/pull/913

Syntax would be:

START root=node(1)
MATCH root-[r*..3]->tag

WITH tag, r

ORDER by tag.name
RETURN collect(tag) as tags, collect(r) as rels

Wes

--