getRowCount not working in my BR?

Ashirav · ‎11-18-2019

Hi,

I want to display a message if the list view is blank for a table, but my message shows even if the table is not blank because getRowCount is giving the wrong result.

For this I have written a before-query BR:-

(function executeRule(current, previous /*null when async*/) {

var index = gs.action.getGlideURI().toString().indexOf('kb_knowledge_list'); //It checks for list view, i.e. "_list" is there in UR L if the List view appears

var count = current.getRowCount();
gs.addInfoMessage(count);
if(index != -1 && count == 0)
{
var c='No matches found for the search item';
gs.addInfoMessage(c);

}
else
{}

})(current, previous);

When the table is not blank, the value of "count" is still 0, and if the table is blank, the count is still 0.

Please help.

Alberto Consonn · ‎11-18-2019

This function doesn't work with current, so simply define a GlideRecord to kb_knowledge table adding the query as per your need:

var gr = new GlideRecord('kb_knowledge');
gr.addQuery(<add your condition>);
gr.query();
var count = gr.getRowCount());

View solution in original post

Ashirav · ‎11-18-2019

The correct answer is in green right? I am not able to get the green mark so I was not aware the correct answer is being updated. I am trying to click the "Mark as correct" but it is not turning green, not in any of answers.

Harsh Vardhan · ‎11-18-2019

you can see "Correct answer" on all reply. so select which one has solved your query. let me know if you need further help on this thread.