I think I might have gotten closer utilizing fetch plans. I'll let you know what I come up with.
On Tue, Aug 18, 2015 at 11:06 AM, Chris Whalen <[email protected]> wrote: > Yeah, that is as close as I could get as well. I think there should be a > way to do a ".include("*") and get back the entire record. It would save > me a couple more trips back to the database to fetch the records. Thanks > for your attempt. > > > On Tuesday, August 18, 2015 at 5:28:30 AM UTC-4, [email protected] > wrote: >> >> Hi Chris, >> >> I can't do exactly what you want, the only thing that I can do is this: >> >> select *, GetAncestors(@rid).include("name") as Ancestors from Person >> order by Name >> >> { >> "result": [ >> { >> "@type": "d", >> "@rid": "#12:0", >> "@version": 4, >> "@class": "Person", >> "name": "Anna", >> "in_IsChildOf": [ >> "#13:1" >> ], >> "Ancestors": [ >> >> ], >> "@fieldTypes": "in_IsChildOf=g" >> }, >> { >> "@type": "d", >> "@rid": "#12:1", >> "@version": 3, >> "@class": "Person", >> "name": "Mario", >> "out_IsChildOf": [ >> "#13:1" >> ], >> "in_IsChildOf": [ >> "#13:4" >> ], >> "Ancestors": [ >> { >> "@type": "d", >> "@version": 0, >> "name": "Anna" >> } >> ], >> "@fieldTypes": "out_IsChildOf=g,in_IsChildOf=g,Ancestors=z" >> }, >> { >> "@type": "d", >> "@rid": "#12:2", >> "@version": 3, >> "@class": "Person", >> "name": "Luca", >> "in_IsChildOf": [ >> "#13:0" >> ], >> "out_IsChildOf": [ >> "#13:4" >> ], >> "Ancestors": [ >> { >> "@type": "d", >> "@version": 0, >> "name": "Mario" >> }, >> { >> "@type": "d", >> "@version": 0, >> "name": "Anna" >> } >> ], >> "@fieldTypes": "in_IsChildOf=g,out_IsChildOf=g,Ancestors=z" >> }, >> { >> "@type": "d", >> "@rid": "#12:3", >> "@version": 4, >> "@class": "Person", >> "name": "Andrea", >> "out_IsChildOf": [ >> "#13:0" >> ], >> "Ancestors": [ >> { >> "@type": "d", >> "@version": 0, >> "name": "Luca" >> }, >> { >> "@type": "d", >> "@version": 0, >> "name": "Mario" >> }, >> { >> "@type": "d", >> "@version": 0, >> "name": "Anna" >> } >> ], >> "@fieldTypes": "out_IsChildOf=g,Ancestors=z" >> } >> ], >> "notification": "Query executed in 0.06 sec. Returned 4 record(s)" >> } >> >> Regards, >> Michela >> >> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/4ltzMIfg7rk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Chris Whalen [email protected] -- --- 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.
