How to get row count In GlideRecord
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2023 03:48 AM
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();
}
}
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2023 04:44 AM
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?