Hi,

We're evaluating whether to use OrientDB at our company. So far it looks 
really great.

We will need to store documents with nested documents within them. 
The schema won't be known until runtime but we need to fetch the full 
nested documents as json

Using the document api in 1.7.8 I can create a document with a sub document 
like so
ODocument doc = new ODocument("mydoc");
ODocument subdoc = new ODocument("subdoc");
subdoc.field("name", "Tom");
doc.field("subdoc", subdoc);
doc.save();

If I then fetch it using the following query
select * from mydoc where subdoc.name = 'Tom'

and call toJSON on it I get 
{"@type":"d","@rid":"#9:55","@version":1,"@class":"mydoc","subdoc":"#14:0"}


I would like to retrieve the full nested document including all the fields 
from subdoc
{"@type":"d","@rid":"#9:55","@version":1,"@class":"mydoc", "subdoc":{"name":
"Tom"}}

How would I do this?

Cheers!


-- 

--- 
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.

Reply via email to