Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Interactive filter on Assigned To

brandimore
Kilo Expert

Hi All

I want to create an interactive filter on our dashboard on the Assigned Too field. I create a choice filter or a reference and no luck. I get "Invalid insert" when trying to do so.

This begs the question:

1. How can I get this done?

2. How can I know which type of filter I can do for a type of field. Is there a list of what fields can be used for what? Or can you know by looking at the lineage\properties?

You can do a reference filter on Assignment Group but not Assigned too. It's confusing to understand when\where I can do these things as they are both similar type of attribute fields.

find_real_file.png

Thanks!

1 ACCEPTED SOLUTION

Josh Cooper
ServiceNow Employee
ServiceNow Employee

It should be allowed for an Interactive Filter - for anything that's a choice or reference (that exists on the correct table)



Try this:


find_real_file.png



And save, then in Interactive Filter References at the bottom, create a new one for the Incident table (or whichever table you want to filter) by pointing it to the table name and the field that will hold the user:



find_real_file.png




See if that works for you!


View solution in original post

3 REPLIES 3

Josh Cooper
ServiceNow Employee
ServiceNow Employee

It should be allowed for an Interactive Filter - for anything that's a choice or reference (that exists on the correct table)



Try this:


find_real_file.png



And save, then in Interactive Filter References at the bottom, create a new one for the Incident table (or whichever table you want to filter) by pointing it to the table name and the field that will hold the user:



find_real_file.png




See if that works for you!


Yes that was it. Filtering on the User (sys_user) table! Thanks very much.


Deepak92
Tera Contributor

Hi All,

 

I want to have an interactive filter where i want assigned to me only ( Assigned to me Dynamic) .

How can i achieve the same .

 

Thanks in advance .

 

Regards

Deepak