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 El miércoles, 30 de noviembre de 2016, 23:02:47 (UTC+1), Ivan Mainetti escribió: > > could you add examples of query you tried? > > > Il giorno mercoledì 30 novembre 2016 12:50:43 UTC+1, Academia Learning > Centro de inglés y de formación ha scritto: >> >> I need to retrieve all Compositions that have the temperature field but >> do not get their path since they are inside nested arrays >> >> >> <https://lh3.googleusercontent.com/-kncu-RQ8o2E/WD69D359uRI/AAAAAAAACss/4srQNy7ZjpsRML2OtzJuJRzJoIjEdBS0ACLcB/s1600/Sin%2Bt%25C3%25ADtu3lo.png> >> >> -- --- 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.