the formula in saved search criteria if the item contains SALT or SKID

AI generated answer (using internal Slack threads):

Based on the conversations, to create a formula in saved search criteria to filter items that contain 'SALT' or 'SKID', you can use the

LIKE

or

CONTAINS

keyword in your formula. Here is an example of how you can do it:

sql
CASE WHEN {item} LIKE '%SALT%' OR {item} LIKE '%SKID%' THEN 1 ELSE 0 END

In this formula,

{item}

is the field you are searching in. The

%

symbol is a wildcard that matches any number of characters. So,

%SALT%

will match any string that contains 'SALT' anywhere in it. The

CASE

statement returns 1 when the item contains 'SALT' or 'SKID', and 0 otherwise. Please note that this formula is case-sensitive. If you want to make it case-insensitive, you can use the

UPPER

function to convert both the field and the search string to upper case:

sql
CASE WHEN UPPER({item}) LIKE '%SALT%' OR UPPER({item}) LIKE '%SKID%' THEN 1 ELSE 0 END

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******