Dashboard BAQ Parameter

Kinetic ERP
1

Hello, I feel like I have a pretty easy question but I can’t find the answer anywhere. I have a dashboard with a grid of sales orders at the top. Below I have a grid of PO items for the selected order in the top grid. The PO items grid is based on a BAQ with a parameter for sales order number (OrderNum). How do I pass the order number from the top grid to the parameter for the PO items grid? Do I use the ‘Rest Params’? I am not using any events up to this point because all of the grids are related and just use the BAQ where clause which works. This BAQ I created with a parameter to make it more efficient.

Thanks

image
image1920×1040 193 KB

1 Like
2

Hi Jim!

I’m not sure if you’re still working on this, but are your grids connected to dataviews?

3

Yes! sorry for the delay

4

I find it MUCH easier for simple BAQs to just get rid of the parameter.

Then in your PO Grid’s Provider Model, go into BAQ Options and just add a where clause.

So, in your case it would be something like:

YourBAQSONumColumn = '??{YourSOGridSONumColumn}'

In this case you’re not sending a “Parameter”, you’re just telling the system to run your BAQ query where SONum = ‘12345’

3 Likes