ApplicationsView Cross Reference Table Audit Records

You can use the View Audit Records page of the XrefAdminApplication to view and search for cross reference table audit records, as well as export data in the audit record table. For more information on audit tables, see How Cross Reference Table Applications Work.

Note: If a cross reference table on one Loftware Application Server is transferred to another Loftware Application Server, the audit table will display the timestamp and user of the transfer request.

To view audit records for a cross reference table, perform the following steps:

  1. In Applications , open the Cross Reference Table App folder and select the XrefAdminApplication.
  2. Under Audit Information, click View Audit Records.
  3. Select a table from the drop-down list. The names of the columns in the table are displayed. To view the contents of the table, see Search for Data in a Table Audit Record.

Search for Data in a Table Audit Record

To search the contents of a cross reference table audit record, perform the following steps:

  1. On the View Audit Records page, select a table from the drop-down list. The names of the columns in the audit table are displayed.
  2. Under Search Data, select the criteria by which to search. You can search one or multiple columns and criteria.
    CriteriaDescription

    Column

    Which column in the table to search.

    Operator

    The search operator. Options include EQUALS, NOT EQUALS, GREATER THAN, GREATER THAN OR EQUAL, LESS THAN, LESS THAN OR EQUAL, LIKE, NOT LIKE, IS NULL, and IS NOT NULL.

    Value

    The data to search for. This field is case sensitive.

    Example

    You could use the following criteria to view all the data in the audit table:

    ColumnOperatorValue

    ID

    IS NOT NULL

    		 
  3. Click Search. A message is displayed in the log pane with the number of rows returned by the search criteria, and the data meeting the criteria is displayed in the table.
  4. If more than 25 rows are returned, use the Previous and Next buttons to view more results, or change the Rows Per Page number.
  5. To clear the criteria used in a previous search, click Clear.

Export Data from a Audit Record Table

To export data from a cross reference table audit record to a comma-delimited text file (CSV) file, perform the following steps:

  1. On the View Audit Records page, select a table from the drop-down list. The names of the columns in the audit table are displayed.
  2. Perform a search on the table for the data you want to export. For more information, see Search for Data in a Table Audit Record.
  3. Click Export CSV. The Export dialog box is displayed when the file is ready.
  4. In the Export dialog box, click OK.
  5. In your browser's Save As dialog box, do the following:
    1. Select a location to save your file.
    2. Enter a file name.
    3. Select or enter .csv for the file type.
    4. Click Save.

You can now open and view this file in a spreadsheet application such as Microsoft Excel.