> > I've got it using > select from CompositionVersions " + "where (select distinct (id) from (select id, date, events.data.items as items " + "from (select id, value.data.origin.value as date, value.data.events as events " + "from (select value.uid.value as id, value.content as value " + "from CompositionVersions unwind value) " + "where value.archetype_node_id = 'openEHR-EHR-OBSERVATION.body_temperature.v1' " + "and value.data.origin.value >= '2013-01-17' and value.data.archetype_node_id ='at0002' unwind events) " + "where events.archetype_node_id ='at0003' and events.data.archetype_node_id = 'at0001' unwind items) " + "where items.archetype_node_id = 'at0004' and items.value.magnitude <= 40 and items.value.magnitude >= 35 " + "and items.value.units !='°F' order by date ASC) " + "in value.uid.value
-- --- 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.