Data not pulling from BAQ into Application

Kinetic ERP
1

Hi all,

I’ve been working on a BAQ to calculate the days between the StartDate & DueDate field within Project Entry. The BAQ works as it should when testing as it provides the accurate number. However, I am unable to get this to work within an Application.

My Display fields are:

image
image1120×187 10.2 KB

My Calculated field is:

image
image1095×107 3.37 KB

image

I then imported the BAQ into the ProjectTask application using the Wizard,

image
image1590×715 30.1 KB

I’ve connected all the BAQ fields to the Application fields within the relationships.

Lastly, I then applied the EpBinding to the text box as DateDelay.Calculated_DaysBetween

I’m not sure what I am missing, is anyone able to point me in the right direction to where the problem could be?

Thanks!
Gary

2

Hi Gary,
I have used these a few times and never did any mapping of relationships, so not sure if that is causing an issue.

Second, I typically use an event in Application Studio to call the BAQ and provide it with criteria. You can tell if a BAQ is running by running a trace on that window and going through the steps of what is supposed to kick off the BAQ. On the Network tab, there will be ExecuteBAQ and you can see what values you passed into the BAQ and the result.

Another way to see if your BAQ is populating the Dataview (DateDelay in this case) would be to open the screen in question, launch trace, and within the window, click into a text box, and press Ctrl+Alt+8 to start debugging mode and Ctrl+Alt+V to view all the dataviews. You can check if your dataview has any information in it. If the BAQ is launching correctly, you should, if it’s empty, you will need to go look where the BAQ is being launched and inspect the query data being inserted to the BAQ

1 Like
3

Hi Mackenzie,

This has been super helpful! I checked the event’s running when loading into the Project Entry and I was able to use this to pull the DateDelay BAQ. Thanks for the help on this!

2 Likes