HI, You should provide fetchPlan https://github.com/orientechnologies/orientdb/wiki/OrientDB-REST#query and https://github.com/orientechnologies/orientdb/wiki/Fetching-Strategies
On Mon, Mar 17, 2014 at 3:31 PM, Vikas Iyengar <[email protected]>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]. > 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.
