I have a scenario where:
[Vertex|Class = Company] <-- [Edge|Class = Test1 {'a':'b'}] -- [Vertex|Class = Test2 {'c':'de'}]
I know the CompanyID so I would like to return in a query Test1.a and Test2.c (in multiples) attached to the Company.
This should be simple enough but I have hit an absolute wall. I've tried:
SELECT inE(Test1).a,inV(Test2).c FROM Company WHERE CompanyID = 123
SELECT a,c FROM (TRAVERSE both() FROM #27:16)` (@rid of Company 123)
SELECT bothE(Test1),both(Test2).c FROM Company WHERE CompanyID = 123
Option 3 here returns results grouped and I need them expanded per line. Can someone please explain why my queries arent working.
The closest I've come is SELECT a,c FROM (TRAVERSE bothV(),bothE() FROM #27:16) WHERE @class = 'Test1' OR @class = 'Test2' however this return a/c results on different lines!
So as per @Ironluca suggestion - yes I can manipulate MATCH to do what I need however is there not a way this can be done with SELECT directly instead? Seems a bit Neo4j for my liking.