M3 H5 script: How to get Row Index/ number of a grid on selection of a row or how to loop through th

Legacy Contributor

Hi,

Is there a possibility to get the row index/ number on selection of a row through H5 scripting.

I know there is a script H5SampleSelectionChanged but its pointing towards Row number 1 with zero index and I have also written the same code in my H5 script.

But everytime that may not be the case user can select any row or more than one row

Can we loop through on selection of the rows if user selects the three rows.

I have a scenario where on ARS112/F only Payer PYNO is at the header level.

Some of the other details i need to get from Grid/List and I am passing the values to the exportmi.

Has anybody worked on such scenario.

Below is the exportmi query where I am passing the inputs and the screenshot of ARS112/ F

"ESCUNO, ESYEA4, ESINYR from FSLEDG where ESCONO = '"+this.Company +"' and ESDIVI = '"+this.Division +"'  and ESPYNO = '"+this.Payer +"' and ESCINO = '"+this.InvoiceNo +"'"

Legacy Contributor

Ah, got it

what you can try is, the SelectedItem() returns the aray of integers. in that case we can try a loop and get the gird data. Check if the below sample helps

var grid = this.controller.GetGrid(); // assigned directly you may use alternate ways for this
var data = grid.getData().getItems();

let selected = ListControl.ListView.SelectedItem();

for (var i = 0; i < selected.length; i++) {
       var selectedIndex = selected[i]; // will get the index of the selected row here

        // let say you need column like C4, C5, C7 can try like below
        var payer = data[selectedIndex].C4;
        var item = data[selectedIndex].C5;

        // call the api using the above data.
}