Dashboard using multiple queries

[ypgpatel (Yash Patel)]

I have a dashboard that is using 2 baq’s. A tracker that has the project id and quote, and a summary section from the first query; a summary section from the second query. Both queries have a column project id. How exactly do I get the second section to link to the first one? So if I click on a line for a specific project id in the first query, only the information for that project id should display in the second query.

[NateS (Nate Schoonover)]

@ypgpatel

How exactly…

Not exactly sure, but try publish/subscribe. Select the column you want to publish from Dashboard Query Properties > Publish. Then In the other query, in the same properties window, look at the Filter tab. Just set your filter to the column you published.
Good luck!

[hkeric.wci (Haso Keric)]

There is also now a Parameters tab, so you could pass in Silent BAQ Parameters to your child BAQ and have it run even faster.

[NateS (Nate Schoonover)]

@hkeric.wci

run even faster.

Thats awesome! I don’t know how I missed this! Thanks!

[hkeric.wci (Haso Keric)]

It is available since 10.2.600

Dashboard Pass Silent Parameters to BAQ

A Feature asked for ages; never delivered by Epicor yet it seems like a simple one… In a Dashboard allow Passing in Parameters to the BAQ Before Execution so we can stop running wide-open BAQs which hammer the server because Post-Filtering is not the answer. Example: Click on Parent Grid and have the Child Re-Run BAQ with specific Params. So if you are doing lets say CTEs Recursive or Sub-Queries and SUM() and MAX() you will get “accurate” number with little effort because each time the BAQ wil…

[utaylor (Utah Taylor)]

I can’t wait to use this.