• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Daily data report

    Technical Questions
    #1

    Hello,

    Is it possible to get the report that shows all the patients that were added/ modified on a given day?

    Thanks,
    Sandhya

    #2

    Not from use interface.

    If you want to try from DB then you can join with the audit tables. You will need to understand the schema for it a bit.

    ~Sri

    #3

    That seemed like an interesting report to have, so I gave it a shot. I think this might do the trick:

    select ae.EVENT_TIMESTAMP, u.LOGIN_NAME as USER, ae.EVENT_TYPE
	, p.LAST_NAME, p.FIRST_NAME, p.BIRTH_DATE, p.GENDER
    , (select MEDICAL_RECORD_NUMBER from catissue_part_medical_id where PARTICIPANT_ID = p.IDENTIFIER limit 1,1) as MRN
from catissue_audit_event ae
join catissue_audit_event_log ael
on ael.AUDIT_EVENT_ID = ae.IDENTIFIER
join catissue_audit_event_details aed
on aed.AUDIT_EVENT_LOG_ID = ael.IDENTIFIER
join catissue_user u
on ae.USER_ID = u.IDENTIFIER
join catissue_data_audit_event_log dael
on dael.IDENTIFIER = ael.IDENTIFIER
join catissue_participant p
on dael.OBJECT_IDENTIFIER = p.IDENTIFIER
where ae.EVENT_TIMESTAMP > date_add(current_timestamp(), interval -1 day)
and dael.OBJECT_NAME = 'CATISSUE_PARTICIPANT'
and ae.EVENT_TYPE = 'INSERT'
and aed.ELEMENT_NAME = 'IDENTIFIER'
;
    #4

    I just re-read the original post and I should note that my query only shows patients added, not updated.