Need help in cypher query for this required layout

[Prasanth2994]

I am new to Neo4j,

I am using this query to get the below layout in traversing the path

MATCH p = (r:Reports)<--(s:Schedules)<--(m:MDRMs)<--(br:Business_Requirements)-->(rp: Report_Logic)-->(ra: Reporting_layer_attributes)

where r.Report_Name ='FFIEC 031' and s.Schedule = 'RC-B - Securities' RETURN p

Blue coloured nodes are referred as Business_Requirements which have additional linked Silver coloured (Business_Attributes) nodes with relationship as MAPPED_TO . 

Please help me in bringing out the below layout through cypher query. Since the silver color nodes are not in the path, i was not able to pull the below required layout

[glilienfield]

One approach to determine the silver nodes could be: extract the blue nodes from the path by label and then match those to the silver ones. Return these with your path. 

another approach is to use one of the apoc path procedures to get all the nodes. 

https://neo4j.com/labs/apoc/4.1/overview/apoc.path/

[ameyasoft · Accepted solution]

Try this:

match (a:Schedules) where a.schedule = "RC-B - Securities"
CALL apoc.path.spanningTree(a, {maxLevel:5}) yield path
return path