Material Inventory Filters

The Inventory View uses filtering to retrieve and display large amounts of data more efficiently.

Clicking the Show Filters button opens the filter editor, which contains filtering options for material lots.

The following table describes the available filtering options:

AttributeValueDescription
Start DateDateTime

Specifies the earliest date and time to filter by. Only lots that occurred on or after this date are returned.

End DateDateTime

Specifies the latest date and time to filter by. Only lots that occurred on or before this date are returned.

MinimumInt32 Specifies the minimum number of lots to display.
MaximumInt32 Specifies the maximum number of lots to display.
S95 ID String

Specifies the name of the material lot to filter by.

Note: The name you enter must be an exact match. S95 IDs are case sensitive and wild cards are not permitted in a filter query.
Location DirectoryResource Specifies the location of the material lot to filter by.
Status String Specifies the status to filter by.
ClosedBooleanSelect this check box to return material lots that are closed.

When you use filter parameters, the relevant material lots are displayed in the Inventory View. If the material lot set returns a greater number than the maximum quantity permits, a link appears in the results display. Clicking this link advances the display to show the next set of material lots within the allowable range.

If a material lot is expanded and it contains more results than the maximum quantity permits, a link appears in the results display. Clicking this link retrieves the next set of material sublots within the allowable range.

If you click the Refresh button with no filter selected, the original set of material lots is displayed.