We have been asked to build "tools" to load Change Categories as this is a major drain on our Change Management organization resources.
We have built "tools" to create files for loading the categories, their properties and workflow.
However, when the workflow is inserted, the Behaviors for each do not come across. It is not clear how best to load/relate them. This is where the help is needed.
My thesis - it appears (please correct me) that new rows need to be inserted into the Behavior_Template (bhvtpl):
When creating new task templates (wftpl) in a change category (chgcat) through the GUI, the system is doing a lot for you in the background. I allways call it the "business logic", which is mostly defined in the "object layer" of the application. The problem is, when loading data with the pdm_load tools, this business logic is not triggered, and you have to somehow rebuild this logic, allways hoping, that "your" logic does the same as the business logic.
So, what's next:
To answere your questions:
Hope that helps a bit, and kind regards
So I tried to pdm_deref the task field in Workflow_Task_Template via the tskty field to get the taskstat value in usp_lrel_status_codes_tsktypes. It returns only the first match. I need to get all of them.
Sam Cohen, Global Systems Manager
Marsh & McLennan Companies
Global Technology Infrastructure (MGTI) | ESE Application Engineering
121 River Street, Hoboken, NJ 07030, USA
+1 201 284 5213 | Mobile +1 908 472 0027 | email@example.com<mailto:firstname.lastname@example.org>
This cannot be done by a simple pdm_deref but should be processed in a script. In short:
With some assistance from this thread (thank you all), we have built a series of Excel workbooks to create loads for:
There were some "shortcuts" taken for making data references, based on the relatively static nature of some of the data (like Task types). If we add a new Task type we will need to update the workbook.
The audience is also very limited, so management is relatively easy.
CA SDM Loading Change category