User Criteria on catalog item

[Ram050670]

Hi All,

i am looking for a User criteria on catalog item that will be available for only Employee type Employee and active True. 
how to filter the users with employee type? 

usually we add groups and role on the available for but in this case we need Employee type Employee and active user.

[Ashir Waheed · Accepted solution]

Hi @Ram050670 

You will need to create a New User Criteria (user_criteria) record. 

1. In the Application navigator, Navigate to the Service Catalog->Catalog Definition->User Criteria
2. Check the Advanced check box.
3. 
4. Write the script as you return the desired filter user.
5. 
6. Save the Record.
7. Go to your catalog item in the Available for related list and Edit the list and enter the user criteria you created.
   

Script:

var user = new GlideRecord("sys_user");

//Change filter according to yours variable names

user.addEncodedQuery("employee_typeSTARTSWITHEmployee^active=true");

user.query();

while(user.next()){

answer=true;

}

This will resolve your requirement.

Regards,

Ashir Waheed

[Saloni Suthar]

Hi @Ram050670 ,

You have to write a script in the User Criteria:

checkCondition();

function checkCondition() {
var user = new GlideRecord('sys_user');
user.get(user_id);

if(user.<<custom field name> == 'value of the employee choice') {
return true;
}
return false;
}

If my response helped you, please mark it as correct or helpful.

[Ram050670]

i tried the above script but it didnt work for me, i used this  below script and it worked.

var EmpType = gs.getUser().getRecord().getDisplayValue('u_employee_type');

if (EmpType == 'Employee') {

    condition = true;

} else {

    condition = false;

}

[jcmings]

You'll need to call this function in your user criteria record:

new sn_hr_core.hr_Criteria().evaluateById("sys_id_of_HR_criteria_record", user_id);

 Then, create a record in the HR Criteria table. (You'll pass the sys_id of this HR Criteria record into the above function.) Within that HR Criteria record, create a HR Condition on the table HR Profile. Make sure your User column is set to User.

[Ashir Waheed · Accepted solution]

Hi @Ram050670 

You will need to create a New User Criteria (user_criteria) record. 

1. In the Application navigator, Navigate to the Service Catalog->Catalog Definition->User Criteria
2. Check the Advanced check box.
3. 
4. Write the script as you return the desired filter user.
5. 
6. Save the Record.
7. Go to your catalog item in the Available for related list and Edit the list and enter the user criteria you created.
   

Script:

var user = new GlideRecord("sys_user");

//Change filter according to yours variable names

user.addEncodedQuery("employee_typeSTARTSWITHEmployee^active=true");

user.query();

while(user.next()){

answer=true;

}

This will resolve your requirement.

Regards,

Ashir Waheed