Hi, Andrey
Thank you, it's work!
четверг, 27 марта 2014 г., 17:59:54 UTC+4 пользователь Andrey Lomakin
написал:
>
> Hi,
> So do you mean something like
> "select content, out('author')[0].username from Article"
> ?
>
>
> On Wed, Mar 26, 2014 at 10:58 PM, vadim kulibaba
> <[email protected]<javascript:>
> > wrote:
>
>> Hello
>>
>> I have 2 vertex:
>> - Article with field content
>> - User with field username
>>
>> And edge author
>>
>> Is it possible in orientdb return in results fields content and username?
>>
>> Something like this:
>> select content, (select top 1 from user where userid=article.userid) as
>> username from article
>>
>> I only found this solution:
>> traverse in_author from (select * from Article)
>>
>> but it returns all results mixed:
>>
>> e:#11:1->#12:0
>> #12:0:v(Article)[#12:0]:content:nnn2345
>> #12:0:v(Article)[#12:0]:modified:1395864706670
>> #11:1:v(User)[#11:1]:remember:true
>> #11:1:v(User)[#11:1]:username:23456
>> #11:1:v(User)[#11:1]:email:22@2
>> #11:1:v(User)[#11:1]:password:11111
>> e:#11:0->#12:1
>> #12:1:v(Article)[#12:1]:content:1
>> #12:1:v(Article)[#12:1]:modified:1395864726851
>> #11:0:v(User)[#11:0]:remember:true
>> #11:0:v(User)[#11:0]:username:12345
>> #11:0:v(User)[#11:0]:email:1@11
>> #11:0:v(User)[#11:0]:password:11111
>> e:#11:0->#12:2
>> #12:2:v(Article)[#12:2]:content:2
>> #12:2:v(Article)[#12:2]:modified:1395864732477
>>
>> And i need join article and user manualy.
>>
>> Thx
>>
>> --
>>
>> ---
>> 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.
>>
>
>
>
> --
> Best regards,
> Andrey Lomakin.
>
> Orient Technologies
> the Company behind OrientDB
>
>
--
---
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.
