Tofilter a long list of recordsand find those whereShort Description contains "email", the best practice is to use thecolumn searchfeature:
Click the List Magnifier (#)to open thecolumn searchoptions.
In the "Short Description" column search box, type:
Steps to Filter a List by "email" in Short Description:email
Press Enterto apply the filter.
This methodautomatically applies a "contains" filter, meaning it will showany records where "email" appears anywhere in the Short Description field.
A). Click List Magnifier to expand column search, on Short Description, type %email, click enter #Incorrect
% (percent sign) is not a valid wildcardin ServiceNow's list filters.
C). On Search box, select text, type email, click enter #Incorrect
Theglobal search box searches across multiple tables, not just the Short Description field.
D). Click List Magnifier to expand column search, on Short Description type 'email, click enter #Incorrect Single quotes ('email') are not requiredin column searches.
Why Other Options Are Incorrect?
Using List Filters in ServiceNow
ServiceNow Search Operators
Official ServiceNow Documentation Reference: