Query Requests action

Create custom filters with sorting capabilities for requests.

Settings

  • Select a filter.
    Note: The filters for process and request titles, tags, IDs, team name, and PII tags have the same list of options.
  • Specify the string value in the List or Variable field.
    • Specify your type in the List or Variable field.
    • List: Input your value information in the Type and Value at 0 fields.
    • Optional: In the Add field, add more values.
    • Variable: Enter your custom variable.
  • In the Request Status field, select a status.

    You can choose OPENED, SUCCESS, ERROR, and CANCELLED

  • In the Page field, specify a value.
    • In the Table start at offset of data field, enter a value.
    • In the Number of rows per page field, enter a value.

      The default value is set 200 for number of rows.

  • In the Sort field, specify the option.
    • In the Direction field, select Descending or Ascending.

      The default value is set to Descending for the direction.

    • In the Select sort column field, select an option.

      You can choose between process title or the request creation, ID, title, status, or PII tag.

    • Select the Enable 2nd degree sort and specify the Direction and Select sort column fields.
  • In the Assign the result to variable field, assign a variable to store as an output.

    The output is stored as a table value.

As a result of the Query Requests action, a table is returned. The following table lists the table column names and the order in which they are returned for further extraction:

Table 1. Table column names
Index Column name
0 Request-ID
1 Request-Status
2 Request-Title
3 Request-Pii-Tag
4 Request-Full-Name
5 Process-Title
6 Created-Date
7 Updated-Date
8 Request-Ref
9 Created-By
10 Created-By-User-Group
11 Team-Name