This is a console limitation, if you use API or REST you already have what you need.
Lvc@ On 24 March 2014 18:42, Dodong Juan <[email protected]> wrote: > anyone ..? > > > On Friday, March 21, 2014 12:54:32 PM UTC-4, Dodong Juan wrote: >> >> I have the following DB: >> >> >> create class Customer extends V >> >> create class Car extends V >> >> create class Dealer extends V >> >> create class Owns extends E >> >> >> insert into Customer(first,last) values ('John','Doe') >> >> insert into Customer(first,last) values ('James','Bond') >> >> insert into Customer(first,last) values ('Tony','Stark') >> >> >> >> insert into Dealer(name,city,state) values ('Open Cars','New York','NY') >> >> insert into Dealer(name,city,state) values ('Side Cars','Jersey >> City','NJ') >> >> >> insert into Car(year,brand,model) values ('2014','Audi','R8') >> >> insert into Car(year,brand,model) values ('2012','Audi','TTRS') >> >> insert into Car(year,brand,model) values ('2014','BMW','M3') >> >> insert into Car(year,brand,model) values ('2012','Jaguar','XKJ') >> >> >> >> orientdb {testdb}> select from Car >> >> >> ----+-----+----+------+----- >> >> # |@RID |year|brand |model >> >> ----+-----+----+------+----- >> >> 0 |#13:0|2014|Audi |R8 >> >> 1 |#13:1|2014|BMW |M3 >> >> 2 |#13:2|2012|Jaguar|XKJ >> >> 3 |#13:3|2012|Audi |TTRS >> >> ----+-----+----+------+----- >> >> >> 3 item(s) found. Query executed in 0.0010 sec(s). >> >> orientdb {testdb}> select from Customer >> >> >> ----+-----+-----+----- >> >> # |@RID |first|last >> >> ----+-----+-----+----- >> >> 0 |#12:0|John |Doe >> >> 1 |#12:1|James|Bond >> >> 2 |#12:2|Tony |Stark >> >> ----+-----+-----+----- >> >> >> 3 item(s) found. Query executed in 0.0010 sec(s). >> >> >> // >> >> // Now create car ownership >> >> // >> >> >> // Tony owns all Audis >> >> >> orientdb {testdb}> create edge Owns from #12:2 to #13:0 >> >> >> Created edge '[Owns{in:#13:0,out:#12:2}]' in 0.042000 sec(s). >> >> >> orientdb {testdb}> create edge Owns from #12:2 to #13:3 >> >> >> Created edge '[Owns{in:#13:3,out:#12:2}]' in 0.004000 sec(s). >> >> >> // James owns BMW and and Audi R8 >> >> >> >> orientdb {testdb}> create edge Owns from #12:1 to #13:0 >> >> orientdb {testdb}> create edge Owns from #12:1 to #13:1 >> >> >> >> So I can query for all the customer that owns an Audi >> >> >> orientdb {testdb}> select from (traverse in_Owns from (select from Car >> where brand='Audi')) where @class='Customer' >> >> >> ----+-----+--------+-----+----- >> >> # |@RID |out_Owns|first|last >> >> ----+-----+--------+-----+----- >> >> 0 |#12:2|[size=2]|Tony |Stark >> >> 1 |#12:1|[size=2]|James|Bond >> >> ----+-----+--------+-----+----- >> >> >> >> But how do I do the query if I want to display in a single table owner >> first , last and the year,brand,model of the car they own ..? >> >> >> >> -- > > --- > 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.
