===== Find ID's of "Handleplan" or "Handlinger" marked as ended on a specific customer and time interval =====
<code sql>
select array_agg(params->'opts'->'0'->>'s_e_id' order by start) from [LOG_TABLE] where customer_id=[CUSTOMER_ID] and start > '[START_TIME]' and start < '[END_TIME]' and params::text like '%afsluttet%' and action = 'save_field';
</code>

===Show information about the ID's found===
<code sql>
select et.name,fd.id,fd.alias,fd.name,f.entity_id,
       case when fd.alias='handleplan' then get_name((select reference_id from fields f2 join field_descriptors fd2 on (fd2.id=f2.field_descriptor_id) where fd2.alias='person' and f2.entity_id=f.reference_id limit 1))
       else coalesce(get_name(f.reference_id),f.value_text) end
from fields f join field_descriptors fd on (fd.id=f.field_descriptor_id)
join entities e on (e.id=f.entity_id)
join entity_types et on (et.id=e.entity_type_id)
where f.entity_id in ([IDS_FROM_PREVIOUS_QUERY])
order by f.entity_id, fd.position;
</code>