AnsweredAssumed Answered

Latest Timesheet using SQL query

Question asked by Pankaj_Navlekar on Oct 29, 2013
Latest reply on Dec 2, 2013 by Pankaj_Navlekar

Hi,

I'm having trouble finding the latest timesheet through an SQL query. The prVersion column of prTimesheet is not reliable since not always does the latest timesheet have the higest version number. Also if I use prAdjustment column, there are timesheets that were never adjusted so they have pradjustment=0 but others who have been adjusted once have pradjustment=1

Please suggest. Thanks.

Outcomes