Create and manage user queries

Available with Workflow Manager license.

You can create user queries to search for jobs in the ArcGIS Workflow Manager (Classic) repository and display them in the workflow view. You must have the ManageQuery privilege to create and manage user queries. Complete the steps in the following sections to create and manage user queries.

Create user queries

Complete these steps to create user queries:

  1. Right-click User Queries in the Contents pane and click Create New User Query.

    The Create New User Query dialog box appears.

  2. Provide a name for the query in the Name text box.
  3. Click the Fields tab.
  4. In the List of Tables section, choose the table that contains the fields you want to add to the query.

    The Columns section is populated with the fields contained in the chosen table.

  5. In the Columns section, choose the field you want to add to the query and click Add.

    The field appears in the table at the bottom of the Fields tab.

    Tip:

    You can delete a field by clicking the Remove button Remove next to the field name.

  6. Optionally, double-click the field’s alias in the table to change the display name for the field in the Job List.
  7. Repeat steps 4 through 6 to add additional fields to your query.
  8. Optionally, click the Filters tab and add filters.
    1. Click Add.

      An SQL where clause appears.

      Tip:

      You can delete a WHERE clause by clicking the Remove button Remove.

    2. Choose the field you want to use as a filter, choose an operator, and choose a value or type a value for the WHERE clause.
    3. Optionally, repeat substeps a and b to add additional fields to your filter.
  9. Optionally, click SQL Query to customize the query using the query builder.
    Note:

    Queries that are saved using the SQL Query view can no longer be viewed or edited in the query designer.

  10. Optionally, click Validate to validate the query.
  11. Click OK to save the query.

    The query is selected as the active query and appears in the Contents pane under User Queries.

Edit user queries

Complete these steps to edit user queries:

  1. If necessary, expand User Queries in the Contents pane.
  2. Right-click the query you want to update and click Edit User Query.

    The Update User Query dialog box appears.

  3. Update the query as necessary.
  4. Click OK to save the query.

    The query is selected as the active query.

Delete user queries

Complete these steps to delete user queries:

  1. In the Contents pane, expand User Queries if necessary.
  2. Right-click the query you want to delete and click Delete User Query.

    The Confirm Deletion dialog box appears.

    Caution:

    Deleting a user query is permanent and can’t be undone.

  3. Click OK to delete the query.

    The query is deleted.