How to get record values from Glide Query?

sujan0119 · ‎09-20-2023

Hi All,

I have written the below script, however the highlighted line seems not working. Can anyone please help me out on this ?

var unmatchedRecords = 0;
var recordNumber = "";

var AccessRequest = new GlideRecord('x_cls_clear_skye_i_group_operations');
AccessRequest.addEncodedQuery("active=false^roleISNOTEMPTY^u_environment_displayLIKEIPM^state=3^request_ref=9bfaa610db1e230001559447db961954^profile.identity.status=1");
AccessRequest.query();
gs.warn('CLS - Create Role Memberships for IPM - Subhrajit1:' + AccessRequest.getRowCount());
var recordsToCreate = 0;
while (AccessRequest.next()) {
     var ro = AccessRequest.role;
     var pro = AccessRequest.profile;
     var endDate = AccessRequest.end_date;
     var emailID = AccessRequest.profile.email_address;

     var ActiveProfile = new GlideRecord('x_cls_clear_skye_i_profile');
     ActiveProfile.addQuery('status', '1');
     ActiveProfile.addQuery('email_address', emailID);
     ActiveProfile.query();
gs.warn('CLS - Create Role Memberships for IPM - Subhrajit2:' + ActiveProfile.getRowCount());
     while (ActiveProfile.next()) {

var getActiveProfile = ActiveProfile.sys_id;

         var RoleMembershipCheck = new GlideRecord('x_cls_clear_skye_i_m2m_accounts_roles');
         RoleMembershipCheck.addQuery("roles", ro);
         RoleMembershipCheck.addQuery("profile", pro);
         RoleMembershipCheck.query();

         if (!RoleMembershipCheck.next()) {
             recordsToCreate++;
             unmatchedRecords++;
             recordNumber = AccessRequest.number + "," + recordNumber;
var RoleMembershipCreate = new GlideRecord('x_cls_clear_skye_i_m2m_accounts_roles');
RoleMembershipCreate.initialize();
RoleMembershipCreate.roles = ro;
RoleMembershipCreate.profile = getActiveProfile;
RoleMembershipCreate.u_end_date = endDate;
RoleMembershipCreate.insert();
         }
     }
}

gs.warn('CLS - Create Role Memberships for IPM - Subhrajit Unmatched Record Number: ' + recordNumber);
gs.warn('CLS - Create Role Memberships for IPM - Total records to be created: ' + recordsToCreate);
gs.warn('CLS - Create Role Memberships for IPM - Subhrajit Total Unmatched Records: ' + unmatchedRecords);

maroon_byte · ‎09-20-2023

Try adding toString() to all variable declaration where you are assigning query record value; such as:

var getActiveProfile = ActiveProfile.sys_id.toString();

var ro = AccessRequest.role;
var pro = AccessRequest.profile;
var endDate = AccessRequest.end_date;

var emailID = AccessRequest.profile.email_address;

var getActiveProfile = ActiveProfile.sys_id;

Regards,

Sharad