Hi All,
I am trying to get the number of records from table sc_req_item (records from last 30 days). I think I need to create this by Client Script and Script Include because when I will have number of records then I want to add some conditions to check what number of this records have field ABC with value true and then show the field in the form from another table, so I created Client Script and Script INclude like this to count the whole records from sc_req_item, but it doesn't work..:
Client Script:
function onLoad() {
var ajax = new GlideAjax('calculateRITM');
ajax.addParam('sysparm_name', 'getCount');
ajax.getXML(IncCount);
function IncCount(response){
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
}
}
Script Include:
var calculateRITM = Class.create();
calculateRITM.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getCount: function() {
var gr = new GlideRecord('sc_req_item');
gr.addEncodedQuery('sys_created_onONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()');
gr.query();
var answer = '';
while (gr.next()) {
answer = gr.getRowCount();
}
return answer;
},
type: 'calculateRITM'
});
What is wrong?
Thanks in advance for help
