Kinetic BAQ widget issues with Subquery Criteria

CzarnezkiS · October 9, 2025, 6:38pm

Hello,

I am trying to leverage code from an existing Classic Epicor dashboard for use in a new Kinetic Dashboard made in Application Studio.

In essence, I am trying to figure out how to get Kinetic-BAQ widget parameters to work with the BAQ subquery criteria.

In the classic dashboard there is a grid that is being populated based on several fields that are entered above in text boxes and sent via button to an updatable BAQ for the data. The BAQ has a list of subquery criteria for the searching to keep the ability to save in the same query.

In the new Kinetic Dashboard, it has been set up to somewhat resemble the classic version. Currently only the Part number field is set up for testing purposes. When a valid part number is added and the search button is pressed, the necessary columns in the grid appear but no data is populated. This is confirmed with a check of the network calls in the dev tools when the return statement only has the execution time and number of rows returned.

This is where I am stuck, I cannot seem to figure out how to get the BAQ to return all of the rows that should be there. I suspect it may be because of the subquery criteria in the BAQ which I am not used to using. I also haven’t used the Kinetic-BAQ widget before since my business just upgraded Epicor from Kinetic_2023.1 to Kinetic_2025.1. Both of these combined are what I suspect are causing the issue since the Kinetic-BAQ widget’s parameter fields are not working properly with BAQ subquery criteria. From what I know the kinetic-BAQ parameters only work when they are used as table criteria and not subquery criteria.

Any assistance is appreciated,

Spencer

Here is the Classic Dashboard:

Here is the Kinetic Dashboard:

Here is the Kinetic-BAQ Widget:

Here are the SubQuery Criteria:

cory.davis · October 9, 2025, 8:28pm

My guess is that it doesn’t like how you have your parameters formatted in the calling event. The baq is running it’s just getting 0 results. Can you turn on the Dev Tools (F12) and look at that execute BAQ call on the network tab? It should show you what is being sent in the payload and I bet it won’t be what you expect. As a single reference point. I have a baq where ProjectID is a parameter and I have it setup like this in the event.

CzarnezkiS · October 20, 2025, 9:30pm

Sorry for the delay. The image below is what I am getting when I call the event and this is definitely what I was expecting to be there. What I am not sure on is if the format that it is being transmitted is proper.

jbooker · October 21, 2025, 2:42am

Perhaps it’s not skipping criteria having empty param values (?)

cory.davis · October 21, 2025, 12:27pm

If you look at the Preview and Response tabs from your screenshot do you see any results being returned? There is a chance it’s running the BAQ successfully and just not feeding it into the dataview for your grid.

CzarnezkiS · October 21, 2025, 1:32pm

The BAQ is running successfully but the results are always the same as shown in this picture. I think what you are saying is correct, but I am unsure on how to address this. We just upgraded from 2023.1 to 2025.1.5, so is there some sort of difference between the old erp-baq widget and the new kinetic-baq widget with passing data?