GlideRecord.addQuery

[georgechen]

Hey folks

Anyone familiar with GlideRecord.addQuery?   Trying to write query with GlideRecord.addQuery(),

Last login time relative before 90 days ago:     gsUsers.addQuery('RELATIVELT','RELATIVELT','@dayofweek@ago@90');

or Last login time is empty:                                                         gsUsers.addOrCondition('last_login_time','');

Created relative before 90 days ago:                           gsUsers.addQuery('sys_created_on','RELATIVELT','@dayofweek@ago@90

gsUser.addEncodedQuery is more easy to use (I simply copy the query from a list view) and works perfect, however, for programmer readability I wonder how each filter can be correctly translated into gsUsers.addQuery('?','???') on date manipulates (before/after 90/3 days/months ago)

Any feedback would be greatly appreciated.

Kind regards,

[guhann · Accepted solution]

Hi George,

Try like this,

var gsUsers = new GlideRecord('sys_user');

gsUsers.addQuery('sys_created_on','<','javascript:gs.daysAgo(90)');

var orQuery = gsUsers.addQuery('last_login_time','');

orQuery.addOrCondition('last_login_time','<','javascript:gs.daysAgo(90)');

gsUsers.query();

[georgechen]

Thanks Guhan, this really helps !

[guhann]

You are welcome!

Could you please close this thread by marking it as answered..