So if it works to me (add [0]) but how could I know in which position is the array is the temperature field, or how else could I get it?
select value.content.data.events.data.items.value.magnitude*[0]* from CompositionVersions where 'Temperature' in value.content.data.events.data.items.name.value El lunes, 5 de diciembre de 2016, 11:08:03 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > 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.