CSA · Question #195
When looking at a long list of records, you want to quickly filter, to show only those which have Short Description containing email. How might you do that?
The correct answer is C. Click List Magnifier to expand column search, on Short Description, type *email, click enter. To filter a list for records where the Short Description field contains 'email,' use the column search magnifier, type *email in the Short Description field, and press enter.
Question
When looking at a long list of records, you want to quickly filter, to show only those which have Short Description containing email. How might you do that?
Options
- AClick List Magnifier to expand column search, on Short Description, type email, click enter
- BOn Search box, select text, type email, click enter
- CClick List Magnifier to expand column search, on Short Description, type *email, click enter
- DClick List Magnifier to expand column search, on Short Description, type %email, click enter
How the community answered
(15 responses)- A7% (1)
- C93% (14)
Why each option
To filter a list for records where the Short Description field contains 'email,' use the column search magnifier, type *email in the Short Description field, and press enter.
Typing 'email' without a wildcard in the column search typically performs an 'is' or 'starts with' search, not a 'contains' search.
The general search box typically applies a global text search across multiple fields or uses different syntax, and isn't specific to filtering a single column by 'contains' with precise control.
In ServiceNow list filtering, the asterisk '*' acts as a wildcard for 'contains' when performing a column search. Expanding the column search using the magnifier, entering '*email' in the Short Description field, and pressing Enter will display all records where the Short Description text includes 'email' anywhere within the string.
The percentage sign '%' is commonly used as a wildcard in database SQL queries but is not the standard 'contains' wildcard character for column searches in the ServiceNow UI; the asterisk '*' is used instead.
Concept tested: List filtering with 'contains' wildcard
Source: https://docs.servicenow.com/bundle/utah-platform-user-interface/page/use/using-lists/concept/c_FilterAList.html
Topics
Community Discussion
No community discussion yet for this question.