How to get row count In GlideRecord

Pratiksha Lang1
Kilo Sage

Hi, How to get Row count in the below code, It is not taking the addquery of result score = 'NOT MET'. 

 

var myUniqueRecords = []; 
var gaDupCheck1 = new GlideAggregate('x_amspi_smdrs_app_ola_score');
gaDupCheck1.addQuery('sys_created_onONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()');
gaDupCheck1.addAggregate('COUNT');
gaDupCheck1.groupBy('ola_name');
gaDupCheck1.groupBy('site');
gaDupCheck1.groupBy('frequency');
gaDupCheck1.groupBy('role');
gaDupCheck1.groupBy('ola_type');
gaDupCheck1.groupBy('result_score');
gaDupCheck1.groupBy('ola_formula_score');
gaDupCheck1.addNotNullQuery('ola_name');
gaDupCheck1.addNotNullQuery('site');
gaDupCheck1.addNotNullQuery('frequency');
gaDupCheck1.addNotNullQuery('role');
gaDupCheck1.addNotNullQuery('ola_type');
gaDupCheck1.addNotNullQuery('result_score');
gaDupCheck1.addNotNullQuery('ola_formula_score');
//gaDupCheck1.addHaving('COUNT', '>', 0);
gaDupCheck1.query(); 

while (gaDupCheck1.next()) { 
var myObject = {};
myObject["ola_name"] = gaDupCheck1.getValue("ola_name");
myObject["site"] = gaDupCheck1.getValue("site");
myObject["frequency"] = gaDupCheck1.getValue("frequency");
myObject["role"] = gaDupCheck1.getValue("role");
myObject["ola_type"] = gaDupCheck1.getValue("ola_type");
myObject["result_score"] = gaDupCheck1.getValue("result_score");
myObject["ola_formula_score"] = gaDupCheck1.getValue("ola_formula_score");
myObject["result_score"] = "NOT MET";
myUniqueRecords.push(myObject);
  //gs.info(gaDupCheck1.getValue("ola_name") + "###"  +  gaDupCheck1.getValue("site"));
} gs.info(myUniqueRecords.length +  " : " +JSON.stringify(myUniqueRecords, null , 6));
for(var i = 0 ; i < myUniqueRecords.length ; i++){
    var gr = new GlideRecord('x_amspi_smdrs_app_ola_score');
    gr.addQuery('ola_name', myUniqueRecords.ola_name);
    gr.addQuery('site', myUniqueRecords.site);
    gr.addQuery('frequency', myUniqueRecords.frequency);
    gr.addQuery('role', myUniqueRecords.role);
    gr.addQuery('ola_type', myUniqueRecords.ola_type);
   gr.addQuery('result_score', myUniqueRecords.result_score);
    gr.addQuery('ola_formula_score', myUniqueRecords.ola_formula_score);
  gr.addQuery('result_score','NOT MET');
  gr.addQuery('ola_name', '!=', '');   
    gr.query();
var abc = gr.getRowCount;
gs.info('GRC1 : ' +abc);
}

var abc = gr.getRowCount;
gs.info('GRC1 : ' +abc);
  
if (gr.ola_formula_score == 'not_met_5') {
            if (grNotMetCount > 5) {
                gr.sub_score = 0;
                //gr.update();
            } else {
                gr.sub_score = 5;
                //gr.update();
            }

1 REPLY 1

Uncle Rob
Kilo Patron

if you're CERTAIN that addQuery isn't working I'd double and triple check the syntax
Is result_score the actual column name?  Is it a choice?  If it is, have you queried against the label instead of the display?