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 create a rule similar to the below
Related Articles
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 = ...
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 Average response time for Category
PGSQL: SELECT accountdefinition.org_name "Account",cd.categoryname "Category", TO_CHAR(((avg(wo.respondedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Response Time" FROM workorder wo LEFT JOIN workorderstates wos ON ...
Convert Incident to Service Request
For builds before 10536 The option will be available at: open the respective request > Actions > Convert incident to service request For builds after 10600 Edit the respective request > click on the Template dropdown [top-right corner] > Choose the ...
Disable Default Template - Using FAFR
1. Navigate to Admin>Incident Template>> Edit Default Template 2. Select Field & Form Rules Tab 3. Select On form Load 4. Make sure to select "Applies to Technicians" and set the action as Execute Script and paste the below script ...