Customize the category list/selection based on template.

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