EasyUI Forum

General Category => EasyUI for jQuery => Topic started by: arma on July 17, 2014, 07:16:53 PM



Title: Delete grid rows by specific column value critera
Post by: arma on July 17, 2014, 07:16:53 PM
Hi,

I would like to delete row which has specific column value, but my code below only can delete one row not many. How could i delete all the row with that matching criteria?
 
Let say i have a grid product, description, status. I want to delete all rows with status 1.

Code:
var rows = mygrid.datagrid('getRows');
var idx = null;
for (i = 0; i < rows.length; i++) {
  if (rows[i].status === '1') {
    idx = mygrid.datagrid('getRowIndex', rows[i]);
    mygrid.datagrid('deleteRow', idx);
  }
}

Thanks


Title: Re: Delete grid rows by specific column value critera
Post by: aswzen on July 17, 2014, 09:41:56 PM
var data = $('#table').datagrid('getData');

for (var i = 0; i <= data.length; i++){
    if(data[0].STATUS == 1){
        $('#table').datagrid('deleteRow',i)
    }
}



CMIIW


Title: Re: Delete grid rows by specific column value critera
Post by: arma on July 19, 2014, 04:55:25 AM
Hi Aswzen,

After reading your code so i don't need this line idx = mygrid.datagrid('getRowIndex', rows); simply pass i to the method deleteRow. It works good.

Thanks a lot.  ;D