Public job queries

This topic applies to ArcEditor and ArcInfo only.

Several job query containers and queries are present by default in Workflow Manager. 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 Configuration Manager and are available to all users of the system.

Note:

Jobs returned by these queries are affected by job filters applied to the groups the user belongs to.

Configuring queries

Adding query folders

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

Steps:

1. In the Administrator, navigate to the Job Queries folder.
2. Select the query folder that you would like to create a new folder in.

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

3. Click Add and choose Query Folder.
4. Enter a name for the folder.

   This name will be presented to the Workflow Manager System Users in the client application.

5. Click OK to create the new folder.

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

Adding queries

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

Steps:

1. In the Administrator, navigate to the Job Queries folder.
2. Select the query folder that you would like to create a new query in.

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

3. Click Add and choose Job Query.

   The Define Job Query dialog box appears.

4. Enter a name for the query on the General tab.
5. Select the Fields tab.

   This is where you will choose the job information that will be presented to the user in the List View when the query is executed. Workflow Manager automatically manages the intertable relationships within 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 selecting and 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. Select the Aliases tab.

   On this tab, you can change the name used to represent each field. Also, you can 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.

   Here is where you define which jobs should be returned by this query.

10. Define the conditions by selecting the field you want to query with, 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 window by linking each condition together with ANDs, ORs, and parentheses.

    Build the where clause for your query in the filtering tab.

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

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

SQL View

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.

Steps:

1. In the Administrator, navigate to the Job Queries folder.
2. Select the query folder that you would like to create a new query in.
3. The Public Queries folder that you see in the view is the highest level folder.
4. Click Add and choose Job Query.

   The Define Job Query dialog box appears.

5. Enter a name for the query on the General tab.
6. Click the SQL View tab.
7. Select a table from the tables list to populate the fields list with all the fields in the selected table.
8. Select a field and click Get All to populate the unique values list with all values in the selected field.
9. Select the command component (Select, Name As, and so on) with your cursor, then double-click the table or field you would like to add.
10. Specify the Where clause to define which jobs should be returned by this query.
11. Click Verify to confirm that the query is valid and click OK to add the query to your job query tree.

Sharing queries

It is possible to use one query as the seed for another using the Import and Export tools on the Define Job Query dialog box.

Steps:

1. Edit a query you would like to export.
2. Click Export.
3. Enter a location and fine name for the exported query.
4. Click Save.

A .jtq file is created. This query file can then be imported to act as a seed for a new query or shared between users and Workflow Manager Systems.