Dashboard Pass Silent Parameters to BAQ


(Haso Keric) #1

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 will re-run with “params” and viola.

For More Reading:

Has anyone ever figured out how to call a BAQ from a Dashboard with BAQ Parameters (keep reading).

Now you can specify BAQ Params and once the user hits “Refresh” they will be prompted. But if you have Parameters and Dashboard filters, everytime they change a filter and hit refresh they will be re-prompted.

In addition it looks, ugly.

Instead of running a wide-open BAQ that runs for 3 minutes, is there a way to send the BAQ Parameters from the Filters instead (Avoiding the popup).

Further more I would love to see once the user clicks on a Head row, execute a child BAQ with params from the head-row… Let’s say the Details are PartTran records. Its crazy that we grab 1 million PartTran records and the user only wants to analyze 5 of them but by navigating and re-running BAQ Queries upon each click it would make things faster.

Basically:
Click on Head Row -> Run Details BAQ with Head Row Parameters. (Repeat as the user iterates through rows) [ON-Demand Data] so we can stop running BAQs wide-open or with a -2 years limit.

I have seen this question asked numerous times, and here I am asking it again. Likewise with BAQ Reports, it seems that the BAQ Report runs this wide-open long Query and then applies the FIlter instead of passing the filters as Parameters.

I am okay if anyone has a way to customize the Dashboard to handle those events. But Epicor oughta make this a new feature.
Epicor Dashboards Execute BAQ with Params on Filter?


Passing Parameter/Filter in Dynamic Query
Set a default value in a Dashboard tracker prompt / BAQ Paramaters & tracker inputs
(Chris Conn) #2

:smiley:


(Jose C Gomez) #3

YES!!! This is something we’ve been fighting with for ages. Parameters should be able to be mapped to dashboard tracker so you can pass those in without the extrapoup and pain as well as the publish subscribe functionality


(Brandon Anderson) #4

#1 vote right here!!! (I’ll take all of my other votes away if this one can happen!)


(Stephen Edginton) #5

Good idea


(Haso Keric) #6

@Edge Chris_Conn was wondering if its done yet? :smiley: For his Birthday if he had a choice between a Pony and this, he would choose this.


(Dean Miller) #7

Yes Yes Yes Yes YES !!


(Alex Ridge) #8

halll%20meme


(Haso Keric) #9

Maybe in 10.2.400… Maybe…? :slight_smile:


(Joshua Giese) #10

I don’t recall but I don’t believe as of at least 10.1.500 maybe even earlier, that a BAQ actually will post filter from a dashboard. I’m pretty sure @josecgomez and/or I ran sql traces on dashboard BAQs and found that the filters that are passed into the dashboard (not baq params) are used in the direct SQL query. Not the whole query coming back then filtered.


(Brandon Anderson) #11

Yeah, that good for performance, however, certain things don’t work with that type of filtering. For example, an anchor on a CTE query, or aggregate functions in lower levels on the query. That’s the problems we are having.


(Haso Keric) #12

@Bart_Elia hows it coming on this? :smiley: :smiley:


(Jose C Gomez) #13

@hasokeric I think this is a @Rich request not a @Bart_Elia one lol


(Richard Riley) #14

Yep this is one for me. This is currently not on the list for 400 and I will need to review level of effort as 400 is already past full and we would need to re-prioritize if this is more than a few hours of work.

I will be asking the BAQ team to see how much work it would be to allow the use of BAQData field values in Constraints / Filters. That would require a little code work from you but you should be able to reduce / remove the necessity to have the parameter prompting and that work would provide value into the Kinetic future…


E10 Dashboard passing parameters
(Bart Elia) #15

Agreed this is all @Rich’s. He’s been god of ICE for longer than I was on the team and I am off playing in the cloud these days.