Item Saved Search returns multiple items using name field in criteria

The item saved search with criteria [“name”, “is”, “T18IF905SP”] gives multiple set of results. Items with similar name are returned in the result even though “is” is used.

By using Formula (Text), it is possible to retrieve the correct result.

The formula is CASE WHEN {itemid} = “T18IF905SP” THEN 1 ELSE 0 END

Leave a comment

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