CODEWITHSUNDEEP
orientdbtype-conversion
Catalin Vladu
Catalin Vladu

Reputation: 389

Type conversion in Orientdb

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.

Upvotes: 0

Views: 61

Answers (1)

Alessandro Rota
Alessandro Rota

Reputation: 3570

You could use

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

Hope it helps

Upvotes: 1

Related Questions