display method in past worker x++

(0) Share

Report

Posted on by Menna Allah Ahmed

163

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 ?

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 299,905 Super User 2025 Season 2 on at

Like (0)

Report

RE: display method in past worker x++

Hi Menna,

The HcmEmployment table is also enabled for date effectiveness. You can try to add the ValidTimeState command also on line 48.

Was this reply helpful? Yes No
Menna Allah Ahmed 163 on at

Like (0)

Report

RE: display method in past worker x++

without maxof (validTo) ?

Was this reply helpful? Yes No
Menna Allah Ahmed 163 on at

Like (0)

Report

RE: display method in past worker x++

I got this error how can I write this ?

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: display method in past worker x++

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: display method in past worker x++

Hi Menna, There is already standard method for it in HcmWorkerHelper class. You can get TransitionDate from this HcmEmployment table.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: display method in past worker x++

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.

Thanks,

Girish S.

Was this reply helpful? Yes No