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 ...How to show only specific categories in a request template
Use case There are scenarios where on a particular template only selected categories should be available as an option. Solution Under Admin >> Incident Template >> Field and Form Rules Tab, create a rule as specified below Script: ...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 ...