Editable grid getRows() method returns always an empty collection

Like (0) Share

Report

Posted on 31 Aug 2022 16:37:03 by Osman Esen

I have following Editable grid with 3 records:

Using following code in JS, the getRows() always returns an empty collection.
But when I use the getTotalRecordCount() method instead, it is able to return the value "3".

It is unclear for me, why getRows() always return an empty collection ?.

The code:
function loadValue(executionContext) {

var formContext = executionContext.getFormContext();
var gridContext = formContext.getControl("nf_royalty_template_grid");
var gridOC = gridContext.getGrid();
var totalGridRows = gridOC.getTotalRecordCount();
var allRows = gridOC.getRows();

allRows.forEach(function (row, i) {
var gridColumns = row.data.entity.attributes;
gridColumns.forEach(function (column, j) {
var atrName = column.getName();
var atrValue = column.getValue();
console.log(atrName+":"+atrValue);
});

});

}

Debugging in JS

Categories:

General Questions

All responses (4)

Answers (0)

SBax 1,348 on 31 Aug 2022 at 18:01:35

Like (0)

Report

Re: Editable grid getRows() method returns always an empty collection

By the sounds of it, your get rows is trying to get them before the refresh is complete.

I would suggest converting your refresh function to return a promise then use a . then to get your rows post refresh completing
Osman Esen 8 on 31 Aug 2022 at 17:55:07

Like (0)

Report

Re: Editable grid getRows() method returns always an empty collection

@SBax that was the issue. I have commented out the refresh() in form onLoad and it is now able to fetch all 3 records:

This seems like a bug
Osman Esen 8 on 31 Aug 2022 at 17:38:02

Like (0)

Report

Re: Editable grid getRows() method returns always an empty collection

Thanks for the reply @SBax . It stills returns an empty array:
I have done a refresh() to the grid when loading the form, and invoking this piece of code "loadValue()" method when I manually change a field. I read somewhere that there might be a bug with getRows() method since it will always return an empty array if the refresh() method has been invoked on it.
SBax 1,348 on 31 Aug 2022 at 17:06:42

Like (0)

Report

Re: Editable grid getRows() method returns always an empty collection

Can you replace the bold text with

var allRows = gridContext.getGrid().getRows()

I'd like to see what is held in allRows if we do it this way