Thursday, February 28, 2019

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

1. Navigate to Reports> Saved Searches> All Saved Searches> New
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

No comments:

Post a Comment