Skip to main content

Seeking audited information for edits and deletions of steps, persons, forms

In this article, we explain how workflow, person, and form changes are audited in their respective AUD_ tables even after deletion.

Y
Written by Yusef Abulaynain
Updated over 4 months ago

Workflow steps are stored in the MO_WORKFLOW_STEPS table, and whenever changes are made or it's deleted then such audits are stored in the AUD_MO_WORKFLOW_STEPS table, even after it's deleted.
​
The same applies to person records (the MO_PERSONS table). Audits are stored in the AUD_MO_PERSONS table.
​
Likewise, the same applies to forms - in the MO_FORMS table. Audited changes to certain forms are stored in the AUD_MO_FORMS table - whether the form is stand-alone or part of a step, you just need the relevant FORM_ID.

Here are some helpful statements to run, assuming you have adequate Database permissions to run. If not, please raise a support case to have the details sent to you.
​

Legend:
Audit_action column:
i = Insert (as soon as its created).
u = Updated (whenever a change is made).
d = Deleted.

--Current step details:
select * from MO_WORKFLOW_STEPS where WORKFLOW_STEP_ID = 'xxx'
--Audited data of that step
select * from AUD_MO_WORKFLOW_STEPS where WORKFLOW_STEP_ID = 'xxx' order by audit_date asc
--Current person record:
select * from MO_PERSONS where PERSON_ID = 'xxx'
--Audited data of that person:
select * from AUD_MO_PERSONS where PERSON_ID = 'xxx' order by audit_date asc
--Current form details:
select * from MO_FORMS where FORM_ID = 'xxx'
--Audited data of that form:
select * from AUD_MO_FORMS where FORM_ID = 'xxx' order by audit_date asc

Did this answer your question?