Awesome! FWIW, the desired result is achieved without the GROUP BY at the end. So the following does the same thing:
SELECT DriverID, DriverName, list(CarCost) FROM ( MATCH {...} RETURN ...) I have to admit that I still don't fully understand what list() is doing. The documentation doesn't quite get me there. The good news is that I can do what I want to do. Thanks so much for your help. -Michael On Thursday, March 7, 2019 at 6:28:15 AM UTC-5, Luigi Dell'Aquila wrote: > > SELECT > DriverID, DriverName, list(CarCost) > FROM ( ... ) > GROUP BY DriverID, DriverName > > Il giorno gio 7 mar 2019 alle ore 12:27 Luigi Dell'Aquila < > luigi.de...@gmail.com <javascript:>> ha scritto: > >> oh, sorry, I didn't scroll the screen :D >> >> You have to use a set() or list() aggregation on CarCost and do a GROUP >> BY on the other columns >> >> Thanks >> >> Luigi >> >> Il giorno gio 7 mar 2019 alle ore 12:26 Luigi Dell'Aquila < >> luigi.de...@gmail.com <javascript:>> ha scritto: >> >>> Hi Michael, >>> >>> Just add a DISTINCT to the RETURN, ie >>> >>> RETURN DISTINCT driver.@rid AS DriverID, driver.name AS DriverName, >>> car.cost AS CarCost >>> >>> Thanks >>> >>> Luigi >>> >>> Il giorno mer 6 mar 2019 alle ore 22:46 Michael Faughn < >>> m.fa...@prometheuscomputing.com <javascript:>> ha scritto: >>> >>>> SELECT * FROM (MATCH {Class: Person, as: driver, where:(name='Bob')}- >>>> Driving->{Class: Vehicle, as:car} RETURN driver.@rid AS DriverID, >>>> driver.name AS DriverName, car.cost AS CarCost) >>>> >>>> results in the following: >>>> >>>> DriverID >>>> DriverName >>>> CarCost >>>> #332:0 >>>> <http://localhost:2480/studio/index.html#/database/test/browse/edit/332:0> >>>> Bob >>>> 222 >>>> #332:0 >>>> <http://localhost:2480/studio/index.html#/database/test/browse/edit/332:0> >>>> Bob >>>> 111 >>>> >>>> I would instead like the following: >>>> >>>> DriverID >>>> DriverName >>>> CarCost >>>> #332:0 >>>> <http://localhost:2480/studio/index.html#/database/test/browse/edit/332:0> >>>> Bob >>>> [222, 111] >>>> >>>> Is there a way to write the query so that this can happen? >>>> >>>> -- >>>> >>>> --- >>>> 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 orient-databa...@googlegroups.com <javascript:>. >>>> 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.