Configuring public job queries

Available with Standard or Advanced license.

Available with Workflow Manager license.

Several job query containers and queries are present by default in the ArcGIS Workflow Manager (Classic) Desktop. These include General Queries (All Jobs query and Unassigned Jobs query), Group Queries (Jobs assigned to my groups and Jobs with steps assigned to my groups), and Personal Queries (Jobs assigned to me and Jobs with steps assigned to me). Job queries in these folders are managed in the Workflow Manager Administrator and are available to all users of the system. Users can set any of these as a default query, and that query will execute by default every time the Workflow Manager (Classic) application opens.

Note:

Jobs returned by these queries are affected by job filters applied to groups the user belongs to. Default query currently only works for Windows users and does not support portal users.

Adding query folders

Use the tools available to add query containers that are used to organize your queries in the client application.

1. In the Administrator, browse to the Job Queries folder.
2. Choose the query folder where you want the new folder to reside.

   The Public Queries folder that you see in the view is the highest level folder.

3. Right-click and click Add Query Container.
4. Provide a name for the folder.

   This name will be presented to the Workflow Manager (Classic) system users in the client application.

5. Click OK to create the folder.

   This folder is now available to contain other folders or queries.

Adding queries

Use the tools available to configure queries that are used to filter your jobs in the application.

1. In the Administrator, browse to the Job Queries folder.
2. Choose the query folder where you want the new query to reside.

   The Public Queries folder that you see in the view is the highest level folder.

3. Right-click and click Add Query.

   The Define Job Query dialog box appears.

4. Provide a name for the query on the General tab.
5. Click the Fields tab.

   This is where you'll choose the job information to be presented to the user in the List View when the query is executed. Workflow Manager (Classic) automatically manages the inter-table relationships in the system. By expanding nodes off of the fields in the job table, you can choose to show more descriptive information in the query result.

6. Add fields to the list by double-clicking them or dragging them to the column on the right.

   

   Add fields to the list. These represent the information that will be presented to the user when the query is executed.

7. Click the Aliases tab.

   On this tab, you can change the name used to represent each field. You can also reorder the fields. The top field will be the first field on the left, and the bottom field will be the last field on the right.

8. Change the aliases and order as necessary.

   

   Change the presentation name and order of fields in the query on the Aliases tab.

9. Click the Filtering tab.

   Define which jobs should be returned by this query based on the filter criteria.

10. Define the conditions by selecting the field you want to use to query, the operator, and the value the job must meet.

    You can add as many conditions as you want.

11. Create the filtering statement in the lower section by linking each condition together with ANDs, ORs, and parentheses.

    

    Build the where clause for your query on the Filtering tab.

12. Click OK to save your changes and close the dialog box.

    The query appears in the client application the next time you open it.

Note:

Click Preview SQL to see the SQL statement generated for your queries.

Viewing in SQL

The SQL view is for advanced users who want to construct queries with the traditional SQL statements. These tools allow you to define more complex queries for filtering jobs in the application.

1. In the Administrator, browse to the Job Queries folder.
2. Choose the query folder where you want the new query to reside.

   The Public Queries folder that you see in the view is the highest level folder.

3. Right-click and click Add Query.

   The Define Job Query dialog box appears.

4. Provide a name for the query on the General tab.
5. Click the SQL Query tab.

   

6. Click a table in the Tables list to populate the Fields list with all the fields in the selected table.
7. Choose a field and click Get All to populate the Unique Values list with all values in the selected field.
8. Select the command component (Select, Name As, and so on) with your cursor, and double-click the table or field you want to add.
9. Specify the Where clause to define which jobs should be returned by this query.
10. Click Verify to confirm that the query is valid and click OK to add the query to your job query tree.

Sharing queries

You can use an existing query as the base for another using the Export option on the Define Job Query dialog box.

1. In the Administrator, browse to the Job Queries folder.
2. Right-click the query you want to export and click Edit Item.
3. Click Export.
4. Provide a location and file name for the exported query.
5. Click Save.

A .jtq file is created. This query file can be imported to use as a base for a new query or shared between users and Workflow Manager (Classic) systems.