Delete Column on a Custom DataView

Kinetic ERP
1

Hi Everyone,

I’m working on adding a column to a custom Dataview in Application Studio. This column will be used to delete multiple rows at the same time.

To implement this, I created a UBAQ with a BPM on the Update trigger. The BPM loops through all records where the column has been checked and deletes all the rows where the column is marked. This works correctly in the BAQ tool, but not in Application Studio.

In Application Studio, I created a custom button. On the button’s onclick event, I added a data-commit with my Dataview as a parameter. However, it doesn’t seem to trigger the BPM at all, even though I added a blexception at the start of the BPM, and it never gets triggered.

Does anyone know if it’s still possible to accomplish something like this? Any hints or suggestions would be greatly appreciated.

2

Not sure what you mean by this. You have to use the erp baq or kinetic baq widget to execute the baq in update mode.

3

First thank you for your time.
I meant this :

image
image360×205 5.32 KB

Are you talking about the tool to create the BAQ ? If you do, I used the classic version.

4

If your button click event is meant to execute the baq then that isn’t the right widget. You need to use the kinetic-baq widget to execute the baq.

5

My BAQ is link to a Dataview, the dataview get refresh on the HelpDeskCase.GetByID. I just want the button to save the dataview and use the BPM.

6

If your BPM is on the UBAQ then you have to execute the UBAQ for the directive to fire?

7

But the UBAQ is not execute when I create a dataview that call this BAQ ?

8

No, you have to use the kinetic-baq widget if you want the baq to execute.

2 Likes
9

Thank you!
It’s now working. I was under the impression that the Dataview would pull all the information from the BAQ, similar to how the BPM updates rows or handles other tasks.

If I understand correctly, the Dataview commit should only be used when it’s linked to a BO ?

1 Like
10

Glad its working! Sorry I don’t know the answer to your question, I have never once needed to use dataview commit for anything :woman_shrugging:

2 Likes