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