question Applying query on for Script Include in Developer forum

Applying query on for Script Include

SUser1234 — Fri, 03 Jan 2025 17:28:53 GMT

I want to apply the encoded or addQuery to script, The script is targeting the HRprofile table, ask is-

If Hr Profile has not been inactive from last 90 days before the employment start date.

Employment start date is a custom field on HR Profile table.

I tried using this query ;

Re: Applying query on for Script Include

Anand Kumar P — Fri, 03 Jan 2025 17:45:39 GMT

Hi @SUser1234 ,

Yes you have to use encoded query for this . Test it in Hr profile list view check valid records you are getting then use it in script.

grProfile.addEncodedQuery('employment_start_dateRELATIVELE@dayofweek@ago@90');

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand

Re: Applying query on for Script Include

SUser1234 — Fri, 03 Jan 2025 17:48:27 GMT

But how are we comparing to last login?

I mean not inactive

Re: Applying query on for Script Include

Anand Kumar P — Fri, 03 Jan 2025 18:41:11 GMT

if you want active then add

grProfile.addEncodedQuery('active=true^employment_start_dateRELATIVELE@dayofweek@ago@90');

Re: Applying query on for Script Include

SUser1234 — Fri, 03 Jan 2025 19:01:05 GMT

I am talking about if user is not inactive from last 90 days before the employment start date

Re: Applying query on for Script Include

ashishdevsingh — Fri, 03 Jan 2025 19:34:34 GMT

you can get last login time in user table to compare the date.

Re: Applying query on for Script Include

jaycoover — Sat, 04 Jan 2025 01:06:45 GMT

Please rephrase this - "I am talking about if user is not inactive from last 90 days before the employment start date"

Do you mean users that have started within that last 90 days?
Do you mean users that are currently active (hired), but were de-activated within the last 90 days? This would refer to the wait period after leaving a contingent worker position, before they can start again.
Something else?

It's not perfectly clear what you're asking.

Re: Applying query on for Script Include

jaycoover — Sat, 04 Jan 2025 01:48:18 GMT

Is something like this helpful?
employment_start_dateMORETHANemployment_end_date@day@before@90

Re: Applying query on for Script Include

Bert_c1 — Sat, 04 Jan 2025 15:01:54 GMT

Try a Database view linking sh_hr_core_profile to sys_user, and compare 'employment_start_date' to 'last_login_time.

set view fields as desired, I created the above in the 'Human Resources: Core' application scope.