Regarding report Creation

[somya-gupta25]

I am trying to create a report in ServiceNow for the Demand table, where the Title or Description contains the keyword “SLA”. However, the report is also pulling in irrelevant data where the Title or Description includes unrelated terms like “translation” or “island”. I want to exclude such entries from the report.

Since the report builder doesn’t support regex, I’m unsure how to dynamically filter out these unwanted records without hardcoding every possible keyword. Can someone please help me with a better approach to handle this?

[AndersBGS]

Hi @somya-gupta25 ,

 please note that it’s not best practice to base your report on description or short description contains… rather see if you can do the filtration based on choices or references. Besides the fact that you get unwanted records like the once you have mentioned, they are more heavy to load.

[Dr Atul G- LNG]

Hi @somya-gupta25 

This is expected behavior, as you are searching within a string. During the search, it will look for matches in a similar way. Therefore, your report may not always be accurate. It’s better to change the filter to use a reference or dropdown value, which follows a standard approach."

[somya-gupta25]

Thanks for your response

Since Title and Description are string fields, how can we apply filters based on reference or dropdown values? Could you please suggest the best way to achieve this?

[Dr Atul G- LNG]

Hi @somya-gupta25 

As I mentioned earlier, using 'Short Description' and 'Description' for searching is inconsistent and not always accurate. Instead, you can use attributes like 'Category', 'Service', or 'Assignment Group', which have standardized values across the platform. These are more reliable for consistent search results.

https://youtu.be/t0EJ4Rx07DA

https://youtu.be/BCUJZd_KilA