Preview Query Results

The third panel, on the Query Editor page, is a preview of which work activities meet the search parameters of your query and is populated when search parameters are defined. Once work activities populate, actions can be completed based on the type of query that was created.

  1. Tap Work activity search and tap Advanced Search.

  1. Tap New Query and add the desired search criteria. See Add a Query for more information.

Before a preview of work activities that match the search criteria appear in the third panel, at least one response field must be selected for the query type.

  1. Tap Response Fields.

The Response Fields panel is populated with fields from the query type's table. For example, if the query type is work order, then fields from a work order appear in the list.

  1. Select the check box to the left of any fields you want to display in your search query results.
  2. Tap Close.

The work activities now dynamically filter in the third panel to show which activities meet the search criteria entered.

NOTE:The Automatically Execute option is enabled by default, but can be disabled in order to edit a query without waiting for the results to populate every time the query is updated. This can be helpful when a query returns a lot of results or the page slows down. The action for the Automatically Execute option is remembered by the user's login.

  1. Tap Open next to any of the results to view the work activity that matches the query criteria in a new tab.
  2. Select a result or multiple results from the list to complete different actions depending on the type of query (e.g., Cityworks, GIS Feature, or GIS Object).

The following actions are available based on the type of query that was created.

Cityworks Query

  • Open: Tap to open the selected work activities (e.g., open work orders for a Work Order query).
  • Show on Map: Tap to show the selected work activities on the map.
  • Add map pins on the map. The X, Y fields must be added to the Response Fields table.

GIS Feature or GIS Object Queries

  • Create: Tap to create work order(s), inspection(s), or PLL cases(s) for the selected assets.
  • Open in Asset Details: Tap to open the selected asset(s) in the Asset Details page.
  • Highlight on Map: Tap to highlight the selected assets on the map. This is only available when a GIS Feature query is created.