View Data in a Cross Reference Table
After a cross reference table is created, you can use the View Data page of the XrefUserApplication or the XrefAdminApplication (depending on your permissions) to view and search for data in the table. You can also Edit Data in a Cross Reference Table, Import Data to a Cross Reference Table, and Export Data from a Cross Reference Table.
To access the View Data page, perform the following steps:
- In Applications
- If you do not have administrative permissions, select the XrefUserApplication.
- If you have administrative permissions, select the XrefAdminApplication, and then click View Data.
- Next to View Data, 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.
Search for Data in a Table
To search the contents of a cross reference table, perform the following steps:
- On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
- Under Search Data, select the criteria by which to search. You can search one or multiple columns and criteria. Selecting multiple criteria will return results that match all specified criteria (logical AND search).
Criteria Description Column
Which column in the table to search.
Operator
The search operator. Options include EQUALS, NOT EQUALS, GREATER THAN, GREATER THAN OR EQUALS, LESS THAN, LESS THAN OR EQUALS, 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 a table:
Column Operator Value ID
IS NOT NULL
- 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.
- If more than 25 rows are returned, use the Previous and Next buttons to view more results, or change the Rows Per Page number.
- To clear the criteria used in a previous search, click Clear.