Report on sys_choice table

[Jose MMR]

Hi everyone,

I try to rise a report using sys_choice table as source of information. If I try to search table in report wizard  "Data source"

sys_choice option is not available.

If I check list for banned tables in report action sys_choice do not appears.

¿Coul anyone tell me if system avoid this action?

Regards.

[Ankur Bawiskar]

Hi,

even I tried adding that table in the system property 'glide.ui.permitted_tables' but still it didn't work

I believe it may not be possible to report on sys_choice table

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Prateek kumar]

Take a look at below doc on how to report on system tables.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

Please mark my response as correct answer and helpful if it helped solved your question.
-Best Regards
Prateek kumar

[Miguel Donayre]

Same i couldn't add it. What type of report are you trying to do? If its a list report you can always go to the table (sys_choice.LIST)and and run a simple list with some conditions

If I have answered your question, please mark my response as correct and/or helpful.

[Jose MMR]

Hi Miguel,

I want to create a report to lately add in several emails to share with tecnical users as a xml attached.

As i see in previous replys this form can not be used on this way.