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

 

The spS_WorkLog_WithNames stored procedure uses dynamic SQL so that it can do paging, and also has lots of parameters for filtering purposes.  You won't be able to take advantage of either the paging or the filtering inside a custom report, so I would recommend just writing a new stored procedure that was simpler and more geared towards the data you need.

---

Dan Suceava
http://www.axosoft.com