News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... I want to fetch the de...

Finance | Project Operations, Human Resources, ...

Suggested answer

I want to fetch the details of those records that have not filled timesheet.

(0) Share

Report

Report

Posted on by rsingh62

53

I want to fetch the details of those records that have not filled timesheet. How can I fetch details of timesheet approver ?

Thanks and Regards

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mohit Rampal 12,552 Super User 2024 Season 1 on at

Like (0)

Report

RE: I want to fetch the details of those records that have not filled timesheet.

Hi, To find timesheet approver you have to go to workflow history and find approver.

Check this thread

community.dynamics.com/.../i-need-to-find-information-about-timesheet-approver-from-database
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: I want to fetch the details of those records that have not filled timesheet.

Hi rsingh,

You can Join HcmWorker >> ResourceView >>TsTimesheetTable(Not exists join).

Refer to the below blog for getting the details of timesheet approver.

http://daxingwitheshant.blogspot.com/2019/05/x-code-to-return-workflow-approver-name.html

Thanks,

Girish S.

Helpful resources

News and Announcements

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2

Martin Dráb 230,836 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans