MDUPDCFLD - Update Project/Task Custom Field command
MDCMS is delivered with a command-based API that allows external tools or applications to add, update or remove a Custom Field value from an existing Project, Task or Subtask in MDCMS.
The MDCMS command is named MDUPDCFLD and is located in library MDCMS. It is not necessary to have the MD libraries in the library list prior to using this command. If you are unable to invoke a command from your Project Management tool, you can also directly call program MDUPDCFLD in library MDCMS. In this case, be certain that the parameters sent to the program exactly match the parameters in command MDUPDCFLD.
Successful MDUPDCFLD transactions are logged in file MDCMS(ENV)/MDDTHST and visible from the Full History listing in the MDWorkflow web application.
NOTE: If Location Synchronization is used (MDCMS Settings option 6), the API will only need to be invoked for 1 system. The other partitions or physical systems will automatically be synchronized.
If the target Project is closed or if the custom field isn't defined in MDCMS, the entry will not be processed.
MDUPDCFLD Parameter Table
| Name | Type | Length | Description |
|---|---|---|---|
| Name | Type | Length | Valid Values and Format |
| Project | CHAR | 12 | *RFP - the custom field value for all projects, tasks and/or subtasks impacted by the Application Code/RFP number defined in parameters AGP and RFP should be updated, as long as the project type of the project or task type of the task/subtask allow use of that field. unique ID - update only for a specific project, task or subtask |
| Task | DEC | 7 | Task Number - Leave as 0 if Custom Field is to be applied directly to the Project. |
| Subtask | DEC | 7 | Subtask Number - Leave as 0 if Custom Field is to be applied directly to the Project or Task. |
| Field Name | CHAR | 10 | The Name of the Field to add, update or remove for this Project/Task |
| Option | CHAR | 7 | *UPDADD - If a value already exists for the given field, it will be updated with the field provided. Otherwise, the value will be added for the field. *ADD - If a value is already defined for the field, the existing value will be retained. *REMOVE - Remove any exiting value from the Field for the given Project/Task. If a field value doesn't exist, execution will be ignored. |
| Alphanumeric Value | CHAR | 160 | The value to apply for the given field in character format. The maximum length of an alphanumeric field is 160 characters or the defined length of the field, whichever is shorter. Use this for fields of type: String Checkbox (Y or N) DropDownList (the code value, not the description) URL |
| Numeric Value | DEC | 26,9 | The value to apply for the given field in decimal format. The maximum length of a numeric field before the decimal point is 15 digits. The maximum length after the decimal point is 9 digits. The actual maximum depends on the definition of the field. Use this for fields of type: Number Date (format YYYYMMDD) Time (format HHMMSS) |
| Application of RFP | CHAR | 6 | The application of the RFP that contains the Projects, Tasks and Subtasks that require an update to the field value. If PROJ = *RFP, this parameter is required. |
| RFP Number | DEC | 7 | The RFP (Request for Promotion) number that contains the Projects, Tasks and Subtasks that require an update to the field value. If PROJ = *RFP, this parameter is required. |
| Apply to RFP Projects | CHAR | 4 | *YES - MDCMS will attempt to update the value for the field for each project impacted by the RFP, even if development work is done against a task or subtask within the Project. *NO - Any Project level field will be ignored |
| Apply to RFP Tasks | CHAR | 4 | *YES - MDCMS will attempt to update the value for the field for each task impacted by the RFP, even if development work is done against a subtask within the Task. *NO - Any Task level field will be ignored |
| Apply to RFP Subtasks | CHAR | 4 | *YES - MDCMS will attempt to update the value for the field for each subtask impacted by the RFP. *NO - Any Subtask level field will be ignored |
| MDCMS Instance | CHAR | 5 | Specifies the MDCMS environment that should be used for the API. The ID correlates to the suffix of the MDCMS library name. Special values: *DFT - default instance (no suffix) *SAME - the current instance based on the library list |