How to create interactive filter for list field ?

Sathwik1
Tera Guru

How to create interactive filter for list field ?

In the incident table I am having a field called "Group" which is a list field and it refers to "sys_user_group" table..

I understand that I need to use  filter as "Cascading Filter" but I was not able to understand what fields should I select in related list..

can some one please guide me on this?

@Ankur Bawiskar @Aman Kumar @Allen Andreas @Mark Roethof 

4 REPLIES 4

Sathwik1
Tera Guru

@Maik Skoddow 

I used the below link Approach 3.. by using that I was successfully achieved my half requirement,,

Achieved:

There is a field "User" on incident table and it is a list collector.. by using the above code I achieved this requirmeent..

Need to achieve:

There is a field "user " on requested item table and it is a list collector.. so with the same above code I want to filter this records as well..

is it possible?

function publishCustomWatchListFilter() {  
    var objFilter = {
      id     : 'custom_watch_list_filter',
      table  : 'incident',
      filter : arrItemSysId.length > 0 ? 'u_user_dataDYNAMIC' + arrItemSysId : ''
    };

If I add one more similar object here then will it work.. 

please help @Maik Skoddow 

@Ankur Bawiskar  

I believe there are some limitations using list field in interactive filter

check these links

Custom interactive filters

Create Interactive filter for field type - "List Collector"

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Actually I checked those links @Ankur Bawiskar 

but it did helped me...

there is an article written by Maik,, in that Approach 3 helped me..

link below..

https://community.servicenow.com/community?id=community_article&sys_id=04e1c50cdbd98114382a8263059619b3

so now my problem is.. based on this only one table records I can filter..

but in my dashboard there are two reports..

1.one on incident

2.one on requested item

In both tables there is a field called "user" which is a list collector... and this field was created on respective tables..those are not inherited..

so based on above code.. incident records are filtering... till here it was working fine..

so now I want that filter condiiton needs to apply for requested table as well. 

please help me to modify the code @Ankur Bawiskar waiting for your reply .

Thanks for your quick response..  you can find the code in the above link 

@Ankur Bawiskar @Jaspal Singh @Aman Kumar @Sagar Pagar @Allen Andreas can anyone help me to update the code?