Applying query on for Script Include

[SUser1234]

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 ;

[Anand Kumar P]

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

[SUser1234]

But how are we comparing to last login?

I mean not inactive 

[Anand Kumar P]

if you want active then add 

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

[SUser1234]

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