Report on sys_template table

Tanvi modak1
Tera Contributor

2 hours ago

We have a requirement to report on sys_template table to add all fields related to templates like-CI, AG, Category, sub-category, priority, etc. within report

0 Helpfuls
  • 65 Views
2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

15m ago

@Tanvi modak1 

so what's the challenge?

it's system table and hence you cannot directly report on it.

Update this property "glide.ui.permitted_tables" with that table name at the end and then you can create report on that table

AnkurBawiskar_1-1762932479863.png

 

Before:

AnkurBawiskar_0-1762932442028.png

 

After:

AnkurBawiskar_2-1762932545727.png

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

6m ago

Hi @Tanvi modak1 

 

Sys template is not allowed to create report so you need to first update the system property to add sys template Thier and then you can report on it and then you can use the field in same to report

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls