Try: select *, last_comment.* from Questions order by createdAt desc
Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 1 November 2015 at 15:42, Thomas Kennedy <[email protected]> wrote: > In the example below, is there anyway to avoid having the "this" returned > when using the toJSON way when using binary protocol > > > { '@type': 'd', > > this: '{"@rid":"#12:0"} > > On Sunday, 1 November 2015 21:09:18 UTC, l.garulli wrote: >> >> Hey Tommy, >> >> Fetchplan with binary drivers (orientjs) works in different way than >> HTTP: fetched objects are sent to the client, so it stores them on a local >> cache for further retrieval. Look at: >> http://orientdb.com/docs/last/Fetching-Strategies.html#remote-connection. >> >> You could rather pass the fetchplan to the *.toJSON()* function. Example: >> >> select @this.toJSON('last_comment:0') from Questions order by createdAt desc >> >> But in this case the return is a JSON, not a Document instance. >> >> Look at: >> http://orientdb.com/docs/last/Fetching-Strategies.html#export-a-document-and-its-nested-documents-in-json >> >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB <http://orientdb.com/> >> >> >> On 31 October 2015 at 13:47, Thomas Kennedy <[email protected]> wrote: >> >>> Any help would be much appreciated. >>> >>> On Wednesday, 28 October 2015 10:16:12 UTC, Thomas Kennedy wrote: >>>> >>>> I have a simple query >>>> >>>> select * from Questions fetchplan last_comment:0 order by createdAt desc >>>> >>>> I am looking for the resultset to return the last_comment expanded >>>> along with the result of the questions class. >>>> >>>> I am using a Orientjs to interface with orient. It doesnt return the >>>> expanded resultset. However when i run the above command in studio, I see >>>> it expanded. >>>> >>>> What do i need to do here? >>>> >>>> Orientdb v2.0.12 >>>> >>>> -- >>> >>> --- >>> 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. > -- --- 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.
