In the Modern Timesheets, when a user scrolls the 'My Timesheet' time period carousel, timesheet ids will automatically be created by design.
Is there a way to find out more about which timesheets were recently created?
Release: All
The following queries can be used to find out
--Recently created timesheets
select srm_resources.id, srm_resources.unique_name, srm_resources.first_name, srm_resources.last_name,
prtimesheet.pruid, prtimesheet.prid, prtimeperiod.prstart, prtimeperiod.prfinish, prtimesheet.prstatus,
prtimesheet.prversion, prtimesheet.prmodtime
from prtimesheet, srm_resources, prtimeperiod
where prtimesheet.prresourceid = srm_resources.id
and prtimeperiod.prid = prtimesheet.prtimeperiodid
and prtimesheet.prstatus = 0
and prtimesheet.prversion = 1
order by prtimesheet.prmodtime desc
Refer to following article to find out details of the timesheet, refer to: Query Timesheets