This worked
select in.name, rating from E where out = #14:0 and @class in ['Rates',
'Owns'] group by in
On Tuesday, May 12, 2015 at 2:32:50 PM UTC-7, Joris de Geringel wrote:
>
> 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 outE('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.
