Application Studio. Strategy to delete a record

Kinetic ERP
1

Hello Again EpiUsers!

I am working on a delete operation for an application studio app. I need help on how to push the updated DataView to the server and update the database.

Right now, this is my setup. The user lands on the landing page selects a record.

image
image975Ă—429 81.4 KB

(1) I click the row-delete button. Ud20_test_create_05 gets deleted from the DataView. The resulting DataView is dirty (in red).

image
image975Ă—393 59 KB

image
image284Ă—170 20.4 KB

(2) I click the data-commit to un-dirty the view.

image
image975Ă—299 55.1 KB

image
image286Ă—177 21.5 KB

(3) How do I push the updated DataView to the database? This is what I tried, but I can still see ud20_test_create_05 record in the database.

image
image975Ă—509 66 KB

image
image613Ă—452 42.7 KB

This is the payload on the request.

image
image975Ă—314 83.4 KB

To summarize, manipulating the DataView is easy but I cannot get the changes to reflect in Kinetic. =/

Is my approach correct? Meaning updating the dataview and pushing the new dataview to the server.

Or should I use the BAQ service to get the object by ID and then push an Update with RowMod = “D” and delete that way?

Any help would be much appreciated.

2

I think you want an empty dataview, do a GetByID for the record you want to delete into that dataview. row-update RowMod = “D” then call .Update with the record.

3

I’ll try that. Back in a few.

4

The UD table BO’s have a DeleteByID method. That’s what I use.

You just need on onclick event of your button and call a Rest-Erp action (or Rest-Kinetic… or whatever they’re called these days).

image
image178Ă—165 2.04 KB

You just have to specify all 5 keys in the method parameters.

On Success, I run my BAQ again to refresh any BAQ driven dataview(s).

2 Likes
5

Unfortunately, I am using the BAQ Service. The underlying query is a BAQ that joins UD20/Part/Customer.

I don’t think the BAQ Rest Service has a DeleteByID.

6

But what data are you trying to delete? Part Data, Customer Data, or UD data?

For example, if you delete the row from UD20 and then re-run your BAQ, that record would no longer be there on UD20 and would therefor not get returned again by your BAQ results.

2 Likes
7

…Unless it’s a left join! I hadn’t thought about multiple tables, sounds like you’d want to provide/create your own BAQ .DeleteByID aBPM code with the logic you need in that setup.

1 Like
8

It’s a LEFT JOIN with UD20 as the LEFT table. Meaning if no UD20 record, that record would disappear in the BAQ.

9

This is a very good idea! The BAQ has UD20 as the central table. No UD20, then no record in the BAQ.

1 Like
10

This turned out to be the right answer!

1 Like
11

I used DeleteById to delete the UD20 record.