Thank you for your help :) Orientdb is simply awesome.
On Friday, May 8, 2015 at 5:26:12 PM UTC+3, Luigi Dell'Aquila wrote:
>
> Hi Khaled,
>
> in OrientDB 2.0.x you can just do
>
> select userID, out("Likes").movieID from User
>
> but you will obtain
>
>
> userID | movieID
> ============================
> 1 | [2, 10]
> 2 | 5
>
>
> In OrientDB 2.1 there is a new function called UNWIND that will give you
> exactly the result you expect:
>
> select userID, out("Likes").movieID from User unwind movieID
>
> Regards
>
> Luigi
>
>
> 2015-05-08 14:05 GMT+02:00 Khaled Bakhit <[email protected]
> <javascript:>>:
>
>> Dear all,
>>
>> I need some helping writing a basic query against my graph database. I'm
>> pretty new to Orient SQL, and some guidance would be really appreciated.
>>
>> I have the following Vertices/Edges:
>>
>>
>> User (userID) --- Likes -----> Movie ( movieID)
>>
>>
>> I want to know for each userid in User, which movieid did he like? And
>> have the result look like this:
>>
>> Userid | Artist ID
>> ============================
>> 1 | 2
>> 1 | 10
>> 2 | 5
>>
>>
>> Thank you for your help.
>>
>>
>>
>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
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.
