Search by attribute or keyword

Landlords and tenants can perform a keyword search to locate any relevant SQL transaction that contains the keyword.

You can use the following attributes/keywords in the search text field.

Attribute name

Description

SQL

Information about the stored procedure/SQL specifics

SQL parameters

Detailed information about the SQL transaction
  1. On the Change Audit page, in the Type to search in sql field, enter the attribute/keyword.
  2. Optionally select one or more filters. See Filter by user or change type.
  3. The results table displays changes that match the search criteria.

  1. To sort the results in a column, point to the column heading and click the arrow or Menu that appears.

  1. To filter the results in a column, click the Menu and then click Filter. In the Filter, select the column and operator, and enter the value.

  1. To hide a column, click its Menu and then click Hide column.
  2. To select the visible columns, click any column's Menu and then click Manage columns.

  1. To view further details for an individual change, see View the SQL script or parameters.