Interactive Filter on the Priority field

[brandimore]

Hello,

Can someone tell me which table hosts the priority field? I have an interactive filter for Assignment group and when I create a reference filter, I use the table - > Group (sys_user_group) and this returns all the groups in our system.

I'm looking for something similar for priority and I can't find a useful table. Am I missing something?

Thank you

[brandimore]

Thanks Arnoud. I will review this later today!

[brandimore]

Arnoud, I'm curious as to why I would do a choice list for this, but not for the assignment groups (based on the last question you helped me with in using the script). Both are multiple picklist items to filter multiple unique reports\widgets. Can you explain the difference in approach, to help me understand please?

[brandimore]

I found this that you wrote in July, I'm wondering if it conflicts with what you are saying:

[Arnoud Kooi]

Not really conflicting, but the last couple of weeks I'm exploring custom interactive filters, for more advanced use-cases.

[brandimore · Accepted solution]

Me again! HA

I may of found a solution. I create the choice filter and filter on the TASK table.

Even though the 2 widgets are in SC_Task and Incident, it appears to filter as they are extensions. What do you think of that solution?