How to check a condition in addEncodedQuery()

[Ajith7]

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 · Accepted solution]

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
}

[Ajith7]

If I mention a group name in the condition then the notifications should not be send to the users who belongs to the group. The notifications has to be send to the others persons who are inactive. 

[Ajith7]

Thankyou Lukasz. You have resolved my issue.

[Ajith7]

What exactly I wanted is I want to send a notification to the user if he is inactive for 25 days. The following Two conditions I have to Check . 1. If the user has ITIL role. 2 . If user is a part of Test_Group1(my group) Then I should not send the notification to the user.

[Community Alums]

Hi Ajith,

Best way to trigger notification by EventQueue. Could you please share how you are trying to trigger the notification for better output?

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.

Thanks
Alok