Differences

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

--- sql_commands_-_search_logs_-_sundhedsjournal [2025/12/14 06:56]
57.141.0.43 old revision restored (2025/11/24 23:52)
+++ sql_commands_-_search_logs_-_sundhedsjournal [2025/12/14 20:09] (current)
57.141.0.14 old revision restored (2025/11/02 03:39)
@@ 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,
+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",
-       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))
+       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))
        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