Using the Column Chooser

Use the Column Chooser to add fields to the query view. You can add up to 60 fields or columns. This function is applicable for style, material, or trim.​

You must first save the newly created records first before you enable the column chooser and advanced filter buttons.

  1. Open a flex query view.
  2. Click the Column Chooser icon.
  3. In the Column Chooser pane, select an Info Cluster.
    The contents of the list depends on the Entity value that you have selected from the main information of the record. If you want to select all values, click Select All.
  4. Still on the Column Chooser pane, you can add columns in two ways:
    • Drag fields from the pane to the query view.
    • Select fields then click ADD.
    Note: 
    • Calculated fields are not added and cannot be used for building queries.
    • Radio buttons and check boxes show Yes (if the check box or radio button is selected) or No (if the check box or radio button is not selected) values in queries.
    • In query results, the values for multi-select fields are displayed in a single cell in a row, separated by commas.
    • While these Style BOM fields display the generic lookup values depending on the component type (style, material, or trim), the search results display all the generic lookup values from all three component types:
      • User Defined Field 12
      • User Defined Field 13