Differences

This shows you the differences between two versions of the page.

--- sql_commands_-_search_logs_-_sundhedsjournal [2021/10/13 12:13]
192.168.1.254 Added updated_at timestamp and fixed wrong alias for "Handleplan" reference
+++ sql_commands_-_search_logs_-_sundhedsjournal [2025/10/21 14:04] (current)
20.171.207.78 old revision restored (2021/10/13 12:01)
@@ Line 6: / Line 6: @@
 ===Show information about the ID's found===
 <code sql>
-select et.name,fd.id,fd.alias,fd.name,f.entity_id,f.updated_at at time zone 'utc' at time zone 'Europe/Copenhagen' "updated_at_localtime",
+select et.name,fd.id,fd.alias,fd.name,f.entity_id,
-       case when fd.alias='sygeplejeproblem' 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))
+       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)

DokuWiki