Fullscreen Image

Query

Perform a search query using multiple criteria to find specific records. Save the query for future use. When a query returns multiple records, they appear in a list. If only one record matches, Accruent TMS opens that record's update page directly.

Run query

Perform a one-time search based on the criteria you choose. Select fields across multiple tabs to refine the results.

  1. Navigate to Work orders > Query.
  2. On the Query page, select the search criteria. Fields that support advanced filtering display the Advanced Query (AQ) icon. Click this icon to build advanced criteria.
  3. Include inactive resources in the search by selecting Include inactive in the resource field. Inactive resources appear in italics with an Inactive label (for example Jane Doe (Inactive)).
  4. Move through the tabs to choose additional fields. To clear all selections and start over, click Clear all.
  5. Click Run query.

When you select a date, Accruent TMS filters for the full day (12:00 AM to 11:59:59 PM) in the configured time zone. Include the time to filter by an exact timestamp.

Save query

Save search criteria to retrieve the same data set each time without re-entering information.

  1. Follow the steps to run a query.
  2. After entering search details, click Save query.
  3. In the Save query window, enter a name in Saved query name and click Save.

Saved queries with explicit time values continue to use precise timestamps as filters for consistent results.

Run saved queries

Access queries created in either Accruent TMS or Classic TMS to save time and prevent errors when reconstructing complex searches.

  1. In the Actions menu at the upper right, select Saved queries.
  2. Select one of the following filters
    • All Shows all recent and saved queries.
    • Recents Shows queries used within a specific number of days.
    • Saved Displays all saved queries.
    • Favorites Shows queries marked as favorites.
  3. In the Actions menu to the left of the desired query, select Run query.

Favorites

Add frequently used queries to the Favorites list for quicker access.

  1. In the Saved queries list, select Add as favorites from the Actions menu next to the query.
  2. To remove a query, select Remove as favorite from the Actions menu.