To fetch categories and sub categories for reports from sys_choice table

Nikita47
Giga Contributor

‎01-09-2020 05:10 AM

Hi,

My requirement to get a report of all the categories,sub categories & sub sub categories.

All the choices are stored in sys_choice table and my requirement is to get separate column of category sub category & sub sub categories. but i am not able to do this because category and sub category are coming under same column name i.e element.

I tried to do it through database view but ran out of ideas.

 

Pls help.

 

Regards,

Nikita

find_real_file.png

Labels:
Preview file
53 KB
0 Helpfuls
  • 2,460 Views
5 REPLIES 5

Anurag Tripathi
Mega Patron
Mega Patron

‎01-09-2020 05:12 AM

Hi,

Will grouping by element help?

-Anurag

-Anurag
0 Helpfuls

Nikita47
Giga Contributor
In response to Anurag Tripathi

‎01-10-2020 05:08 AM

Hi Anurag,

Sub categories are dependent on category. So, grouping by element won't help here.

 

Regards,

Nikita

0 Helpfuls

Alberto Consonn
ServiceNow Employee
ServiceNow Employee

‎01-09-2020 05:17 AM

Hi,

as workaround, you could do something like that:

Filter the sys_choice list that contains 'category', then Group By Element and finally export in XLS:

find_real_file.png

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

Thank you very much

Cheers
Alberto

Preview file
85 KB
0 Helpfuls

Darshani Sambar
Giga Contributor

‎01-09-2020 05:19 AM

Hi Nikita,

Please refer below link

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

 

Please mark as correct/helpful based on impact.

 

Thanks

Darshani Sambare

0 Helpfuls