Type conversion in Orientdb

Question

I have a query in Orientdb like this:

select out('E_MyEdge').@rid, creationUser from V_MyVertex where out('E_MyEdge').@rid <> creationUser

V_MyVertex is a vertex, E_MyEdge is an edge. creationUser is a property of type "LINK" from V_MyVertex, which is an "rid" (something like "#12:4"). The problem is both columns from result are kind of "rid", but the query returns also the rows which have the same value (for example #12:117 | #12:117), and I don't know how to exclude them from the result.

Is your goal to select all outgoing vertices from a vertex,which is not connected at the vertex linked in creationUser ? — Alessandro Rota
The original select is without this "where" clause, and I have to add this clause to exclude some records. — Catalin Vladu

Alessandro Rota Alessandro Rota · Accepted Answer · 2016-07-29T13:34:38

You could use

select out('E_MyEdge').@rid, creationUser from V_MyVertex where out('E_MyEdge').@rid NOT IN creationUser

Hope it helps

Type conversion in Orientdb

1 Answers