🕷️ Crawler Inspector

[Skip to main content](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect#content) [Stack Overflow](https://stackoverflow.com/) 1. [About](https://stackoverflow.co/) 2. Products 3. [For Teams](https://stackoverflow.co/internal/) 1. [Stack Internal Implement a knowledge platform layer to power your enterprise and AI tools.](https://stackoverflow.co/internal/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=stack-overflow-for-teams) 2. [Stack Data Licensing Get access to top-class technical expertise with trusted & attributed content.](https://stackoverflow.co/data-licensing/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=overflow-api) 3. [Stack Ads Connect your brand to the world’s most trusted technologist communities.](https://stackoverflow.co/advertising/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=stack-overflow-advertising) 4. [Releases Keep up-to-date on features we add to Stack Overflow and Stack Internal.](https://stackoverflow.blog/releases/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=releases) 5. [About the company](https://stackoverflow.co/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=about-the-company) [Visit the blog](https://stackoverflow.blog/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=blog) 1. ### [current community](https://stackoverflow.com/) - [Stack Overflow](https://stackoverflow.com/) [help](https://stackoverflow.com/help) [chat](https://chat.stackoverflow.com/?tab=explore) - [Meta Stack Overflow](https://meta.stackoverflow.com/) ### your communities [Sign up](https://stackoverflow.com/users/signup?ssrc=site_switcher&returnurl=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F43118215%2Fneo4j-cypher-query-order-by-with-collect) or [log in](https://stackoverflow.com/users/login?ssrc=site_switcher&returnurl=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F43118215%2Fneo4j-cypher-query-order-by-with-collect) to customize your list. ### [more stack exchange communities](https://stackexchange.com/sites) [company blog](https://stackoverflow.blog/) 2. [Log in](https://stackoverflow.com/users/login?ssrc=head&returnurl=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F43118215%2Fneo4j-cypher-query-order-by-with-collect) 3. [Sign up](https://stackoverflow.com/users/signup?ssrc=head&returnurl=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F43118215%2Fneo4j-cypher-query-order-by-with-collect) 1. 1. [Home](https://stackoverflow.com/) 2. [Questions](https://stackoverflow.com/questions) 3. [AI Assist](https://stackoverflow.com/ai-assist) 4. [Tags](https://stackoverflow.com/tags) 5. [Challenges](https://stackoverflow.com/beta/challenges) 6. [Chat](https://chat.stackoverflow.com/rooms/259507/stack-overflow-lobby) 7. [Articles](https://stackoverflow.blog/contributed?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=so-blog&utm_content=experiment-articles) 8. [Users](https://stackoverflow.com/users) 9. [Companies](https://stackoverflow.com/jobs/companies?so_medium=stackoverflow&so_source=SiteNav) 10. [Collectives]() 11. Communities for your favorite technologies. [Explore all Collectives](https://stackoverflow.com/collectives-all) 2. Stack Internal Stack Overflow for Teams is now called **Stack Internal**. Bring the best of human thought and AI automation together at your work. [Try for free](https://stackoverflowteams.com/teams/create/free/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams) [Learn more](https://stackoverflow.co/internal/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams) 3. [Stack Internal]() 4. Bring the best of human thought and AI automation together at your work. [Learn more](https://stackoverflow.co/internal/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams-compact) ##### Collectives™ on Stack Overflow Find centralized, trusted content and collaborate around the technologies you use most. [Learn more about Collectives](https://stackoverflow.com/collectives) **Stack Internal** Knowledge at work Bring the best of human thought and AI automation together at your work. [Explore Stack Internal](https://stackoverflow.co/internal/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams-compact-popover) # [Neo4j cypher query order by with collect](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect) [Ask Question](https://stackoverflow.com/questions/ask) Asked 8 years, 8 months ago Modified [8 years, 8 months ago](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect?lastactivity "2017-03-30 13:30:53Z") Viewed 11k times 12 In cypher query i have multiple result which i get using collect now how i can order by collect property in cypher? ``` MATCH(u:User) WITH COLLECT({name:u.name,date:u.date}) AS userinfo RETURN userinfo ``` OR in the case there are multiple collections that have been merged ``` MATCH(u:User)-[r:CreatedBy]->(p:Project) WITH COLLECT({name:p.name,date:p.date}) AS info MATCH(i:Institue)-[owner:Owner]->(i:Institute) WITH COLLECT({instituteName:i.name,date:i.date}) AS instituteinfo,info WITH COLLECT(instituteinfo + info) AS alldata RETURN alldata ``` - [neo4j](https://stackoverflow.com/questions/tagged/neo4j "show questions tagged 'neo4j'") - [cypher](https://stackoverflow.com/questions/tagged/cypher "show questions tagged 'cypher'") [Share](https://stackoverflow.com/q/43118215 "Short permalink to this question") [Improve this question](https://stackoverflow.com/posts/43118215/edit) Follow [edited Mar 30, 2017 at 13:13](https://stackoverflow.com/posts/43118215/revisions "show all edits to this post") [](https://stackoverflow.com/users/4187346/dave-bennett) [Dave Bennett](https://stackoverflow.com/users/4187346/dave-bennett) 11\.3k33 gold badges3434 silver badges4545 bronze badges asked Mar 30, 2017 at 12:42 [](https://stackoverflow.com/users/7749708/ritesh-tiwari) [Ritesh Tiwari](https://stackoverflow.com/users/7749708/ritesh-tiwari) 12911 gold badge11 silver badge55 bronze badges 3 - Is your goal is to order the items in the collection? Dave Bennett – [Dave Bennett](https://stackoverflow.com/users/4187346/dave-bennett "11,276 reputation") 2017-03-30 12:53:33 +00:00 Commented Mar 30, 2017 at 12:53 - yes @Dave Bennet Ritesh Tiwari – [Ritesh Tiwari](https://stackoverflow.com/users/7749708/ritesh-tiwari "129 reputation") 2017-03-30 12:56:26 +00:00 Commented Mar 30, 2017 at 12:56 - Suppose i have multiple collection and i merge all collection then how can i order by it like : `MATCH(u:User)-[r:CreatedBy]->(p:Project) WITH COLLECT({name:p.name,date:p.date}) AS info MATCH(i:Institue)-[owner:Owner]->(i:Institute) WITH COLLECT({instituteName:i.name,date:i.date}) AS instituteinfo,info WITH COLLECT(instituteinfo + info) AS alldata RETURN alldata` in this query i want order by date Ritesh Tiwari – [Ritesh Tiwari](https://stackoverflow.com/users/7749708/ritesh-tiwari "129 reputation") 2017-03-30 13:11:08 +00:00 Commented Mar 30, 2017 at 13:11 [Add a comment](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect "Use comments to ask for more information or suggest improvements. Avoid answering questions in comments.") \| ## 1 Answer 1 Sorted by: [Reset to default](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect?answertab=scoredesc#tab-top) 10 You simply need to order the user nodes by the attribute of your choice prior to collecting them. Something like this.., ``` MATCH(u:User) WITH u ORDER BY u.name WITH COLLECT({name:u.name,date:u.date}) AS userinfo RETURN userinfo ``` Or if you were looking to combine multiple collections and produce a single ordered collection you could recombine them something like this... ``` MATCH(u:User)-[r:CreatedBy]->(p:Project) WITH COLLECT({name:p.name, date:p.date}) AS info MATCH(i:Institue)-[owner:Owner]->(i:Institute) WITH COLLECT({instituteName:i.name, date:i.date}) AS instituteinfo,info WITH instituteinfo + info AS alldata UNWIND alldata as node WITH node ORDER BY node.name WITH COLLECT (DISTINCT node) as alldata RETURN alldata ``` [Share](https://stackoverflow.com/a/43118658 "Short permalink to this answer") [Improve this answer](https://stackoverflow.com/posts/43118658/edit) Follow [edited Mar 30, 2017 at 13:30](https://stackoverflow.com/posts/43118658/revisions "show all edits to this post") answered Mar 30, 2017 at 13:00 [](https://stackoverflow.com/users/4187346/dave-bennett) [Dave Bennett](https://stackoverflow.com/users/4187346/dave-bennett) 11\.3k33 gold badges3434 silver badges4545 bronze badges Sign up to request clarification or add additional context in comments. ## 3 Comments Add a comment [](https://stackoverflow.com/users/7749708/ritesh-tiwari) Ritesh Tiwari [Ritesh Tiwari](https://stackoverflow.com/users/7749708/ritesh-tiwari) [Over a year ago](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect#comment73316639_43118658) No because suppose i have multiple collection so in that case how can i do order by e.g \`` 2017-03-30T13:05:41.913Z+00:00 0 Reply - Copy link [](https://stackoverflow.com/users/7749708/ritesh-tiwari) Ritesh Tiwari [Ritesh Tiwari](https://stackoverflow.com/users/7749708/ritesh-tiwari) [Over a year ago](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect#comment73317312_43118658) Suppose i have multiple collection and i merge all collection then how can i order by it like : MATCH(u:User)-\[r:CreatedBy\]-\>(p:Project) WITH COLLECT({name:p.name,date:p.date}) AS info MATCH(i:Institue)-\[owner:Owner\]-\>(i:Institute) WITH COLLECT({instituteName:i.name,date:i.date}) AS instituteinfo,info WITH COLLECT(instituteinfo + info) AS alldata RETURN alldata in this query i want order by date 2017-03-30T13:18:32.87Z+00:00 0 Reply - Copy link [](https://stackoverflow.com/users/4187346/dave-bennett) Dave Bennett [Dave Bennett](https://stackoverflow.com/users/4187346/dave-bennett) [Over a year ago](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect#comment73317516_43118658) If you have follow on information that is really pertinent to your question you should just update your question and use the comment to refer to the update rather than post a bunch of Cyper in a comment. In the case of multiple collections that you want to combine and order, you need to combine them and unwind them, order them and then re-collect them. 2017-03-30T13:23:19.413Z+00:00 0 Reply - Copy link Add a comment Start asking to get answers Find the answer to your question by asking. [Ask question](https://stackoverflow.com/questions/ask) Explore related questions - [neo4j](https://stackoverflow.com/questions/tagged/neo4j "show questions tagged 'neo4j'") - [cypher](https://stackoverflow.com/questions/tagged/cypher "show questions tagged 'cypher'") See similar questions with these tags. - The Overflow Blog - [The 2025 Stack Overflow and Stack Exchange wrap—our top ten questions of the...](https://stackoverflow.blog/2025/12/17/the-2025-stack-overflow-and-stack-exchange-wrap/ "The 2025 Stack Overflow and Stack Exchange wrap—our top ten questions of the year!") - [Last week in AWS re:Invent with Corey Quinn](https://stackoverflow.blog/2025/12/19/last-week-in-aws-re-invent-with-corey-quinn/) - Featured on Meta - [Native Ads coming soon to Stack Overflow and Stack Exchange](https://meta.stackexchange.com/questions/415259/native-ads-coming-soon-to-stack-overflow-and-stack-exchange) - [A proposal for bringing back Community Promotion & Open Source Ads](https://meta.stackexchange.com/questions/416429/a-proposal-for-bringing-back-community-promotion-open-source-ads) - [Policy: Generative AI (e.g., ChatGPT) is banned](https://meta.stackoverflow.com/questions/421831/policy-generative-ai-e-g-chatgpt-is-banned) - [Stack Overflow chat opening up to all users in January; Stack Exchange chat...](https://meta.stackoverflow.com/questions/437778/stack-overflow-chat-opening-up-to-all-users-in-january-stack-exchange-chat-late "Stack Overflow chat opening up to all users in January; Stack Exchange chat later") - [Modernizing curation: A proposal for The Workshop and The Archive](https://meta.stackoverflow.com/questions/437757/modernizing-curation-a-proposal-for-the-workshop-and-the-archive) #### Related [3](https://stackoverflow.com/questions/19183348/neo4j-cypher-query-using-order-by-with-collects "Question score (upvotes - downvotes)") [Neo4j cypher query : using ORDER BY with COLLECT(S)](https://stackoverflow.com/questions/19183348/neo4j-cypher-query-using-order-by-with-collects) [1](https://stackoverflow.com/questions/22216195/how-to-order-by-the-result-of-combining-multiple-collect "Question score (upvotes - downvotes)") [How to order by the result of combining multiple collect?](https://stackoverflow.com/questions/22216195/how-to-order-by-the-result-of-combining-multiple-collect) [2](https://stackoverflow.com/questions/22951625/neo4j-collect-and-sort-together "Question score (upvotes - downvotes)") [Neo4j COLLECT and SORT together](https://stackoverflow.com/questions/22951625/neo4j-collect-and-sort-together) [8](https://stackoverflow.com/questions/26341916/cypher-neo4j-order-by-desc-query "Question score (upvotes - downvotes)") [Cypher Neo4j ORDER BY DESC query](https://stackoverflow.com/questions/26341916/cypher-neo4j-order-by-desc-query) [2](https://stackoverflow.com/questions/28433163/order-by-collection-member-in-neo4j "Question score (upvotes - downvotes)") [Order by collection member in Neo4j](https://stackoverflow.com/questions/28433163/order-by-collection-member-in-neo4j) [1](https://stackoverflow.com/questions/31728433/sorting-by-elements-in-collection-in-cypher-query "Question score (upvotes - downvotes)") [Sorting by Elements in Collection in Cypher Query](https://stackoverflow.com/questions/31728433/sorting-by-elements-in-collection-in-cypher-query) [1](https://stackoverflow.com/questions/37379966/how-to-use-order-by-and-aggregating-results-together-in-cypher-query "Question score (upvotes - downvotes)") [how to use ORDER BY and aggregating results together in cypher query](https://stackoverflow.com/questions/37379966/how-to-use-order-by-and-aggregating-results-together-in-cypher-query) [1](https://stackoverflow.com/questions/38545645/neo4j-cypher-query-order-by-with-parameters "Question score (upvotes - downvotes)") [Neo4j cypher query ORDER BY with parameters](https://stackoverflow.com/questions/38545645/neo4j-cypher-query-order-by-with-parameters) [0](https://stackoverflow.com/questions/43415799/neo4j-cypher-query-sort-order "Question score (upvotes - downvotes)") [Neo4j Cypher query sort order](https://stackoverflow.com/questions/43415799/neo4j-cypher-query-sort-order) [0](https://stackoverflow.com/questions/60303669/cypher-query-in-neo4j-to-order-by-some-data "Question score (upvotes - downvotes)") [Cypher Query in Neo4j to ORDER BY some data](https://stackoverflow.com/questions/60303669/cypher-query-in-neo4j-to-order-by-some-data) #### [Hot Network Questions](https://stackexchange.com/questions?tab=hot) - [Why is the Coriolis force "pseudo" but the dropped ball's path isn't?](https://physics.stackexchange.com/questions/866849/why-is-the-coriolis-force-pseudo-but-the-dropped-balls-path-isnt) - [Trying to find a book I read in middle school ('95-'00) about a prince(?) forced to flee after usurpation, then leads a resistance group](https://literature.stackexchange.com/questions/31230/trying-to-find-a-book-i-read-in-middle-school-95-00-about-a-prince-forced) - [How to define a context-free grammar for whitespace-based operator precedence?](https://langdev.stackexchange.com/questions/4683/how-to-define-a-context-free-grammar-for-whitespace-based-operator-precedence) - [Arguments parsing for two-actions list in C++](https://codereview.stackexchange.com/questions/300795/arguments-parsing-for-two-actions-list-in-c) - [Unexpected use of the infinitive for future or due action](https://ell.stackexchange.com/questions/373507/unexpected-use-of-the-infinitive-for-future-or-due-action) - [What is an English idiom for the Urdu expression "B..." (often used when a person is overconcerned about something that shouldn't really concern them)](https://english.stackexchange.com/questions/638269/what-is-an-english-idiom-for-the-urdu-expression-b-often-used-when-a-perso) - [What disaster recovery solutions are available if my storage already does the replication?](https://dba.stackexchange.com/questions/349481/what-disaster-recovery-solutions-are-available-if-my-storage-already-does-the-re) - [Measuring inductor losses](https://electronics.stackexchange.com/questions/763396/measuring-inductor-losses) - [Check if a macro internally contains inner macros](https://tex.stackexchange.com/questions/757284/check-if-a-macro-internally-contains-inner-macros) - [Can a Barbarian in a Rage spend a Bonus Action and enter a new Rage in order to use Instinctive Pounce?](https://rpg.stackexchange.com/questions/218328/can-a-barbarian-in-a-rage-spend-a-bonus-action-and-enter-a-new-rage-in-order-to) - [How can the golden ratio secretly appear as a root of a sixth-degree polynomial?](https://math.stackexchange.com/questions/5115510/how-can-the-golden-ratio-secretly-appear-as-a-root-of-a-sixth-degree-polynomial) - [How do I transcribe a Shape Sudoku into a Google Sheets?](https://puzzling.stackexchange.com/questions/136359/how-do-i-transcribe-a-shape-sudoku-into-a-google-sheets) - [What's the meaning of highlighted artifact's Affixes?](https://gaming.stackexchange.com/questions/417422/whats-the-meaning-of-highlighted-artifacts-affixes) - [Use of numerical derivatives in statistics](https://stats.stackexchange.com/questions/673987/use-of-numerical-derivatives-in-statistics) - [Does Reformed Theology assert that God made Abraham believe?](https://christianity.stackexchange.com/questions/112576/does-reformed-theology-assert-that-god-made-abraham-believe) - [Why was Jesus not given the privilege of appeal to Caesar?](https://hermeneutics.stackexchange.com/questions/113277/why-was-jesus-not-given-the-privilege-of-appeal-to-caesar) - [PNP Inverter + MOSFET Gate Driver Understanding/Sizing](https://electronics.stackexchange.com/questions/763333/pnp-inverter-mosfet-gate-driver-understanding-sizing) - [Where/what is the (legal/administrative) distinction between "flying high" and "orbiting low"?](https://aviation.stackexchange.com/questions/114764/where-what-is-the-legal-administrative-distinction-between-flying-high-and) - [US I-94 admit until date](https://travel.stackexchange.com/questions/202863/us-i-94-admit-until-date) - [Probability that the stopping time for 3 consecutive sixes is odd](https://math.stackexchange.com/questions/5115889/probability-that-the-stopping-time-for-3-consecutive-sixes-is-odd) - [How current job is appointed by Bash?](https://unix.stackexchange.com/questions/803147/how-current-job-is-appointed-by-bash) - [Trying to Save Powershell Command Result Into a Batch Script Variable](https://serverfault.com/questions/1197417/trying-to-save-powershell-command-result-into-a-batch-script-variable) - [Why does Mtt 27:19 mention the post- dream message of Pilate's wife?](https://hermeneutics.stackexchange.com/questions/113301/why-does-mtt-2719-mention-the-post-dream-message-of-pilates-wife) - [A seeming contradiction on Wilks' Theorem of asymptotic behaviour of likelihood ratio](https://stats.stackexchange.com/questions/673963/a-seeming-contradiction-on-wilks-theorem-of-asymptotic-behaviour-of-likelihood) [more hot questions](https://stackoverflow.com/questions/43118215/neo4j-cypher-query-order-by-with-collect) [Question feed](https://stackoverflow.com/feeds/question/43118215 "Feed of this question and its answers") # Subscribe to RSS Question feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.  ##### [Stack Overflow](https://stackoverflow.com/) - [Questions](https://stackoverflow.com/questions) - [Help](https://stackoverflow.com/help) - [Chat](https://chat.stackoverflow.com/?tab=explore) ##### [Business](https://stackoverflow.co/) - [Stack Internal](https://stackoverflow.co/internal/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=teams) - [Stack Data Licensing](https://stackoverflow.co/data-licensing/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=data-licensing) - [Stack Ads](https://stackoverflow.co/advertising/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=advertising) ##### [Company](https://stackoverflow.co/) - [About](https://stackoverflow.co/) - [Press](https://stackoverflow.co/company/press/) - [Work Here](https://stackoverflow.co/company/work-here/) - [Legal](https://stackoverflow.com/legal) - [Privacy Policy](https://stackoverflow.com/legal/privacy-policy) - [Terms of Service](https://stackoverflow.com/legal/terms-of-service/public) - [Contact Us](https://stackoverflow.com/contact) - Cookie Settings - [Cookie Policy](https://policies.stackoverflow.co/stack-overflow/cookie-policy) ##### [Stack Exchange Network](https://stackexchange.com/) - [Technology](https://stackexchange.com/sites#technology) - [Culture & recreation](https://stackexchange.com/sites#culturerecreation) - [Life & arts](https://stackexchange.com/sites#lifearts) - [Science](https://stackexchange.com/sites#science) - [Professional](https://stackexchange.com/sites#professional) - [Business](https://stackexchange.com/sites#business) - [API](https://api.stackexchange.com/) - [Data](https://data.stackexchange.com/) - [Blog](https://stackoverflow.blog/?blb=1) - [Facebook](https://www.facebook.com/officialstackoverflow/) - [Twitter](https://twitter.com/stackoverflow) - [LinkedIn](https://linkedin.com/company/stack-overflow) - [Instagram](https://www.instagram.com/thestackoverflow) Site design / logo © 2025 Stack Exchange Inc; user contributions licensed under [CC BY-SA](https://stackoverflow.com/help/licensing) . rev 2025.12.19.38237