Hi Arne, I'm no expert, but as per my experience, the results from OrientDB will contain metadata such as @type, @class etc.
How I solved the problem was to pass through the OrientDB results via a JavaScript function, create a JavaScript object as per the schema I want and return the stringified version of the JavaScript object that I've created. Note: You can use the JSON.stringify() function to convert a JavaScript object to JSON. However, I experienced the function not working on Java 1.8 - update 40. Hope this helps. Cheers Omega On Thursday, May 14, 2015 at 10:21:06 PM UTC+5:30, Arne Pfeilsticker wrote: > > I have a tree structure which looks like: > > id,parent_id,label > pt,,Rechtssubjekt > pt.1,pt,natürliche Person > pt.2,pt,juristische Person > pt.21,pt.2,juristische Person des Privatrechts > pt.22,pt.2,juristische Person des öffentlichen Rechts > ... > > I get in the Studio-Browser with: select from PersonTypes where @rid = #12:0 > fetchplan out_*:-1 > > > { > "result": [ > { > "@type": "d", > "@rid": "#12:0", > "@version": 3, > "@class": "PersonTypes", > "id": "pt", > "parent_id": null, > "label": "Rechtssubjekt", > "out_hasPersonSubtype": [ > { > "@type": "d", > "@rid": "#11:0", > "@version": 3, > "@class": "hasPersonSubtype", > "out": "#12:0", > "in": { > "@type": "d", > "@rid": "#12:1", > "@version": 2, > "@class": "PersonTypes", > "id": "pt.1", > "parent_id": "pt", > "label": "natürliche Person", > "in_hasPersonSubtype": [ > "#11:0" > ], > "@fieldTypes": "in_hasPersonSubtype=g" > }, > "@fieldTypes": "out=x" > }, > { > "@type": "d", > "@rid": "#11:1", > "@version": 3, > "@class": "hasPersonSubtype", > "out": "#12:0", > "in": { > "@type": "d", > "@rid": "#12:2", > "@version": 4, > "@class": "PersonTypes", > "id": "pt.2", > "parent_id": "pt", > "label": "juristische Person", > "in_hasPersonSubtype": [ > "#11:1" > ], > "out_hasPersonSubtype": [ > { > "@type": "d", > "@rid": "#11:2", > "@version": 3, > "@class": "hasPersonSubtype", > "out": "#12:2", > "in": { > "@type": "d", > "@rid": "#12:3", > "@version": 2, > "@class": "PersonTypes", > "id": "pt.21", > "parent_id": "pt.2", > "label": "juristische Person des > Privatrechts", > "in_hasPersonSubtype": [ > "#11:2" > ], > "@fieldTypes": "in_hasPersonSubtype=g" > }, > "@fieldTypes": "out=x" > }, > ... > > What i would like to have ist something like this: > > { > "result": [ > { > "id": "pt", > "parent_id": null, > "label": "Rechtssubjekt", > "children": [ > { > "id": "pt.1", > "parent_id": "pt", > "label": "natürliche Person", > "children": [ > ], > }, > }, > { > "id": "pt.2", > "parent_id": "pt", > "label": "juristische Person", > "children": [ > { > "id": "pt.21", > "parent_id": "pt.2", > "label": "juristische Person des > Privatrechts", > "children": [ ], > }, > }, > ... > > Is there any chance to get something like this with a SQL command or > server side function? > > For any advice or examples I am grateful. > > Can it be that fetchpans do not work in server-side functions? > -- --- 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.