Commonly used Functions

String Functions

match (a) return toUpper(a.firstname);


RETURN left('hello', 3)

RETURN lTrim('   hello')

RETURN replace("hello", "l", "w")

RETURN reverse('hello')

RETURN substring('hello', 1, 3), substring('hello', 2)


RETURN toString(11.5),
toString('already a string'),
toString(true),
toString(date({year:1984, month:10, day:11})) AS dateString,
toString(datetime({year:1984, month:10, day:11, hour:12, minute:31, second:14, millisecond: 341, timezone: 'Europe/Stockholm'})) AS datetimeString,
toString(duration({minutes: 12, seconds: -60})) AS durationString

Aggregation Functions

COUNT: Counts the number of items.
```
MATCH (n:Student)
RETURN COUNT(n);
```

MAX and MIN: Find the maximum or minimum of a set of values.

MATCH (n:Student)-[r:TAKING]->(c)
RETURN MAX(r.grade), MIN(r.grade);

Date and Time Functions

date(): Creates a date from a string or a map.
```
RETURN date('2024-03-20');
```
datetime(): Creates a datetime from a string or a map.
```
RETURN datetime('2024-03-20T12:00:00');
```
duration.between(): Calculates the duration between two temporal values.
```
RETURN duration.between(date('1984-10-11'), date('2024-03-20'));
```

List Functions

COLLECT: Aggregates values into a list.

MATCH (n:Student)
RETURN COLLECT(n.firstname);

SIZE: Returns the size of a list.

MATCH (n:Student)
RETURN COLLECT(n.firstname), SIZE(COLLECT(n.firstname));

RANGE: Creates a list containing a sequence of integers.
```
RETURN RANGE(1, 10, 2);
```

Mathematical Functions

ABS: Returns the absolute value.
```
RETURN ABS(-42);
```
ROUND, CEIL, FLOOR: Round numbers to the nearest integer, up, or down.
```
RETURN ROUND(3.14159), CEIL(3.14159), FLOOR(3.14159);
```

Logical Functions

COALESCE: Returns the first non-null value in a list of expressions.
```
RETURN COALESCE(NULL, 'first non-null', NULL);
```

Spatial Functions

point: Creates a point in a 2D space (or 3D if you add elevation) which can be used for spatial queries.
```
RETURN point({latitude: 37.4847, longitude: -122.148})
```

RETURN point.distance(
  point({latitude: 39.94, longitude: -75.01}), 
  point({latitude: 39.97, longitude: -74.96})
) / 1609.34 AS distanceInMiles

apoc.coll.sort: Sorts a list.

RETURN apoc.coll.sort(['banana', 'apple', 'cherry'])

apoc.map.merge: Merges two maps.

RETURN apoc.map.merge({name: 'Neo'}, {age: 23})

PreviousPutting it all together NextData Profiling

Last updated 1 year ago

match (a) return toUpper(a.firstname); RETURN left('hello', 3) RETURN lTrim(' hello') RETURN replace("hello", "l", "w") RETURN reverse('hello') RETURN substring('hello', 1, 3), substring('hello', 2) RETURN toString(11.5), toString('already a string'), toString(true), toString(date({year:1984, month:10, day:11})) AS dateString, toString(datetime({year:1984, month:10, day:11, hour:12, minute:31, second:14, millisecond: 341, timezone: 'Europe/Stockholm'})) AS datetimeString, toString(duration({minutes: 12, seconds: -60})) AS durationString