哪里有时间表评论的历史记录？ [英] Where the history of the timesheet comments are saving ?

问题描述

我想知道时间表的历史记录在哪里 评论正在保存？

I wants to know where the history of the timesheet  comments are saving ?

推荐答案

评论存储在报告数据库中;您可以运行报告并按时间段过滤它。此查询显示在哪里可以找到评论

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]

这篇关于哪里有时间表评论的历史记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！