Interactive Filters

[Siddhant VSK]

Hello, 

I have requirement of creating an interactive filter where in the incidents should be filtered based on the country field.

But in my table I could see that the country field is made as string , Hence when I search the country field in the interactive field references , I cannot find the country field as it is not a reference field and it is a string field.

@Uncle B please help with a work around here.

Sharing the screen shots for understanding.

Thanks in advance.

[Mark Manders]

Although you didn't ask me (and I wish people would stop tagging others as if they are entitled to the time of others), why not update your 'country' field to become a reference field to the core_country table? That solves your issue. A one time fix on the existing locations would get all the countries in place.

[SwapnilKumar]

Hi Siddhant,

 please find the below link which has a solution from knowledge session

https://www.servicenow.com/community/platform-analytics-forum/create-interactive-filter-to-search-on...

please Mark correct if my response is helpful