Where are Choice List configurations saved?

[Michael_Nau]

Hi guys,

If we look at the choices for a field, e.g. incident.state, we can see that there is no choice with a value of "4" available on the incident table. However, the parent table task has one ("Closed Incomplete"):

Still, a state of "Closed Incomplete" is not available on incident, because it has been removed via "Configure Choices":

Question:

Where is this choice configuration saved - which table do I have to look at to see that a choice is not available on an extended table?

[Alberto Consonn]

Hi,

look at this table sys_choice

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thanks you

Cheers
Alberto

[Michael_Nau]

Hi Alberto,

what table do you think the first screenshot is taken from?

Did you read the question?

[Michael_Nau]

I just had a look at this with a colleague. You are actually partly right. When the choices have been configured, that is when an admin has actually modified the available choices, those which are not available have an inactive record on sys_choice. However, this is not the case in an OOTB state!

If you look at my example, you can see that there is NO inactive record for incident, but still the choice is not available.

Regards,

Michael

[Alikutty A]

Hello,

We use the sys_choice table for maintaining choices.The choices can be created either at the parent table level (task) or at the child table level (incident). If you delete all choices from sys_choice for Table=incident, then you would only see the choices from the task table on incident form.

By default if you open any task record, you would be see all choices associated with table=task including 3,4 etc. But if you need to override these values, then you can add new choices with Table=incident. Once you add this override, you would no longer see the choices from task table and all you could see is choices from the incident table.

Thanks!