Custom Form Records Audit SQLs

select
  r.record_id as "Record ID", 
  f.caption as "Form Name", 
  concat(u.first_name, concat(' ', u.last_name)) as "User", 
  r.update_time as "Update Time",
  r.activity_status as "Status"
from
  catissue_form_record_entry r
  inner join catissue_form_context fc on fc.identifier = r.form_ctxt_id
  inner join catissue_user u on u.identifier = r.updated_by
  inner join dyextn_containers f on f.identifier = fc.container_id
where
  f.deleted_on is null and
  fc.deleted_on is null and
  r.update_time between :startTs and :endTs
order by
  r.update_time desc

select
  r.record_id as "Record ID", 
  f.caption as "Form Name", 
  concat(u.first_name, concat(' ', u.last_name)) as "User", 
  r.update_time as "Update Time",
  r.activity_status as "Status"
from
  catissue_form_record_entry r
  inner join catissue_form_context fc on fc.identifier = r.form_ctxt_id
  inner join catissue_user u on u.identifier = r.updated_by
  inner join dyextn_containers f on f.identifier = fc.container_id
where
  f.deleted_on is null and
  fc.deleted_on is null and
  u.login_name = :loginName and
  r.update_time between :startTs and :endTs
order by
  r.update_time desc

select
  r.record_id as "Record ID", 
  f.caption as "Form Name", 
  concat(u.first_name, concat(' ', u.last_name)) as "User", 
  r.update_time as "Update Time",
  r.activity_status as "Status"
from
  catissue_form_record_entry r
  inner join catissue_form_context fc on fc.identifier = r.form_ctxt_id
  inner join catissue_user u on u.identifier = r.updated_by
  inner join dyextn_containers f on f.identifier = fc.container_id
where
  f.deleted_on is null and
  fc.deleted_on is null and
  fc.entity_type = 'Participant' and
  u.login_name = :loginName and
  r.update_time between :startTs and :endTs
order by
  r.update_time desc