QuerySegmentResponses (IProductionReport)
Performs a query against the runtime database for segment responses based on the selected input parameters. All segment 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.
| Criteria | Data Type | Description |
|---|---|---|
| Actual Equipment | DirectoryResource |
Specifies the actual resource to include in your query. Only segment responses that are associated with this resource are returned by the query. You can specify an equipment instance or equipment class. 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. |
| Actual Equipment End Time | DateTime |
Specifies the utilization end date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have end times within the specified range are returned by the query. |
| Actual Equipment Start Time | DateTime |
Specifies the utilization start date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have start times within the specified range are returned by the query. |
| Actual Material | GUID |
Specifies the actual resource to include in your query. Only segment responses that are associated with this resource are returned by the query. You can specify a material definition, material class, material lot, or material sublot. Note: If you query by material lot or sublot, you must specify the ID of the
resource.
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. |
| Actual Material End Time | DateTime |
Specifies the utilization end date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have end times within the specified range are returned by the query. |
| Actual Material Start Time | DateTime |
Specifies the utilization start date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have start times within the specified range are returned by the query. |
| Actual Personnel | DirectoryResource |
Specifies the actual resource to include in your query. Only segment responses that are associated with this resource are returned by the query. You can specify a person (that is, a people resource) or a personnel class. 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. |
| Actual Personnel End Time | DateTime |
Specifies the utilization end date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have end times within the specified range are returned by the query. |
| Actual Personnel Start Time | DateTime |
Specifies the utilization start date and time, in UTC, for the actual. As part of defining this parameter, you must also select the Criteria Type as either Not Set (to indicate an unspecified (that is, null) value) or Range (to indicate any value between and including two specified values). If you select Range as the criteria type, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the actual time range, and one to designate the end (that, is, Max) of the actual time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses with actuals that are of the designated type and that have start times within the specified range are returned by the query. |
| Detail Level | SegmentResponseDetailLevel |
Specifies the detail level of the output. Valid values are:
Note: This is a mandatory criterion displayed by default in the
Inputs section of the activity configuration panel.
|
| End Time | DateTime |
Specifies the segment response end time. If you select this parameter, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the response time range, and one to designate the end (that, is, Max) of the response time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses that have end times within the specified range are returned by the query. |
| 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. |
| Parent Segment Response | GUID |
Specifies the ID of the parent segment response to include in your query. |
| S95 ID | String | Specifies the name of the segment response to include in your query. |
| Start Time | DateTime |
Specifies the segment response start time. If you select this parameter, two fields are displayed in the Inputs section of the activity configuration panel: one to designate the beginning (that is, Min) of the response time range, and one to designate the end (that, is, Max) of the response time range. Click the drop-down arrows within the fields to open a calendar tool, where you can select the date and specify the time. Only responses that have start times within the specified range are returned by the query. |
| Work Data Class | DirectoryResource | Specifies the work data class to include in your query. Note: If you select a work
data class in the Configure Method dialog box, you can also configure parameters based
on the properties of that class. 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. |
| Work Process Segment | DirectoryResource |
Specifies the work process segment 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. |
| Work Request | DirectoryResource |
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. |
| Work Response | GUID |
Specifies the ID of the work response to include in your query. |
| Outputs | Description | |
|---|---|---|
| SegmentResponseAttributes[ ] | Returns all of the segment responses that match the query parameters. Use a For Each Activity to loop though all resources or use an Index Activity with an integer value. Indexing is supported only by the integer value; it does not support string values. |