MATCH (p:Post)-[FILED_IN]->(t:Topic) return p
But what if we need to retrieve next post. It will be convenient to have a relation to the next post. We can add this relation anytime using the following Cypher.
MATCH (p:post)-[FILED_IN]->(t:Topic) WITH p ORDER BY p.timestamp WITH COLLECT(p) AS posts UNWIND RANGE(0,LENGTH(posts) - 2) as idx WITH posts[idx] AS p1, posts[idx+1] AS p2 MERGE (p1)-[:NEXT]->(p2)