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.

Note: If you do not select any query criteria as input parameters, your query returns all segment responses.
CriteriaData TypeDescription
Actual EquipmentDirectoryResource

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 TimeDateTime

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 TimeDateTime

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 MaterialGUID

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 TimeDateTime

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 TimeDateTime

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 PersonnelDirectoryResource

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 TimeDateTime

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 TimeDateTime

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 LevelSegmentResponseDetailLevel
Specifies the detail level of the output. Valid values are:
  • AttributesOnly
  • IncludeWorkData
  • IncludeEquipmentActuals
  • IncludeMaterialActuals
  • IncludePersonnelActuals
  • ChildrenOnly
  • FullDetails
Note: This is a mandatory criterion displayed by default in the Inputs section of the activity configuration panel.
End TimeDateTime

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.

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.

Parent Segment ResponseGUID

Specifies the ID of the parent segment response to include in your query.

S95 IDStringSpecifies the name of the segment response to include in your query.
Start TimeDateTime

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 ClassDirectoryResourceSpecifies 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 SegmentDirectoryResource

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 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.

Work ResponseGUID

Specifies the ID of the work response to include in your query.

OutputsDescription
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.