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

Ajith7 · ‎07-14-2019

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.

Ankur Bawiskar · ‎07-14-2019

Hi Ajith,

system won't send email to a person who is inactive in sys_user table.

Is the above code not working which is shared?

what is the outcome from that code? to whom it is sending email

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ajith7 · ‎07-14-2019

Thankyou Ankur. My issue is resolved.

Lukasz Bojara · ‎07-12-2019

Hi Ajith,

Probably your entry point is sys_user table and the connection between user and group is in sys_user_grmember table. Try to query this table with this encoded query.

Table: sys_user_grmember

Example Query: user.last_loginRELATIVELT@dayofweek@ago@25^user.roles=admin^user.active=true^group.name!=Team Development Code Reviewers

Example somthing like this:

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 Reviewers');
gr.query();

while (gr.next()){
 gs.print(gr.user.user_name + " - roles: " + gr.user.roles + " last login: " + gr.user.last_login);
}

Hope this helped.

Best regards,
Łukasz

Ajith7 · ‎07-12-2019

The notification is not sending to the corresponding user.