The CreatorCon Call for Content is officially open! Get started here.

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?