QueryWorkRequests (IProductionReport)

Performs a query against the runtime database for work requests based on the selected input parameters.

In the Configure Method dialog box, click Next to select query criteria to include as input parameters on the activity configuration panel.

InputsData TypeDescription
Creation Time (Max)DateTime

Specifies the latest creation date and time to include in your query. Only responses that occurred on or before this date/time are returned.

Creation Time (Min)DateTime

Specifies the earliest creation date and time to include in your query. Only responses that occurred on or after this date/time are returned.

End Tinme (Max)DateTime

Specifies the latest end date and time to include in your query. Only responses that occurred on or before this date/time are returned.

In the Configure Method dialog box, click Next to specify the criteria type to use in your query.

Note: If you select Range, then the End Time (Max) and End Time (Min) parameters are available and all responses matching the parameter inputs are returned. If you select Not Set, then the query returns only those responses that do not have an end date/time defined.

In the Inputs section of the activity configuration panel, click the drop-down arrow to set the date and time.

End Time (Min)DateTime

Specifies the earliest end date and time to include in your query. Only responses that occurred on or after this date/time are returned.

In the Configure Method dialog box, click Next to specify the criteria type to use in your query.

Note: If you select Range, then the End Time (Max) and End Time (Min) parameters are available and all responses matching the parameter inputs are returned. If you select Not Set, then the query returns only those responses that do not have an end date/time defined.

In the Inputs section of the activity configuration panel, click the drop-down arrow to set the date and time.

LocationDirectoryResource

Specifies the equipment location to include in your query.

In the Inputs section of the activity configuration panel, click the ellipsis button to open the Universal Browser to select the resource you want to use.

Priority (Max)Int

Specifies the highest priority value to include in your query. Only responses with a priority value equal to or less than this value are returned.

Priority (Min)Int

Specifies the lowest priority value to include in your query. Only responses with a priority value equal to or greater than this value are returned.

Start Time (Max)DateTime

Specifies the latest start date and time to include in your query. Only responses that occurred on or before this date/time are returned.

In the Configure Method dialog box, click Next to specify the criteria type to use in your query.

Note: If you select Range, then the Start Time (Max) and Start Time (Min) parameters are available and all responses matching the parameter inputs are returned. If you select Not Set, then the query returns only those responses that do not have a start date/time defined.

In the Inputs section of the activity configuration panel, click the drop-down arrow to set the date and time.

Start Time (Min)DateTime

Specifies the earliest start date and time to include in your query. Only responses that occurred on or after this date/time are returned.

In the Configure Method dialog box, click Next to specify the criteria type to use in your query.

Note: If you select Range, then the Start Time (Max) and Start Time (Min) parameters are available and all responses matching the parameter inputs are returned. If you select Not Set, then the query returns only those responses that do not have a start date/time defined.

In the Inputs section of the activity configuration panel, click the drop-down arrow to set the date and time.

StatusStringSpecifies the work request status to use in your query. Valid values are:
  • Draft
  • Unscheduled
  • Pending
  • Running
  • Paused
  • Completed
  • Failed
  • Canceled
  • Unknown

In the Configure Method dialog box, click Next to select a status. You cannot select or enter a status on the activity configuration panel.

Work DefinitionDirectoryResource

Specifies the work definition to include in your query.

In the Inputs section of the activity configuration panel, click the ellipsis button to open the Universal Browser to select the resource you want to use.

OutputsDescription
WorkRequestCollection Returns all of the work requests that match the query parameters.

Use a For Each Activity to loop though all resources, an Index Activity with an integer value, or the name of the work request.

Important: The returned collection of data is based on user-defined values and is dependent on your published data. For information on the attributes that can be read from, see Work Requests.