none
Where the history of the timesheet comments are saving ? RRS feed

All replies

  • The comment is stored in the reporting database; you can run a report and filter it by time period. this query shows where to find the comment

    SELECT 
           [TimesheetLineUID]
          ,[TimesheetUID]
          ,[ProjectNameUID]
          ,[TaskNameUID]
          ,[AssignmentUID]
          ,[ClassUID]
          ,[ValidationType]
          ,[Comment]   --<< here is your comment --
          ,[ApproverResourceNameUID]
          ,[TimesheetLineStatus]
          ,[CreatedDate]
          ,[ModifiedDate]
          ,[LastSavedWork]
          ,[TaskHierarchy]
      FROM [PWA_Reporting].[dbo].[MSP_TimesheetLine_OlapView]


    Ali Al . Consultant & IT Manager.
    epma
    FB TW IN

    • Proposed as answer by Kashif Nizam Wednesday, January 30, 2013 7:03 PM
    Monday, January 28, 2013 7:03 PM