Differences

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

--- sql_commands_-_search_logs_-_sundhedsjournal [2026/03/18 14:37]
57.141.20.59 old revision restored (2026/03/17 06:15)
+++ sql_commands_-_search_logs_-_sundhedsjournal [2026/03/19 14:09] (current)
47.79.51.8 old revision restored (2025/12/30 09:50)
@@ 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