How to create interactive filter for list field ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā06-23-2022 03:04 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā06-23-2022 06:27 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā06-23-2022 06:35 AM
I believe there are some limitations using list field in interactive filter
check these links
Create Interactive filter for field type - "List Collector"
Regards
Ankur
Ankur
⨠Certified Technical Architect || ⨠10x ServiceNow MVP || ⨠ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā06-23-2022 06:44 AM
Actually I checked those links
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
Thanks for your quick response.. you can find the code in the above link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā06-23-2022 10:55 PM