I am pretty sure that fetch plans are what I'm looking for. I've shifted my question to focus on fetch plans and how to get them to resolve peroperly. That question can be found here <https://groups.google.com/forum/#!topic/orient-database/accV6VBvm7M>. I think this question thread can be marked as closed.
On Wednesday, August 19, 2015 at 4:20:41 PM UTC-4, Chris Whalen wrote: > > 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.
