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 Jose,

you can try to have database view with self join on sys_choice table and then use that database view in reporting; check below links:

https://community.servicenow.com/community?id=community_question&sys_id=af794f65db5cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=81d117addbdcdbc01dcaf3231f96...

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

[Jose MMR]

Hi Ankur,

I create a view but results are duplicated.

On other hand:

-I modify System property glide.ui.permitted_tables adding sys_choice

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

-I create a "report source" over sys_choice

-I create new report using report source recently created and works!

Now I can use command  ${report:reportID:XXXXXXXXXX:xls} on email.

[Ankur Bawiskar · Accepted solution]

I am glad to hear your goal has been achieved.
Saying this, I will appreciate if you close this thread, as answered.
Have a great rest of the day

[John S]

Hi Jose, what kind of report are you trying to do?

[Jose MMR]

Hi Josh, I can solve the problem change to available the sys_choice table to reports.