It is possible to find a field in an array without knowing the path

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

I need to retrieve all Compositions that have the temperature field but do not get their path since they are inside nested arrays

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

I have tried with any() but not working

[Ivan Mainetti]

could you add examples of query you tried?

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

Yes, 

select from CompositionsVersions where any() like '%temperature%'

But as the field is inside a value json does not find it, I have tried with fields / properties that are not in a json value and if it works