[orientdb] How to query embedded json (with property defined)

[sourav . da]

I have a json document called “sample” like this -
{
“config”:{
“is”:
{
“cd”:[“123456”]
,“dv”:[“dtp”,“tbl”]
,“pid”:[“WXYZ”]
}
}
,“ttl”:“2S”
}

I want to know how to find all documents where pid is “abc” when the nested 
json "config" & "is" are defined as embedded document.


When its not an embedded document I can query it as below -

SELECT FROM sample WHERE config[“is”].pid CONTAINS(‘abc’)


But the same doesn’t work when "config" & "is" are defined as embedded 
document.

-- 

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