How to fetch Subcategory of incident table to a custom table field which is of type list collector

[Alex_3]

Hello Community,

I have a custom table and have u_subcategory filed of type List , so I want to fetch the subcategory form incident table to my custom table.

Appreciate your help!

Regards,

Alex

[Ehab Pilloor]

Hi @Alex_3, 

If your custom table is extended from incident table, then it is possible for you to fetch the subcategory inherited from Incident table. Otherwise you can't fetch it.

It's better to configure the choices manually rather than extending Incident table for the sole purpose of getting the Subcategory field.

If you found my response useful, please mark it as Solution and Helpful.

Thanks and Regards,

Ehab

[Mark Manders]

You will just need to create the choices yourself, or put a filter on the list field to lookup all sys_choices from the incident table for the subcategory field.

[Alex_3]

Hello @Mark Manders ,

I am not able to reference the sys_choice table while using List variable. Instead Choice set available.

[Mark Manders]

You can put your Ref qualifier condition on 'table is incident' and 'element = subcategory' and it will show you all the subcategory choices from the incident table.