Report on sys_template table

[Tanvi modak1]

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

[Ankur Bawiskar]

@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

Before:

After:

[Tanvi modak1]

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. 

[Ankur Bawiskar]

@Tanvi modak1 

if you are looking to add this in report so that users can filter etc, then that's not possible.

it's a UI macro which renders that

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dr Atul G- LNG]

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