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.