Announcements
No record found.
I want to show employee lookup that fetch only the terminated employee list.
*This post is locked for comments
you can join table like HCMWORKER, HcmEmployment, HcmEmploymentDetail and make filter on HcmEmploymentDetail).TransitionDate to get the list.
Thanks Amir.
Both hcmemployment and hcmeemployment details are valid date time stat e table so i have doubt how to join by AOT Query. By default hcmemployment validto is never (01-01-2155) so i need not never value to set query range.
how to lookup data for terminate employee in ax 2012, pls give me sql code.
Dear Amir Nazim
is there a way to get it in a report, which is built in
and why we need to write a query to get this report
Very strange
Yousaf
Human Resource --> Common --> inactive employees
will give you the list
there is no need to write any sql query
Regards
I think You can try to reuse the existing Form and initializing the "Termination Filter".
how to do that... which existing form and how to use it
Form - Hcmworkerlookup , You can duplicate the form or Call through code.\
set the filter on the init method
Hi Prabhukt,
Were you able to achieve this?
Thanks,
Subha
Hi Amir,
There is no data for 'Transition date' in detail table. shows blank for all records in the table. so what to do in this case..
Thanks
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 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
