Can hasRole() be used inside of a loop?

[a99920]

I am familiar with using it in reference to the current user using either g_user or gs but I am wanting to use it inside of an addQuery against my user table. Basically the goal is to walk through each user and determine if they have a role (and if they do we will execute a command). I am having issues using this against my variable I create however.

[venkatiyer1]

Hi Joe,

A quick question. If it has stopped getting duplicates that means the entries are going fine on the time card check table. So when you say still showing empty are these the old records that got inserted? If not,   then are you   not getting duplicates any more because there is a empty user value record in u time card check.

If no more values are getting inserted. Can you log after the while loop starts for user sys id to see what is happening here

gs.log(grUserRole.user.sys_id);

[venkatiyer1]

Also do check for the column name defined hope it is user in your u_time_card_check table.

[a99920]

I misspoke in my last reply so I deleted (but unfortunately you read and responded), I apologize for that. I am now getting the user field populated perfectly but I DO have duplicates.

[Kalaiarasan Pus]

Avoid duplicates

var grUserRole = new GlideAggregate('sys_user_has_role');

grUserRole.addQuery('role','ef0c18e2372231000ddf26877e41f1d0');

grUserRole.groupBy('user');

grUserRole.query();

while (grUserRole.next()) {

var tcp = new GlideRecord('u_time_card_check');

tcp.initialize();

tcp.user = grUserRole.user.sys_id;

tcp.insert();

}

[venkatiyer1]

that is great. So are you still getting duplicates. If yes, then write a business rule on time card to check on user. For sample you can look for business rules have name prevent duplicates. Also you need to remove the existing duplicates by going to that table and seeing for duplicates. If you have a lot of records then we may need to write a fix script and run it once.