Getting last relationship from variable length path

[amit-suryavansh]

Need little help with Cypher. My Cypher is,

MATCH p=(user)-[r1:roles]->(role1:`Role`)-[:include*1..]->(role2:`Role`)
RETURN collect(tail(relationships(p))), collect(role2)

For a path where include relation is more than 1 level deep, it gives all include relations for that path as array with corresponding role2. Where as I want just the last relationship and the respective node.
Thanks.

[amit-suryavansh · Accepted solution]

Got the answer

RETURN collect(last(relationships(p))), collect(role2)

Thanks.