My original goal was to start a graph navigation with multiple items ( in condition)
So I try to do this way. (Assume all part are created by same user)
Start graph navigation from Part A
Use Case: to connect to all Part that having same property value with Part A (and further)
The query is like:
1.Part
↓ (created_by_id)
2.User
↓ (filter like 1.Part.para1 = 3.Part.para1)
3.Part
How can I get the [Part A].para1 value to fill in the filter?
The image of query in SQL is like this:
SELECT something
FROM Part p1
LEFT JOIN USER u1
ON p1.CREATED_BY_ID = u1.ID
RIGHT JOIN Part p2
ON u1.ID = p2.CREATED_BY_ID
WHERE p1.id = '{Part A ID}' AND p2.para1 = p1.para1