Delete Multiple rows from a list

[PaulAmmoun]

Hi,
I have a list (that might be synced or no) that contains a bunch of records.
I want to delete all the records matching certain criteria.
It's been a week I am stuck :(

I tried the following code with no luck


var lObj = {dialog.object}.getControl('lstinvoices');
mLenght = lObj._data.length ;
var ii = 0;
var interval = setInterval(function(){
mBasketData = lObj._data[ii].basketid ;
if(mBasketData == mBasketId){
lObj.setValue(ii) ;
{dialog.object}.setValue('LSTBASKETDET',ii)
lObj.deleteRow() ;
}

ii++;
if(ii == mLenght) clearInterval(interval);
}, 1000);


It seems the set value is not working, another issue with the logic, once I remove a row, then the index of the existing items will change..


Thank you in advance for any input

Paul

[Jay Talbott]

Paul,
I would approach this a bit differently. I just tried this using a static list made up of sample data using the name and addresses that come with the sample data.

Using that data, I used this code on a button to remove the people from NY on this list.

var lObj = {Dialog.object}.getControl('list1');
var _data = lObj._data;
var len = _data.length;
var _d = [];
debugger;
for (i=0;i<len;i++){
if (_data[i].State == 'NY'){
_d.push(i);
}
}
lObj.removeRows(_d);

This creates an array _d and removes those lines within the array. Remember the array and the list line numbers are zero based. So, for your situation, I suspect it would be something like this:

var lObj = {Dialog.object}.getControl('lstinvoices');
var _data = lObj._data;
var len = _data.length;
var _d = [];
debugger;
for (i=0;i<len;i++){
if(_d[i].mBasketData == _d[i].mBasketId){
_d.push(i);
}
}
lObj.removeRows(_d);

I'm not sure about the if(mBasketData == mBasketId) part. If you need further help, let us know.

Jay

[PaulAmmoun]

Hi Jay,
Thank you for the answer.
I forgot to specify that the list has a detail view.
I did try the removeRows method, but it did not sync the data back to the server.
it is a disconnected app. so the row might be synced back to the server or might be just dirty.
When I tried the removeRows method, it did actually remove it from the list but in case the row was saved back to the table, it did stay in the table.

Thank you again for any additional help.

[Jay Talbott]

So you want to get the ids from the list, put them into the array, and send the array to an Xbasic AJAX callback and delete the rows from the server, correct?
I don't have time right now, but will give you the code for this later. What is the name of the ID field in the list?

Jay

[PaulAmmoun]

Hi Jay,
Thanks a lot for your help, I really appreciate it.
I got the code to run at last...
an AJAX callback does not work, since I don't if the data in the list are synced or no... I need to mark the record as deleted so it gets deleted when it is synced back.
This is the code that worked for me, it needs some cleanup and more in-depth testing.

Thank you again for the answer and help..



mBasketId={dialog.object}.getValue('list::lstinvoices::basketid');

var lObj = {dialog.object}.getControl('lstinvoices');
mLenght = lObj._data.length
var i;
i=0 ;
var arr1 = [] ;
for (i = 0; i < mLenght; i++) {
arr1.push(i);
}
alert(arr1);
var ii = mLenght-1;;
var interval = setInterval(function(){
mValue = lObj._values[ii] ;
mBasketData = lObj._data[ii].basketid ;

if(mBasketData == mBasketId){

i1=Number(ii);
lObj.setValue(mValue) ;

var opts = {};
opts.prompt = false;
lObj.deleteRow(opts) ;
mits={dialog.object}.getValue('list::LSTBASKETDET::qty');
}

ii--;
if(ii <= -1) clearInterval(interval);
}, 3000);