Delete multiple records from On-Device data source in SAP Build Apps

[sudarshan005]

Hello All,

I want to delete multiple records from my on-device data source by a button click but I'm unable to achieve it. I've tired the looping logic as well as the creating a trigger event in Global canvas and using it in component tap. But nothing is working as it should be.

Is there any way to acheive this.

Best Regards,

Sudarshan Pattanayak

[merituulimelkko]

By "nothing is working as it should be", what do you mean? What happens with the looping logic for example? Do you get an error when trying to delete, or is it deleting one record but not more? If you're getting an error, please let us know. If it is deleting only one record or not enough records, add debug logs into the looping logic that it is incrementing correctly the page variable you are using to loop with.

[sudarshan005]

Thanks for quick response

I've followed a blog related to the deletion of multiple records but the thing is something is not understandable on that blog.

And as per your question the looping of the data records is not working as it should be and at the end I've added 2 toast one for success and the other for failure the outcome is success but when I reload the application the data are still present.

[sudarshan005]

And at the button click it is deleting only one record and I think there is some issue in the looping logic as the deletion is happening but only one record at a time

[Dan_Wroblewski · Accepted solution]

I would delete them without having to retrieve them each time. Basically the same way but using the data variable to manage the loop.

The if condition is (or you can reverse things and remove the NOT):

NOT(IS_EMPTY(data.Test1))

The delete record selects the record with a formula:

data.Test1[0].id

And the set variable record collection is:

REMOVE_ITEMS_AT(data.Test1, 0)

I can't really debug what you have without seeing the configuration.

[sudarshan005 · Accepted solution]

Thank you daniel.wroblewski,

The looping logic was accurate and helped me a lot.