I have the following relationships (where the keywords in CAPS are edges, lowercase keywords are vertices). The dc vertex is the main Object in my model:
dc -- LOCATED_IN --> city -- LOCATED_IN --> country -- LOCATED_IN --> continent
dc -- IS_USED_IN --> project -- IS_OWNED_BY --> user
What I need is for a specific Continent selection (#13:0) all DC's and their Projects owned by User 'X'
So far I tried using LET keyword to unionall queries and expand the result, but I'm not getting the results I want.
I want to have something like this (non working example):
SELECT *, out('IS_USED_IN').include('name') as project FROM dc
WHERE
( out(IS_LOCATED_IN).out(IS_LOCATED_IN).out(IS_LOCATED_IN).@rid = #13:0 )
AND
( .out(IS_USED_IN).out(IS_OWNED_BY).name = 'X' )
How can I chain these relationships and query on a specific field? (@rid, name and so on)