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]>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]. > 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.
