apoc.coll.sortMaps

Function

apoc.coll.sortMaps(list LIST<MAP<STRING, ANY>>, prop STRING) - sorts the given LIST<MAP<STRING, ANY>> into descending order, based on the MAP property indicated by prop.

Signature

apoc.coll.sortMaps(coll :: LIST<MAP>, prop :: STRING) :: LIST<ANY>

Input parameters

Name Type Default

coll

LIST<MAP>

null

prop

STRING

null

Usage examples

The following sorts a list of maps in reverse alphabetical order by the key name:

RETURN apoc.coll.sortMaps([
    {name: "Lionel Messi"},
    {name: "Cristiano Ronaldo"},
    {name: "Wayne Rooney"}
], "name") AS output;
Table 1. Results
Output 
[
    {
      "name": "Wayne Rooney"
    }
    ,
    {
      "name": "Lionel Messi"
    }
    ,
    {
      "name": "Cristiano Ronaldo"
    }
]

The following sorts a list of maps in alphabetical order by the key name:

RETURN apoc.coll.sortMaps([
    {name: "Lionel Messi"},
    {name: "Cristiano Ronaldo"},
    {name: "Wayne Rooney"}
], "^name") AS output;
Table 2. Results
Output 
[
    {
      "name": "Cristiano Ronaldo"
    }
    ,
    {
      "name": "Lionel Messi"
    }
    ,
    {
      "name": "Wayne Rooney"
    }
]