[orientdb] How can I complete this query? arrays inside arrays

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

Hello guys I have an element with a json value and inside it has several 
arrays inside arrays.

I want to retrieve the values of the field Temperature *only *of the arrays 
that are of the temperature type. 

But this query returns all the values with only one of the arrays is of 
type Temperature.

select value.content.data.events.data.items.value.magnitude 
from CompositionVersions 
where 'Temperature' in value.content.data.events.data.items.name.value


Thanks

-- 

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