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.

PREREQUISITES: In 23.1 and newer, users must be assigned to security roles to view query results when the Case Object query type is used. See Security Roles in the Admin 3.6 Guide for more information.

1. Tap Work activity search and tap Advanced Search.

2. 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.

3. 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.

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

The work activities now dynamically filter in the third panel to show which activities meet the search criteria entered. Please note that if a query boundary was selected for the query, only results that match the query and are within the boundary area defined on the map appear. For example, if a boundary is associated to the query and the total amount of records is 25, but only 10 results appear, it is because there are only 10 of the 25 results that match the query parameters and are within the boundary area defined on the map and associated to the query. See Query Boundary Manager for more information about query boundaries.

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.

6. Tap Open next to any of the results to view the work activity that matches the query criteria in a new tab.
7. 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 (for example, open work orders for a Work Order query).
• Open Project(s): Tap to open the selected project from a project query.
• Open Contract(s): Tap to open the selected contract from a contract 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.
• Open Change Out: Tap to open the selected asset(s) in the Change Out page.
• Highlight on Map: Tap to highlight the selected assets on the map. This is only available when a GIS Feature query is created.