Hi Hung, You mix group and row level functions I mean that list() is group function like sum for example so if you wish to have behavior which you expected you should use let.
I did not try it but it should work. select Name, $a as Fields from Contact let a = (select list(Fields.Name) where @rid = $parent.$current.@rid from Contact) On Thu, Jan 30, 2014 at 11:16 AM, Hung Tran <[email protected]> wrote: > Hi, > > I am trying to write a single query to get some fields of parent entity, > and some fields of its child entities. However i don't know how to get it > work. I am trying to use list function, but it does not help. > > Case 1: orientdb> select Name, list(Fields.Name) as Fields from Contact > => it only returns a single row, with a list of all field name of all > contacts => does it a bug? > > Case 2: orientdb> select Name, list(Fields.Name, Fields.DisplayName) as > Fields from Contact > => the result is the same as the 1st case, with a list of a single value > instead of a list of objects ({ name, displayName }). > > Any help will be very appreciated! > > My Best, > Hung Tran > > > -- > > --- > 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/groups/opt_out. > -- 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/groups/opt_out.
