PTC FlexPLM Fundamentals > Line Sheet Management > Working with the Freeze Pane Function > Filtering Items in the Freeze Pane View
  
Filtering Items in the Freeze Pane View
Filtering Items
To filter items in the freeze pane view, do the following:
1. Click the arrow in the column header and select Filters.
2. Enter or select the filter criteria, and then press ENTER.
Guidelines for Filtering Items
• You can filter on multiple columns.
• Not all columns can be filtered, depending on the data they contain.
• To remove all filters, click Clear Filters .
• To see all filters that are currently enabled, click Show Filters.
• For BOM material pane and color pane, the Insert Material andInsert Color columns are locked by default.
• When a filter is applied to a given column, its column header changes to bold italic to indicate that there is an active filter.
• Filters can be used in both view and edit mode. In edit mode, the filter criteria applies to the existing persisted value only. It does not apply to any new values that you have entered in the New fields.
• To easily identify the status of a product or colorway, you can filter on color choice attributes such as green, yellow, or red.
• You can export a line sheet on a filtered data set to Excel, PDF, and CSV.
• Filters are available for boolean, string, list, date, and number fields.
◦ For boolean filters, select yes or no.
◦ For string filters, enter freeform text to find a string of characters. Enter empty to find rows with no values.
◦ For list filters, select from the list of available values. To find rows with blank values, select (Empty).
◦ For date filters, enter a range of before and after dates, or enter an exact date.
◦ For number filters, enter a range of greater than or less than numerical values, or enter an exact match.
Filtering on Multi-List Attributes
You can filter on multi-list attributes when the selected value is exclusive for a given product or colorway. You can select (Exclusively), (Empty), and (All Selected) to customize the line sheet display.
• Select values and (Exclusively) to display rows that contain only those values.
• Select (Empty) to display empty rows for that value.
• Select values and (All Selected) to display rows that contain all the selected values.
In this example, the line sheet contains a list of channels for Internet, Retail, and Wholesale.
Selection
Result
Example
Two or more list values
Rows that contain either of the list values
If you select Retail and Internet, the line sheet displays rows that contain either Retail or Internet. The rows can contain additional values such as Wholesale.
A list value and (Exclusively)
Rows where the list value is the only value
If you select Internet and (Exclusively), the line sheet displays rows that only contain Internet.
Two or more list values and (Exclusively)
Rows where each value is the only value
If you select Internet, Retail, and (Exclusively), the line sheet displays rows that contain either Internet only or Retail only. The rows do not contain additional values.
A list value, (Empty), and (Exclusively)
Rows that contain only the list value and all empty rows
If you select Internet, (Empty), and (Exclusively), the line sheet displays rows that contain Internet only. The line sheet also displays empty rows.
A list value and (Empty)
Rows that contain the list value and all empty rows
If you select Internet and (Empty), the line sheet displays rows that contain Internet and empty rows. The rows with Internet can contain additional values such as Wholesale.
Two or more list values and (Empty)
Rows that contain either of the list values and all empty rows.
If you select Internet, Retail, and (Empty), the line sheet displays rows that contain either Retail or Internet and rows that are empty. The rows with Retail or Internet can contain additional values such as Wholesale.
Two or more list values and (All Selected)
Rows that contain both list values; rows can contain additional values
If you select Internet, Retail, and (All Selected), the line sheet displays rows that contain both Retail and Internet but can include additional values such as Wholesale.
Two or more list values, (Exclusively), and (All Selected)
Rows that contain the selected list values and no other values
If you select Internet, Retail, (Exclusively), and (All Selected), the line sheet displays rows that contain both Retail and Internet but no other values.
Two or more list values, (Empty), and (Exclusively)
Rows that contain either list value, but not both, and all empty rows
If you select Internet, Retail, (Empty), and (Exclusively), the line sheet displays rows that contain either Internet only or Retail only. The line sheet also displays empty rows.