Announcements
No record found.
I need to add this display method to get the last termination date (end date) of this worker but this select statement get last line I updated on it ,
so what is wrong in this select ?
it display date 3/8/3018 but I need to display 16/1/2019 How can I fix this in select ?
Hi Menna,
The HcmEmployment table is also enabled for date effectiveness. You can try to add the ValidTimeState command also on line 48.
without maxof (validTo) ?
I got this error how can I write this ?
Hi menna,
Remove validTimeState keyword. It will be enough to add one validTimeState and that to at the start of select statement. It applies for all the tables in the joins.
Thanks,
Girish S.
Hi Menna, There is already standard method for it in HcmWorkerHelper class. You can get TransitionDate from this HcmEmployment table.
You can do one thing. There will be a query named HcmWorkerListPage_PastWorkers - Use that query to create a view - You can use that view to get all the details of past worker and you can use it in future purpose also.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 282 Super User 2026 Season 2
Aayush Tiwari 219
Subra 211 Super User 2026 Season 2