Query to list fields used in each request template.
Go to Reports-New Query Report and execute this query.
POSTGRES
select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields" from requesttemplate_list rt
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' || rt.templatename) order by 1,2
MSSQL
select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields" from requesttemplate_list rt left join servicedefinition sd on sd.serviceid = rt.parent_service left join form_customizer fc on fc.form_name = ('WorkOrder_' + rt.templatename) where fc.index_tech >= 0
order by 1
New to ADSelfService Plus?
Resources
Related Articles
Query to display additional field associations with templates
Use case The reports shows in which templates the created additional fields are associated Query select sd.name "Service Catalog Name", rt.templatename "Template name", fc.field_name "Fields" from requesttemplate_list rt left ...Query to get list of service request templates created with Tasks associated to it.
Query will provide you the list of service request templated with Tasks associated to it from Builds: 10600 and above Execute the given query below from Reports-->New query report select sd.name "Service Name", rtl.templatename "Service Template ...Query to show account additional fields _ Details required
We Need to know whether that is a common account additional fields or add attribute under individual account. So please send us the following screenshots. 1. Admin-> Account additional fields list view page. 2. Accounts->Edit account and show ...Query to show number of tickets created per template with their status
SELECT reqtl.TEMPLATENAME "Request Template", count(wo.WORKORDERID) "Request Count", count(case when std.ispending='0' THEN 1 ELSE NULL END) "Completed", count(case when std.ispending='1' THEN 1 ELSE NULL END) "Pending" FROM WorkOrder wo LEFT JOIN ...Hide templates from drop-down while using a specific template using FAFR
The below script can be used in the respective incident template under Form Load section of Field and Form Rules. if(["Application Crashes Frequently","New incident"].indexOf(jQuery("select#template_box").select2("data").text)==-1){ ...