Hello...
The current Work Log report is does not have some of the fields that we would like to have on the report. Is it possible someone can help me modify spS_WorkLog_WithNames stored procedure. I would like to add field from
DefectCustomFields.Custom_121 if ItemType = Defect
FeatureCustom_Fields.Custom_123 if ItemType = Feature
TaskCustomFields.Custom_128 if if ItemType = Task
It will join _CustomFields table _ID field to parent tables _ID field.
Example: TaskCustomFields.Task_ID = Tasks.Task_ID and Tasks.TaskID = WorkLog.Item_ID where ItemTypeID = 2
Any help is appreciated.
Thanks
Divyesh