orientdb icon indicating copy to clipboard operation
orientdb copied to clipboard

How to get Vertex and Edge Data with SQL

Open AstionMartionChan opened this issue 4 years ago • 1 comments

OrientDB Version: 3.0.0

Java Version: 1.8

Expected behavior

When I execute SQL through Studio Graph interface, it return Vertex and Edge data, but when I executes the same SQL through Java API(ODatabaseSession) it return only Vertex data. I found that the SQL query through Graph interface, the request header has the "mode=graph" set, so i want to ask how can i set mode=graph and get Vertex and Edge data in Java API?

select expand($c) let $person = (select * from MockPerson where membership='3'), $phone = (select * from MockPhone where membership='3'), $c = unionAll( $person, $phone )

AstionMartionChan avatar Nov 27 '20 08:11 AstionMartionChan

Could you please write here the snippet in Java API that executes the query above?

lvca avatar Dec 21 '20 08:12 lvca