QueryWorkResponses (IProductionReport)

Performs a query against the runtime database for work responses based on the selected input parameters. All work responses that match the specified query criteria are returned.

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

Note: If you do not select any query criteria as input parameters, your query returns all work responses.
InputsData TypeDescription
Detail LevelWorkResponseDetailLevel
Specifies the detail level of the output. Select one of the following:
  • IncludeSegmentResponses
  • AttributesOnly
End Time (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.

Origin Work RequestDirectoryResourceSpecifies the originating work request to include in your query.
Note: This parameter applies only if any of the work responses you are querying have been moved from one work request to another.

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.

Response StateString
Specifies the work response state to include in your query.
  • Ready
  • Completed
  • Holding
  • Aborted
Segment Dtail LevelSegmentResponseDetailLevel
Specifies the detail level of the output. Valid values are:
  • AttributesOnly
  • IncludeWorkData
  • IncludeEquipmentActuals
  • IncludeMaterialActuals
  • IncludePersonnelActuals
  • ChildrenOnly
  • FullDetails
Start Time (Max)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.

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.

Work RequestDirectoryResource

Specifies the work request 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
WorkResponseCollection Returns all of the work responses 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 response.

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.