I am not getting correct answer through encoded query in glide record

[Murtaza Saify]

function onLoad() {

    var gr = new GlideRecord('cmdb_ci');

    gr.getEncodedQuery('cost>10000');

    gr.query();

    var str;

    var count=0;

    while (gr.next()) {

        str = str+ ' and  ' + gr.name;

        count++;

    }

    alert(str);

    alert(count);

}

Here is my code  whats wrong with it

[Community Alums]

Hi @Murtaza Saify 

Try addQuery instead of addEncodedQuery.

function onLoad() {

    var gr = new GlideRecord('cmdb_ci');
    gr.addQuery('cost', '>', '10000');
    gr.query();
    var str;
    var count=0;
    while (gr.next()) {
        str = str+ ' and  ' + gr.name;
        count++;
    }
    alert(str);
    alert(count);

}

[Sohail Khilji]

Try this :

Script include : getCount

getRecCount : function(){

var counts = [];

 var gr = new GlideRecord('cmdb_ci');
    gr.getEncodedQuery('cost>10000');
    gr.query();
    var str;
    var count=0;
    while (gr.next()) {
        count.push(str+ ' and  ' + gr.name);
        count++;
    }
  return counts.toString();
}

[Community Alums]

Hi @Murtaza Saify ,

Please try below code 

    var gr = new GlideRecord('cmdb_ci');
    gr.addEncodedQuery('cost>10000');
    gr.query();
    var name = [];
    var count = 0;
    while (gr.next()) {
        name.push(gr.name.toString());
        count++;
    }
    gs.print("name = " + name);
    gs.print("count = " + count);

Result 

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak