Adding a filter

You can create multiple filters but only one filter can be active at a time. Any search field can be used as a filter and not needed to be added as a column in the query view.

When style is selected as the entity value for the FQV record, the style number column is automatically added in the table.​

When material is selected as the entity value for the FQV record, the material number column is automatically added in the table.​

When trim is selected as the entity value for the FQV record, the trim number column is automatically added in the table.​

  1. Open a flex query view.
  2. Click the Advanced Filter icon.
  3. On the Saved Filters section, click the Add New Row icon.
  4. Specify this information:
    Name
    Specify the name of the filter.
    Active
    Select to make this filter active. Selected by default if this is the first filter in the list.
  5. To add a criteria, on the Criteria section, click the Add New Row icon.
  6. Select from the list whether all or any of the criteria applies for this filter.
  7. Specify this information:
    Info Cluster
    Select from the list.
    Search Field
    Select a field to base the search on. The values on this list depend on the Info Cluster that you selected.
    Condition
    Select a condition from the list. The values on this list depend on the Search Field that you selected.

    If you select a Date field in Search Field, you can select Blank / Not Blank to search for blank or not blank records.

    Search Value
    This field depends on the Condition that you selected. You can either directly specify a value, select a value from a list, or select multiple values from a list.
    Note: This field can be blank, but you must specify a value before running the query.

    If you select a date field in Search Field and Blank / Not Blank as the Condition, you can select Blank or Not Blank.

    You can search for text fields that have blank or not blank values by specifying <Blank> or <Not Blank> (not case sensitive), respectively, as the value of Search Value.

    The search values for these Style BOM fields display all the generic lookup values from all three component types. The values in the drop down list have a prefix of style, material, or trim in order to identify which component type the lookup belongs to:
    • User Defined Field 12
    • User Defined Field 13
  8. If you need to add another criteria, click the Add New Row icon.
  9. Close the window when you are done.
  10. Click the Execute icon.
  11. When the execution is finished, click Save.