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

[Pradeep Sharma]

Hello Brandimore,

dl_matcher is the table which stores the priority lookup values.

[brandimore]

Thank you very much. Can you tell me how know this? Is there a table definition somewhere online?

I'm sure at some point I will need to create an interactive filter on State also... for example

Thanks kindly for the quick response.

Is this an expected result to see when querying that table?

[brandimore]

Also, If I go to map the field to the Incident table, I don't see it as an option.

I am creating a dashboard where I have a tab that shows both incidents and service requests. Would priority not be a reference field?

[Pradeep Sharma]

Hello Brandimore,

You are right. Priority is not a reference field. It is a choice field.