none
Find Timesheet Trx comments RRS feed

  • Question

  • Hi I am trying to find the transaction comments but could find.

    The query I am using is:

    select

    TS_ACTION_COMMENT from[pub].[MSP_TIMESHEET_ACTIONS]

    but the problem is comments are not similar to what we have in the trsansction comments column on the manage timesheet page.

    Tuesday, September 22, 2015 4:38 PM

Answers

  • The following worked

    Select TS_ACTION_COMMENT from [pub].[MSP_TIMESHEET_ACTIONS] where

    TS_UID in (Select TimesheetUID from MSP_Timesheet_OlapView TS INNER JOIN MSP_TimesheetPeriod_OlapView TP

     on TS.PeriodUID = tp.PeriodUID

     where year(TP.[StartDate]) = @RptYear and

      month(TP.[StartDate]) = @RptMonth

      Order by TS_ACTION_DATE Desc

    • Marked as answer by Nav Sahi Tuesday, September 22, 2015 7:17 PM
    Tuesday, September 22, 2015 7:17 PM