select @rid, @this.toJSON('fetchPlan:roles:1') from OUser where name='admin'
Does that work for you? On Monday, November 3, 2014 12:40:18 PM UTC-5, Dário Marcelino wrote: > > Hi, > > I've noticed that when I do a query using a fetch plan, the linked records > do not contain their ID. For example, taking the demo database of 1.7.1: > select @this.toJSON('fetchPlan:roles:1') from OUser where name='admin' > > Returns: > { > "result": [ > { > "@type": "d", > "@rid": "#-2:1", > "@version": 0, > "this": > "{\"name\":\"admin\",\"password\":\"{SHA-256}8C6976E5B5410415BDE908BD4DEE15DFB167A9C873FC4BB8A81F6F2AB448A918\",\"status\":\"ACTIVE\",\"roles\":[{\"name\":\"admin\",\"inheritedRole\":null,\"mode\":1,\"rules\":{\"database.bypassrestricted\":15}}]}" > } > ], > "notification": "Query executed in 0.057 sec. Returned 1 record(s)" > } > > which does not include the ID of the admin role (#4:0). > > Is there anyway to populate the IDs of linked records? > > Thanks! > -- --- 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.