Dashboard Adding a Recursive BAQ that accepts published items from another BAQ

Epicor ERP 10
1

I have a dashboard with a BAQ that generates a list of what are essentially parts and some associated data.

This BAQ is publishing the part number and the latest revision level for that specific part.

My recursive BAQ is an indented BOM, with a CTE and Union All etc. I added this BAQ to the dashboard, after creating a copy of it without the parameters for the part number and revision level. I set up a filter using the published items from above.

It does not bring anything up when I refresh, only the list of parts in the first BAQ, it sits there and spins, and more than likely times itself out.

What am I missing? Does anyone have any ideas? It is like it is not getting the published part number and revision level…

2

part number and the latest revision level
BAQ is an indented BOM, with a CTE and Union All etc.
Sounds like you want to add a Part/Rev lookup on top of a BAQ for an indented BOM?
I wonder how you’ve built the dashboard… if it might try to process all BOMs at some point?

I never could get a search to work at the Dashboard level & I remember thinking at the time that dashboard was not able to handle this.

So instead I set up a dashboard with only one indented BAQ, no lookup for users, they just need to know the BOM number and Rev they want ahead of time.

e.g. one BAQ that includes:

  • a sub-query that gets the latest rev for Material PartNums
  • the sub-queries for indenting… CTE, Union All etc.
  • and BAQ parameters for BOM and Rev
3

I was able to replicate a Recursive CTE by following https://www.essentialsql.com/recursive-ctes-explained/

I did the Epicor Query first in MS SQL to get the concept down and then translated it into a BAQ within 30 minutes.

2018-05-08_0734

Then I made a dashboard with some Customization Layer to search the Hierarchy properly.
2018-05-08_0737

2018-05-08_0736
2018-05-08_07361726Ă—969 60.5 KB

It executes within 2-4 seconds and traverses through all JobProd Levels. But I hope that link above and some of the info shared here, assures you atleast that it is possible =)

2 Likes
4

I have the recursive BAQ functioning just fine. I want it to be able to accept a published part number from another BAQ in the dashboard. Right now I have a parameter for the part number. Is there any way to have the parameter accept the published part number from the other BAQ?

5

Have you looked at this? Concepts sounds the same. Then you don’t need the parameter. It will work just the same.