I'm working with a database that tracks IOUs. People are nodes (Person) and IOUs are relationships (OWES). OWES has a property of Date.
I need to search for simple circuits (paths that originate and end with the same node), and identify the circuit that includes the oldest transaction (OWES:Date).
To search for paths I've got:
MATCH p=(a)-[*]->(a)
When there is more than one path, I want to find the one that includes the relationship with the smallest value in the Date property.
I'm a Cypher newbie, and any suggestions would be greatly appreciated!
Similarly, once I've found the path with the oldest transaction, I need to find the transaction in that path that has the lowest Amount. More specifically, I just need to have the amount.
Looking for some to resolve a query requires calculating 2 flights involved in total journey. Could you please help.
MATCH (sapt:Airport{airportName:"Sochi International Airport"}),(cba:Airport{airportName:"Chelyabinsk Balandino Airport"}), path = shortestPath((sapt)-[]-(cba)) with path
MATCH (p:Flight) WHERE p.flightID STARTS WITH '' RETURN sum(p.duration)AS Total_Duration, path