Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

select lf.name as task_name,
       lf.start_dtm as task_start_dtm,
       lf.end_dtm as task_end_dtm,
       lu.first_name || ' ' || lu.last_name as local_user_name,

            eu.first_name

...

||

...

'

...

'

...

||

...

eu.last_name

...

as

...

domain_user_name,

...

            lf.complete_boo

...

as

...

task_complete_boo,

...

            lm.message_type,

...

            lm.message

from
    log_file lf
    inner join log_message lm on
        lf.log_file_id = lm.log_file_id
    left outer join local_user lu on
        lf.user_id = lu.user_id
    left outer join external_user eu on
        lf.user_id = eu.user_id

To run this query you will need read access to the following tables in the PhixFlow schema:

...

The following message types (m.message_type) are found in PhixFlow log files:

...