How to count number of elements in a list?

[tarendran_vivek]

I am trying to count the number of elements in a list

UNWIND [{id:'0001',name:'Test',size:'10mm'}] as rows
RETURN count(rows)

However this always returns 1. For this example the return value should be 3, even if the list is empty then it should return 0.

[stefan_armbrust · Accepted solution]

Your datastructure is a 1-element array containing a map with 3 elements.

This returns 3:

unwind [{id:'0001',name:'Test',size:'10mm'}] as map
return size(keys(map))

You cannot apply size on a map, therefore use keys() to get an array of keys from the map.

[tarendran_vivek]

Thanks for the help stefen.armbruster