Hi all,
I am facing an issue while writing the cypher query for below graph, here I have such paths for different months and many more such paths are there like 01-08-2021, 01-09-2021, 01-10-2021, 01-11-2021 and so on:
I want to write a cypher query that will help me in assigning a property value from 01-08-2021 path node to the next path node which is 01-09-2021.
I tried this if it helps me identify the next path basis the previous path, then I will set the property etc. but this doesn;t work
match p=(v:Production)-[j:transport]->(x:Storage)-[q:transport]->(c:Storage)-[b:transport]->(d:Storage)
with min(v.date) as dt
match p=(v:Production)-[j:transport]->(x:Storage)-[q:transport]->(c:Storage)-[b:transport]->(d:Storage)
where v.date=dt
optional match s=(m:Production)-[n:transport]->(u:Storage)-[o:transport]->(x:Storage)-[z:transport]->(f:Storage)
where m.date=dt+duration('P1M')
return s;
Thanks,
Pragya