user manager certification managers last date is todaty

[lakshman]

Hi team,

The scenario involves the user manager's certification managers, with the final date being today. The objective is to assign a different manager based on the condition that the end date equals the current date. I have attempted the following query: "u.username like 'Ram_km' AND enddate = curdate" and then set "u.username like 'abc'," but it has not yielded the desired results. The SQL command I used is as follows: UPDATE users SET username = 'abc' WHERE username = 'Ram_km' AND ENDDATE = CURDATE();

[NM]

Hi @lakshman where have you added the query .. get certifier via query?

[lakshman]

the qury is wrong but how to do that scenario managers last date is today ?

[rushikeshvartak · Accepted solution]

You need to configure user update rule and use action as launch certification 

[mbh_it2 · Accepted solution]

@lakshman Try sth like below

(u.username like 'Ram_km' OR u.username like 'abc') AND u.enddate<=curdate()