Scenario: User creates Bill of Materials saved search but shows duplicate lines. This behavior is caused by the number of the Bill of Materials revision.
Solution:
Navigate to Reports > Saved Searches > All Saved Searches > New
Select Bill of Materials
Search Title: Enter Title
Click Criteria
Click Standard
Filter:
Select Formula (Numeric)
Formula: Enter CASE WHEN {revisionname}={revision} THEN 1 ELSE 0 END
Formula (Numeric): Select equal to
Value: Enter 1
Click Results
Click Columns
Field:
Note: Add fields/columns as necessary
Click Add
Click Save & Run