Query to list fields used in each request template.

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){ ...