Is there a way to extract the workflow tasks within a particular change order category?
This question raises as there is no "export" button on change order category workflow tasks tab so if other team/management would need to
review the tasks of certain change order category to decide which ones to retain and which ones to delete, SDM administrators will need to perform some extracts and present for review.
Release : 17.1/17.2/17.3
Component : SERVICE DESK BUSINESS OBJECTS
Please run these commands from command prompt on Service Desk server
1. pdm_extract -f "select id, sym from Change_Category where sym='the-category-name'"
note the id from this output as you will need it in next step
2 pdm_extract -f "select sequence, task from Workflow_Task_Template where object_attrval='id-value-from-step1'" > category-task-report.txt
this command will extract the sequence and task code to the output file. if the codes are not easy to understand, you may need to run next command
3. (optional) pdm_extract -f "select code, sym from Task_Type" > code-to-name.txt