Table Configuration

In case the user wants to display the list of users in the reference field from diff tables then below reference qualifier will be used

Reference qual: javascript:"sys_idIN"+ new sn_compliance.ORM_SOPServerUtility().sopOwnersList(); (Table sys_users)

sopOwnersList: function() {

         var userList = "";

        var sopowner = new GlideRecord("cmn_department");

        sopowner.addEncodedQuery("u_department_node_level=4^u_active=true");

        sopowner.query();

        while (sopowner.next()) {

            userList = userList + sopowner.dept_head + ",";

            //userArray.push(sopowner.dept_head.toString());

            //userArray.push(sopowner.business_unit.bu_head.toString());

            //userArray.push(sopowner.u_cxo.toString());

        }

         var sopownerbu = new GlideRecord("business_unit");

        sopownerbu.addEncodedQuery("u_active=true^name!=NULL");

        sopownerbu.query();

        while (sopownerbu.next()) {

            userList = userList + sopownerbu.u_business_unit_heads + ",";

            userList = userList + sopownerbu.u_cxos.toString() + ",";

         }

             return userList;

     },

###################################################################################