hi all,
we are working on a traceability graph for a product production process.
This is a pilot for us and we are still learning modelling and the cypher query language (after following some Neo4j training).
The production process has diverging an converging paths. A simplified version of our graph is shown below. All Products (green) in the graph can be sold and in that case will have a quality check (not always shown).
I would like to return a path from a sold product back to a supplied product that did not pass a quality check. The supplied product ("Crop" or "Ingredient") has two leave nodes; a supplier and a certificate.
I can define a query that returns the supplied product and either the supplier or the certificate info, but not both.
Example query:
MATCH path = ((:Customer)<-[DELIVERED_TO]-(:Product:SalesItem)<-[*1..4]-(c:Crop)-[IS_CERTIFIED]->(:Certificate {passed_inspection:'false'})) RETURN path
I would like to add something like the following to return the Farm-information
, (c)-[GROWN_ON]->(f:Farm)
Is this possible with a Cypher query?
Do we need to modify our model?
Thanks