Query does not sort, but also does not give an error

Neo4j Graph Platform
1

This query does not sort on actors

MATCH (a:Actor:Actor)-[r:ACTED_IN]->(m:Movie) 
WHERE m.year=1995
RETURN a{id: id(a), .name, born2: a.born }
      ,r{.role, age: duration.inDays(a.born, date(m.year+"-06-01")).days / 365 }
	  ,m{.title }
ORDER BY m.year,a.born ASC
LIMIT 10

If I change a.born to a.born2 it sorts, should there not be or sorting or an error when using a.born?

2

That is strange. “a” is supposed to be bound to the node, which does not have a “born2” property. “born2” is defined in your map projection, which should not replace “a”, so a.born2 should not exist.

Does the following work?

MATCH (a:Actor:Actor)-[r:ACTED_IN]->(m:Movie) 
WHERE m.year=1995
RETURN a{id: id(a), .name, born: a.born } as actor
      ,r{.role, age: duration.inDays(a.born, date(m.year+"-06-01")).days / 365 }
	  ,m{.title } 
ORDER BY m.year,actor.born ASC
LIMIT 10

Or,

MATCH (a:Actor:Actor)-[r:ACTED_IN]->(m:Movie) 
WHERE m.year=1995
WITH *
ORDER BY m.year, a.born ASC
LIMIT 10
RETURN a{id: id(a), .name, born2: a.born }
      ,r{.role, age: duration.inDays(a.born, date(m.year+"-06-01")).days / 365 }
	  ,m{.title }

In the latest release you can now use order by, limit, and skip without a preceding WITH.

3

yes both seem to sort on actors

1 Like