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.
| Inputs | Data Type | Description |
|---|---|---|
| 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. |
| Location | DirectoryResource |
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. |
| Status | String | Specifies the work request status to use in your query. Valid values are:
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 Definition | DirectoryResource |
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. |
| Outputs | Description | |
|---|---|---|
| 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. |