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

          • 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){ ...
          • Query to list Service Request Approver and Purchase Request Approver

            Postgres & SQL Select aau.first_name "Name", po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request Approver", adef.org_name "Account" from aaauser aau left join POApproverDetails po on po.approver=aau.user_id left join ...
          • Customize the category list/selection based on template.

            The Category applies to all the templates in SDP-MSP.  You can hide them using the field and form rules to make them unavailable for users.  Under Admin >> Incident Template >> Edit the template in questions >> Field and Form Rules tab. You can ...
          • Query to show service catalog template details

            select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl LEFT JOIN requesttemplate_fields rtf ON rtl.templateid=rtf.templateid LEFT ...
          • Query to show Request and associated task details

            PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", icd.NAME AS "Item", ti.FIRST_NAME AS "Technician", ...