Differences

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

--- sql_commands_-_search_logs_-_sundhedsjournal [2026/02/01 12:39]
14.116.238.82 old revision restored (2026/01/24 04:47)
+++ sql_commands_-_search_logs_-_sundhedsjournal [2026/02/03 01:04] (current)
57.141.20.17 old revision restored (2025/12/24 11:35)
@@ 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