Yes it does. Many thanks!
Op woensdag 13 mei 2015 03:13:51 UTC+2 schreef Ziink A:
>
> This worked
> select in.name, rating from E where out = #14:0 and @class in ['Rates',
> 'Owns'] group by in
>
> also
> select distinct(in.name) as name, rating from (select expand(outE('Rates',
> 'Owns')) from #13:0)
>
> 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.
