I have a dashboard with 3 queries. Publishes OrderNum. Subscribes to OrderNum from Query 1 and publishes OrderNum and OrderLine. Subscribes to OrderNum and OrderLine from Query 2. Is this not a good way to do this? I am getting the same release line repeated a billion times on the third query. I …

Publish both OrderNum and OrderLine in 2. If this is a Cross Company BAQ then you’ll want to include Company in them all.

also, with newer versions of Epicor, you can create Order Number & Order Line PARAMETERS on the two subscribing BAQs, and then pass the published values to the parameters. This will make your queries more efficient.

I think you may need to add Sales OrderRel on the second query and subscribe to OrderNum, OrderLine, OrderRel on the third one.

Doug, I am publishing both OrderNum and OrderLine on query 2. I edited my post above because I did not mention that… Good point on the Company. We are not multi-company but I was told it’s always good to include company and I did not do that.

I hadn’t thought of that. I will give this a try also.

OK. So goofy things… I guess for some reason it copied both the OrderRel and the OrderRel_UD tables to my BAQ. I didn’t know I could bring the _UD table in? I thought it came along with the OrderRel by default… In any event, that is what was causing the subscription to act funny. I removed that tabl…

That OrderRel / OrderRel_UD thing is a bug that peridically happens. I have had it happen when I add a table, and then delete and add another table, it seems to loose its brain. I have not been able to successfully replicate it. You dont even see the bad query until you save, exit, and reload. When …

That’s exactly what happened. I sat there scratching my head at the end of the day yesterday. I came in this morning, opened it up, and lo and behold there’s this detached _UD table. I deleted it and all of a sudden things started working as expected. How do I set the subscription to a parameter? I …

You have to add a tracker view and pick the fields you want to use as filters. Vinay Kamboj .

[image] dr_dan: I know how to setup the parameter on the BAQ… and filter using that parameter… but in the dashboard, how do I tell the subscriber to use the published value as the parameter… if that makes sense? I think that’s on .700+. I don’t see it in .500. edit looks like .600+ …

Dashboard subscribe BAQ repeats rows

Epicor ERP 10

Banderson (Brandon Anderson) March 23, 2021, 7:24pm 11

I think that’s on .700+. I don’t see it in .500.

edit looks like .600+

Topic		Replies	Views
Dashboard Publish/Subscribe Not Working Epicor ERP 10	2	1900	June 17, 2025
Dashboard - multiple parameters in pub/sub between queries - poor performance? Epicor ERP 10 baq , dashboard	1	1037	April 29, 2021
Dashboard subscribing query doesn't see publishing query Epicor ERP 10 dashboard	2	849	August 16, 2019
Dashboard using multiple queries Kinetic ERP baq , dashboard	5	2148	October 26, 2022
Epicor 9 Multi-query Dashboard Epicor ERP 9 baq	2	698	February 14, 2019

Dashboard subscribe BAQ repeats rows

Related topics