How to insert a condition in a User Criteria from two different tables

pjftenorio
Tera Expert
(function isAllowed() {
    var gr = new GlideRecord('sys_user');
    gr.addQuery('sys_id', 'sysparm_user');
    gr.addQuery('active', 'true');
    gr.addQuery('sso_source', gs.getProperty('*SOME PROPERTY*'));
    gr.query();
    if (gr.hasNext()) {
        var usergr = new GlideRecord('sys_user_has_role');
        usergr.addQuery('state', 'active');
        usergr.addQuery('role', '*ROLES*'); 
        usergr.query();
        return usergr.next();
    }
})();

How do I use the gliderecord for two different table?

5 REPLIES 5

yes