Set Multiple Item Names as a criteria filter in an Item Saved Search

Set Multiple Item Names as a criteria filter in an Item Saved Search

  1. Navigate to ReportsSaved SearchesAll Saved SearchesNew

2. Select Item as Search Type

3. Assign a name on the Search Title field

4. On the Criteria tab > Standard sub tab> Filter column, add the following:

            a. Formula (Numeric) is equal to 1 then 

            b. Formula = Case when {name}=’XXXX’ OR {name}=’XXXX’ then 1 else 0 end

*Note: Replace XXXX with the exact item name. If you wish to search for more items simply add ” OR {name}=’XXXX’ ” for every item you wish to be added in the search.

5. Hit Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *