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 [email protected]. For more options, visit https://groups.google.com/d/optout.
