ApplicationsView 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:

  1. In Applications , open the Cross Reference Table App folder and do one of the following:
    • If you do not have administrative permissions, select the XrefUserApplication.
    • If you have administrative permissions, select the XrefAdminApplication, and then click View Data.
  2. 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:

  1. On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
  2. 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).
    CriteriaDescription

    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:

    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.