Advanced User Criteria

[kaomamichou]

Dear All,

I've created a catalog item that provide managers the option to declare and create a new external login account.

There is a user criteria giving access to the cat item only to managers.

An evolution is requeried:

Managers want to allow their delegate to also declare and create a new external login account.

I've created the following 

User Criteria: Allow delegates

checkCondition();
function checkCondition(){

//get the identified user
var userGR = new GlideRecord('sys_user_delegate_list');
userGR.get(user_id);

//check if the user is declared as manager
var gr = new GlideRecord('sys_user');
gr.addQuery('delegate',userGR.getValue('sys_id') );
gr.addQuery('active', true);
gr.query();
if (gr.hasNext()) {
answer = true;
} else {
answer = false;
}

}

After test, it's not working and delegates can not access to the cat item.

Could some one help me,

Thank you in advance!

Kindly,

Michou.

[Ankur Bawiskar]

Hi,

error here; please correct below the table should be sys_user_delegate and not sys_user_delegate_list

var userGR = new GlideRecord('sys_user_delegate');

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

[kaomamichou]

Thanks a lot!

[kaomamichou]

Hi Ankur,

The delegate can now access to the form, thank you.

But, as you can see on the bellow pictures, the delegate can't perform the request:

1. Form accessible by the "Manager" 

 

2. Form accessible by "Delegate"

[Raghav Sharma24]

There is a typo in your table name.

Remove list from sys_user_delegate