How to put a refqual condition for field based on role user having?

Ramu6
Tera Contributor

Hi All,

 

Actually on the case I have created one reference field which refers external users table, so here i need to put a reference qualifier condition like basically case having project field, its refers to  project table in that we having related list called "Members", in that project member we have field called "Role ", so i need to fetch the users list in my reference field, that reference field restricted to show only the particular  project members with role selected as " Technical"?

 

Please help me complete this 

Thanks

Ram

1 REPLY 1

Ramu6
Tera Contributor

Hi All 

I have tried this through script include but its not working

getProjectMembers: function(projectSysId) {
        var members = [];
    

        var Members = new GlideRecord('sn_customerservice_m2m_members');
        Members.addQuery('u_sn_customerservice_project', projectSysId.u_project);
        Members.addEncodedQuery('u_roleLIKEtechanical');
        
        Members.query();

        if (Members.next()) {
           
            members.push(Members.u_sn_customerservice_user.toString());
        }
        return'sys_idIN' + members.join(',');
    },

    type: 'PP_get_project_members'
};
 
Javacript condition 
javascript: new sn_customerservice.project_members.getProjectMembers(current)
 

Please help me to complete this

 

Thanks

Ram