Standard または Advancedのライセンスで利用可能。Workflow Manager のライセンスで利用可能。
Several job query containers and queries are present by default in the ArcGIS Workflow Manager for 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 application opens.
Adding query folders
Use the tools available to add query containers that will be used to organize your queries in the client application.
- In the Administrator, browse to the Job Queries folder.
- 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.
- Right-click and choose Add Query Container.
- Provide a name for the folder.
This name will be presented to the Workflow Manager System users in the client application.
- 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.
- In the Administrator, browse to the Job Queries folder.
- 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.
- Right-click and choose Add Query.
The Define Job Query dialog box appears.
- Provide a name for the query on the General tab.
- 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 automatically manages the inter-table 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.
- Add fields to the list by double-clicking them or dragging them to the column on the right.
- 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.
- Change the aliases and order as necessary.
- Click the Filtering tab.
Define which jobs should be returned by this query based on the filter criteria.
- 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.
- Create the filtering statement in the lower section by linking each condition together with ANDs, ORs, and parentheses.
- 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.
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.
- In the Administrator, browse to the Job Queries folder.
- 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.
- Right-click and choose Add Query.
The Define Job Query dialog box appears.
- Provide a name for the query on the General tab.
- Click the SQL Query tab.
- Click a table from the Tables list to populate the Fields list with all the fields in the selected table.
- Choose a field and click Get All to populate the Unique Values list with all values in the selected field.
- Select the command component (Select, Name As, and so on) with your cursor, and double-click the table or field you want to add.
- Specify the Where clause to define which jobs should be returned by this query.
- Click Verify to confirm that the query is valid and click OK to add the query to your job query tree.
Sharing queries
It's possible to use an existing query as the base for another using the Export option on the Define Job Query dialog box.
- Right-click the query and choose Edit Item on the query you want to export.
- Click Export.
- Provide a location and file name for the exported query.
- 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 systems.