(bow) thanks a ton :) On Monday, March 17, 2014 7:08:42 PM UTC+5:30, Andrey Lomakin wrote: > > HI, > You should provide fetchPlan > https://github.com/orientechnologies/orientdb/wiki/OrientDB-REST#queryand > https://github.com/orientechnologies/orientdb/wiki/Fetching-Strategies > > > On Mon, Mar 17, 2014 at 3:31 PM, Vikas Iyengar > <[email protected]<javascript:> > > wrote: > >> Well, this is clear, however when i run the query, i get the number of >> items in the collection e.g. [2],[3] and not the names of the cars. >> >> Sample JSON output: >> >> {"result":[{"@type":"d","@rid":"#-2:1","@version":0,"name":"Luca","cars":[2]},{"@type":"d","@rid":"#-2:2","@version":0,"name":"Bill","cars":[0]},{"@type":"d","@rid":"#-2:3","@version":0,"name":"Jay","cars":[1]}]} >> >> >> On Monday, March 17, 2014 6:51:59 PM UTC+5:30, Riccardo Tasso wrote: >> >>> Figure out what you are looking for: persons? Then you'll need: >>> SELECT FROM Person >>> >>> Now, what are you looking for: name and cars for each Person: >>> SELECT name, out('drives').name as cars FROM Person >>> >>> Please note that cars is a collection, since one Person may be related >>> from zero to many cars. >>> >>> Cheers, >>> Riccardo >>> >>> >>> 2014-03-17 13:34 GMT+01:00 Vikas Iyengar <[email protected]>: >>> >>>> Hi All, >>>> >>>> I am new to OrientDB and have following structure: >>>> >>>> 1) Vertex - Person - Luca, Jay, Tom, Henry >>>> 2) Vertex - Car - Ferrari, Audi, Chevrolet >>>> 3) Vertex - Restaurant - Dante, McD, Hyatt >>>> 4) Edge - Eats - >>>> Luca -> Eats-> Dante, >>>> Luca -> Eats-> McD >>>> Jay -> Eats -> McD >>>> Tom -> Eats -> Dante >>>> Henry -> Eats -> Dante >>>> 5) Edge - Drives - >>>> Luca -> Drives -> Audi >>>> Luca -> Drives -> Ferrari >>>> Jay -> Drives -> Chevrolet >>>> Tom -> Drives ->Audi >>>> Henry -> Drives -> Ferrari >>>> Henry -> Drives -> Chevrolet >>>> >>>> Now, i want to write a SQL that lists the name of the Person and the >>>> Car they Drive, who eat at Dante >>>> >>>> I tried, "Select expand(in('Eats').out('Drives')) from Restaurant >>>> where name = 'Dante' " >>>> >>>> This only prints the name of the Cars, not the name of the Person. >>>> >>>> Please, help me with the same. >>>> >>>> -- >>>> >>>> --- >>>> 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. >>>> >>> >>> -- >> >> --- >> 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.
