Using flag fields to view changes to an individual field

For every audit field in a form, AR System creates a flag field on the audit form. This field contains the database name and remains on the audit form until the main field is deleted. If a field in the main form is not audited or is a copy field, the flag field is not created.

Flag fields are not in any view, and they are created with the field ID in the name, for example, F_ fieldID_C, where _fieldID is the field ID of the audited field. If a join form is audited, fieldID is the field ID of the audit field in the join form.

Related topics

Auditing-data-and-approvals

Defining-data-associations-among-forms

AR System application components

In the base form of a join, if a field is set to audit after the audit join form is created, the flag field is created in the base form's audit form and in the audit join form.

When auditing is triggered, and if the audit field changes value, the corresponding flag field contains a "1" to indicate that the field changed; otherwise, it remains empty.

By using a flag field, you can refine your search and view changes to an individual field.

To view changes to an individual field

  1. Enable form-style auditing on a form.
  2. Select the fields for which you want auditing, and set the audit attribute to Audit or Audit and Copy for those fields.

  3. Perform a search on the audit form with the following qualification included:

    F_fieldID_C

    where fieldID is the ID of the field for which you want to view the audit. This field must be one of the fields that have the Audit or Audit and Copy attribute enabled.

    For example, Form A has fields A, B and C, and audit is turned on for A and B. To view the changes to A, search Form A with the following qualification:

    'F_536870913_C' = "1"

    where 536870913 is the field ID of field A. This query displays all of the records where field A has changed.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*