Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report on sys_template table

Tanvi modak1
Tera Contributor

3 weeks 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
  • 535 Views
6 REPLIES 6

Tanvi modak1
Tera Contributor
In response to Dr Atul G- LNG

3 weeks ago

@Dr Atul G- LNG  We need to get the template values in the report so that the end users can sort or filter it by assignment group, priority, CI, category etc. 

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Tanvi modak1

3 weeks ago

Hi @Tanvi modak1 

 

That’s not possible — the reason is that the template is built on a specific table, and you’re trying to reference a table field within the sys_template report, which isn’t supported. You can only create reports based on the fields directly available in the sys_template table. There’s no direct way to reference template.table.field in this context.

*************************************************************************************************************
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