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
