QueryMaterialSublots (IMaterial)

Performs a query against a runtime database for material sublots. All material sublots 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 up to 500 of the most recently modified sublots.To return additional results, configure one or more queries using the Last Modified Time (Max) and Last Modified Time (Min) parameters. Bind the Last Modified Time (Max) parameter of subsequent queries to the OldestLastModified property of the MaterialLotCollection output parameter (in the Select Variable dialog box) from the previous query to return the next set of results. Each query returns up to 500 results.
InputsData TypeDescription
Detail LevelMaterialLotDetailLevel
Specifies the level of detail that you want the query to return. Valid values are:
  • OnlyAttributes
  • IncludeChildSublots
  • IncludeProperties
  • FullDetails
IsClosedBooleanIndicates whether the returned material sublots are closed or finished. Valid values are:
  • True
  • False
Last Modified Time (Max)DateTime

Specifies the latest modified date and time to include in your query. This is the most recent date/time that returned material sublots were modified.

Last Modified Time (Min)DateTime

Specifies the earliest modified date and time to include in your query. This is the earliest date/time that returned material sublots were modified.

LocationDirectoryResource

Specifies the equipment location to include in your query.

Material DefinitionDirectoryResource

Specifies the material definition to include in your query.

Material LotGUID

Specifies the ID of the material lot to include in your query.

Quantity MaxDouble

Specifies the maximum quantity to return.

Quantity MinDouble

Specifies the minimum quantity to return.

S95 IDStringSpecifies the name of the material sublot you are querying.
Note: The name you enter must be an exact match for the S95 ID. S95 IDs are case sensitive and wild cards are not permitted in a query.
StatusString

Specifies the run time status to include in your query.

OutputsDescription
MaterialSublotCollection Returns a collection of material sublots for a specific material lot based on the criteria indicated.

To access these properties, use an Index Activity or a For Each loop. You can use the parameter name as the index for the Index activity.