I'm struggeling with a select query, hope someone can help me out.
Between *Item*(vertex) and *User*(vertex) we have two Edges (*Owns *and
*Rates*).
I want a select query of all the *Items *a *User **Owns *and the *Rates*
.rating.
It should look like:
name | rating
name1 | 2
name2
name3 | 4
(3 rows returned)
I tried:
select out("Owns").name as name, outE("Rates")['rating'] as rating from
#14:0 (this is a User)
Result:
name | rating
["name1", "name2", "name3"] | [2,4]
So that's pretty close but not very usefull. So I tried expanding it.
I tried:
select out('Rates').rating as rating, expand(out('Owns').name) from #14:0
name
name1
name2
name3
It ignores the rating all together.
What am I missing here ;)
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.