Creating Custom Interactive Filter on Demand Table for a List Field

[anfield]

Can anyone help with creating a custom interactive filter on the collaborators field on the dmn_demand table. Looked up some articles on the community but cant find how to do it. The field itself is a list field which points to user (and can contain multiple)

Followed the steps in this URL:  https://community.servicenow.com/community?id=community_question&sys_id=ee9bd954db730cd4feb1a851ca961984

And here specifically (see below steps 1-4), but when the collaborators field comes up I cannot select it: 

To set it up:

1. Add a an interactive filter > Cascading Filter > #New Cascading Filter to your dashboard.
2. Give the filter a Name and save. 
3. On the Cascading Filter related list, click new to set up the fist level for the cascading filter.  You will set the table, display value and filter here.  Save the filter.
4. Now on the target tables, you set up the tables that the cascading filter will be used on.  In my case my target table was the project table and the field was a list collector.

After setting that up, you should be able use the cascading filter by selecting your value and then clicking the apply button to filter any of the other reports on your dashboard.

I can see another post but they are including creating a custom table. This is not preferable as we are being charged by servicenow for using custom tables : https://community.servicenow.com/community?id=community_question&sys_id=f5215bafdb97dc5011762183ca9619c2&view_source=searchResult

Does anyone have any suggestions on how to do this? Thanks

[Maik Skoddow]

Hi @anfield 

OOTB there is no interactive filter for list type fields. But you can build your own as described at https://community.servicenow.com/community?id=community_question&sys_id=65473ab0db96ec50b3c099ead396...

Kind regards
Maik

[Maik Skoddow]

Hi @anfield 

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik

[anfield]

Saik. I will update this soon. Thanks

[anfield]

Maik. I modified yours and just changed the filter_message.id and the filter_message.table. Added this to my dashboard and it showed wait time exceeded. I'm not quite sure what I need to change here. Do I need the sys_user section at the bottom also?