Thursday, April 25, 2019

Create an Item Saved Search to Filter Only Numeric Item Names

1. Navigate to Lists > Search > Saved Searches > New

2. Choose Item


3. Under the Criteria subtab > Standard subtab > Add Filter

Type = Inventory Item

Formula (Numeric) > Click the Set Description Icon

Formula: CASE WHEN translate({name},'abcdefghijklmnopqrtsuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*()_+=-','*') = {name} THEN 1 else 0 END

Formula (Numeric) = equal to

Value = 1

4.On the Results tab > Columns subtab > Add Fields of your preference

5. Name your Saved Search.

6. Click Save & Run Button.

No comments:

Post a Comment