Hi All,
I am still experiencing the BAQ Update error from the start of this post. Epicor tech support gave up on it without any help.
You can reproduce the error yourself with these steps:
Create two uBAQs called test1 and test2. Each query contains only a single calculated bit field set to false. This is a simple query with syntax:
select
(0) as [Calculated_Checkbox1]
The update box should be checked for both BAQs, and the checkboxes should be the updatable fields.
I turned off BPM Update and am using Advanced BPM update only. You do not need to setup custom actions or directives for this example.
Create a dashboard called TestDash.
Insert both uBAQs as grid views.
Set both views to updatable, and prompt for update on the checkboxes.
Save and compile your dashboard.
Open the compiled dashboard.
Refresh all queries. There should be one row in each with a single checkbox.
Click a checkbox in one query.
Then try to click a checkbox (or anywhere at all) in the other query.
Observe error.
I think I need steps to bypass the BAQUpdate action when switching between views, after selecting a row (or rows) to update, but before processing custom actions to utilize the updated rows.
Any help or nudge in the right direction would be greatly appreciated!
Thanks!
Nate
This is a big red flag and as I suspected it is the issue (at least with this example) when you set a UBAQ to advanced BPM you are REQUIRED to have a BPM enabled in the Update method for it to work correctly.
Even if that is not the exact problem in your original issue, the issue is that your UBAQ is throwing an error (of some sort) on update. You need to verify those UBAQs in the BAQ Designer first to figure out what the problem is.
PS: I did create 2 BAQS and followed your setup exactly TEST1 and TEST2 I only updated the one in the gif but the same principle applies.
Yes even if its just a blank code block with a comment on it. IT calls the Update method automatically when you do something so it needs to be there otherwise the BAQ will throw the error.