Advanced Search

WA allows you to perform advanced searches at the Concept, Development, Analytics, and Parts Catalog levels to search for parts in the BoM that belong to each product.

To use the Advanced search options:
  1. Select one of the following:
    • Concept > Functional BoM management.
    • Development > E-BoM Management.
    • Analytics > Reporting.
    • Parts Catalog > Parts Management.
  2. Select the Advanced Search tab and click the icon to create a new filter.
    A new row is added to the filter table.
    The attribute column of the new line in the filter table displays all the attributes that are available for a part in the dropdown list.


  3. Select the required attribute from the Attribute column dropdown list.
    The filter item will be created based on this attribute and the Operator and Changed values columns are enabled.
  4. Click the required comparison operator from the Operator column.
    Table 1. Comparison Operators
    Operator and Example Description
    < 50 This operator is used for number fields. The results will include only those records where the field contains a value of less than 50.
    > 25 This operator is used for number fields. The results will include only those records where the field contains a value of greater than 25.
    <= 50 This operator is used for number fields. The results will include only those records where the field contains a value of less than or equal to 50.
    >= 25 This operator is used for number fields. The results will include only those records where the field contains a value of greater than or equal to 25.
    = 10 This operator is used for number fields. The results will include only those records where the field contains a value that is equal to 10.
    <>15 This operator can be used for any type of field. The results will include only those records where the field contains a value that is different from 15.
    IS NULL / IS NOT NULL This operator can be used for any type of field. The results will include only those records where the field value is NULL or contains some value (NOT NULL) depending on the choice of the operator.
    IN 12, 13, AA, BB This operator can be used for string fields. The results will include only those records where the field value is exactly equal to 12 or is exactly equal to 13 or is exactly equal to AA or is exactly equal to BB. This operator is similar to the NOT IN operator.
    LIKE AAA This operator can be used for string fields. The results will include only those records where the field value contains AAA anywhere in the value. This operator is similar to the NOT LIKE operator.
    For more information about how to use the IN and LIKE operators, see IN and LIKE Operators.
    Table 2. Filtering Operators
    Operator and Example Description
    IS DUPLICATED This operator is used for any type of field and does not need any value. The results will include only those records where the attribute value is duplicated in other records.
    Table 3. Sorting Operators
    Operator and Example Description
    ORDER BY ASCENDING This operator is used for any type of field. Acceptable values are ASCENDING and DESCENDING. The resulting records will be ordered by the attribute in ascending order.
  5. Enter the text/value that you want to compare with the selected attribute in the Values column of the filter.
    The list of operators shown and the field type displayed in the Values column depends on the selected attribute. For example, if you select Weight Maturity as the filtering attribute, then the Values column will display a dropdown list with all the available weight maturity statuses.
  6. To reset the search row filters, click the icon.
  7. To navigate the search rows:
    1. Right-click a row in the search.


    2. Use the arrow icons to move the selected row up or down in the search.
  8. To remove a search criteria or delete a search row, select a row from the search and click the icon.
    The search criteria is removed from the search.

Save a Search

To save the search that you have created:
  1. Enter a reference name for the search in the Search Name field.
  2. Click the icon to save the search.
    The search will be saved for future reuse with the specified name and available for selection from the Saved search dropdown list.

Delete a Saved Search

To delete a saved search:
  1. Select the search that you want to delete from the Saved search dropdown list.
  2. Click the icon to delete the selected search.
    The selected search will be deleted from the list of saved searches.

Using Parentheses

To use parentheses in a search:
  1. In a search row, select an opening parenthesis from the Parenthesis column.
  2. To create multiple combinations of search criteria, select the required closing parentheses and repeat the same steps for all the search rows.

Automatic Rules

To perform automatic checks to execute a search query:
  1. Create a new search or select a saved search from the Saved search dropdown list.
  2. Click the icon to execute the query.
    WA automatically checks for syntax, complete parentheses, and other conditions before executing the query and displays the errors in the search query, if applicable.

Where Used

To view where the selected part is used in the BoM and continue working on the filtered parts, select a part in the Search Results window and click the Where Used icon.
The Where Used dialog box is displayed.

View the Part Structure

To view the Part structure in the search results:
To view the part structure of a particular part, select the part in the Search Results window and click the Part Structure icon.
The Part Structure dialog box is displayed.

Customize Grid Columns

To customize the grid column view:
  1. In the Search Results window, click the icon.
  2. In the Customize Grid View dialog box, select the column or cluster checkboxes that you want to include in the table.


    The list of checkboxes on the left are the individual columns that can be added or removed from the table. The check boxes in the Cluster groups selection selection list are the categories of columns. If you select any cluster from this list, all columns that belong to this cluster are selected automatically.
    Note: The column view in the Customize grid columns dialog box is context-dependent and varies for Concept, Development, or Part Catalog.
  3. Click Save and Close to save the changes that you have made.
    The selected columns will be added to the table and the unselected columns will be removed from the table.

Save as XLSX Report

To save the search results as an XLSX report:
In the Search Results window, click the icon.
The selected search results are exported as an Excel report and displays the code, description, weight and cost details, and so on.

Filter Search criteria

To filter the search criteria:
  1. In the Search Results window, click the icon.
    Filters are displayed for each column of the search results.


  2. Use the filters in each column to select a value from the respective dropdown list.

Create Combinations of Filtering Criteria using Logical Operators

To create combinations of filtering criteria:
  1. Click the icon to add another criteria to the search.
  2. Repeat the same steps to add another filter item.
    After a second filter item has been added, the Logic Operator for the newly added filter displays the following two options:
    • AND
    • OR
    You can specify a logical relation between the search filters using logical operators. For more information about using logical operators, see Logical Operators.
  3. After the required filters are added, click the icon.
    The BoM is searched based on the specified filters and the search results are displayed in the Search Results table.
    Note: Add a note about precedence only for AND and OR.