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
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 for request attachment details
Requests with Attachment, its name and path SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", sa.ATTACHMENTNAME "Attachment Name", sa.ATTACHMENTPATH "Attachment Path" FROM ...
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){ ...