How to check a condition in addEncodedQuery()

Ajith7 · ‎07-12-2019

I want to send a notification to users who are inactive for 25 days and the role should be itil and the group should not be custom group(group name). I have checked the condition for role but I could not put a condition to check the group name in addEncodedQuery(). Can anyone resolve this issue.

gr.addEncodedQuery("roles=itil^active=true^last_login_timeRELATIVELE@dayofweek@ago@1");

I wanted to put a condition for group

eg:

group not equal to test_group.

Can anyone help me to put the correct condition

Lukasz Bojara · ‎07-12-2019

How are you using the result? If you want to use the user's sys_id remember that when you query the sys_user_grmember table then if you will use gr.sys_id it will give you the sys_id of a connection record so it will be not the User's sys id.

To use the user's sys_id you should do gr.user.sys_id

In overall if you need to access user fields when you query sys_user_grmember table you need to dot walk to this field.

e.g.

var gr = new GlideRecord('sys_user_grmember');
gr.addEncodedQuery('user.last_loginRELATIVELT@dayofweek@ago@25^user.roles=admin^user.active=true^group.name!=Team Development Code Reviewers1');
gr.query();

while (gr.next()){
 gs.print(gr.user.sys_id); // print the user's sys_id
}

View solution in original post

Kristoffer Mon1 · ‎07-14-2019

What was your solution?

Ajith7 · ‎07-15-2019

To use the user's sys_id you should do gr.user.sys_id

This is the solution. I was using gr.sys_id.