Interactive Filters using sys_choice

[Nick29]

We are recently implemented asset management and started to create reports on a dashboard. Being a global company, we're looking to add an interactive filter by Region. The issue we are facing is our region choices are in the sys_choice table.

For some odd reason, the early developers didn't make a table for regions (like u_regions, which is currently being used by another application) and we are far too invested to redevelop this structure. They added them into the sys_choice table. Trying different combinations, I am not able to configure an interactive filter to show assets by region. 

We're reporting on the alm_asset table, with the region reference value being : alm_asset.location.u_region. Also, same with the stockroom : alm_asset.stockroom.location.u_region.

Any advice how to filter on those fields with sys_choice values?

[AnveshKumar M · Accepted solution]

Hi @Nick29 ,

You can make use of dynamic filters using content blocks. Refer one of my answer for detailed step by step instructions, you can create one similar to this. And in the same question I wrote multiple answers for different use cases, you can try exploring those to make yours.

Or let me know if you need any help.

https://www.servicenow.com/community/developer-forum/need-help-on-interactive-filter-report-conditio... 

Thanks,

Anvesh

[Nick29]

That worked. Thank you!