[HELP] find document inside list

[Academia Learning Centro de inglés y de formación]

Hi, I want to look for a document within a list, but I can not find the way, I'm trying this but it gives me error

select from object where compositionsList traverse ( class = 'composition' ), 

but this not working

select from EHR where compositionsList['class'] like 'comp%'

{ "object" :{

"compositionList" : [

   {"class" : "composition"},

   {"class" : "example"}

]

}

[Oleksandr Gubchenko]

What is a type of compositionList? Is it an embedded list?

[Oleksandr Gubchenko]

Try this one:

select from EHR where 'composition' in compositionList.class

[Academia Learning Centro de inglés y de formación]

not working

[Academia Learning Centro de inglés y de formación]

yes are list embedded

[user.w...@gmail.com]

Hi,

try this:

select from EHR where compositionsList.class contains "composition"

Hope it helps

Regards,

Michela

[Academia Learning Centro de inglés y de formación]

Yes but, I need to find a field inside a json value, which inside has more nested fields and values, but I do not know the path. Arrays inside arrays