apoc.coll.sortMulti
Syntax |
|
||
Description |
Sorts the given |
||
Arguments |
Name |
Type |
Description |
|
|
The list of maps to be sorted. |
|
|
|
The property keys to be used to sort the list of maps by. The default is: |
|
|
|
The amount of results to return. The default is: |
|
|
|
The amount to skip by. The default is: |
|
Returns |
|
Usage examples
The following sorts a list of maps by the name
property in ascending order:
RETURN apoc.coll.sortMulti([
{name:'graphs'},
{name:'are',age:32},
{name:'everywhere',age:42}
], ['^name']) as output;
Output |
---|
[{name: "are", age: 32}, {name: "everywhere", age: 42}, {name: "graphs"}] |
The following sorts a list of maps by the name
property in ascending order and then the age
property in descending order:
RETURN apoc.coll.sortMulti([
{name:'graphs'},
{name:'are',age:32},
{name:'are',age:21},
{name:'everywhere'}
], ['^name', 'age']) as output;
Output |
---|
[{name: "are", age: 32}, {name: "are", age: 21}, {name: "everywhere"}, {name: "graphs"}] |
The following sorts a list of maps by the name
property in ascending order and returns only one value:
RETURN apoc.coll.sortMulti([
{name:'graphs'},
{name:'are'},
{name:'everywhere'}
], ['^name'], 1) as output;
Output |
---|
[{name: "are"}] |
The following sorts a list of maps by the name
property in ascending order and skips the first value:
RETURN apoc.coll.sortMulti([
{name:'graphs'},
{name:'are'},
{name:'everywhere'}
], ['^name'], -1, 1) as output;
Output |
---|
[{name: "everywhere"}, {name: "graphs"}] |
The following sorts a list of maps by the name
property in ascending order, skips the first value, and returns only one value:
RETURN apoc.coll.sortMulti([
{name:'graphs'},
{name:'are'},
{name:'everywhere'}
], ['^name'], 1, 1) as output;
Output |
---|
[{name: "everywhere"}] |