Reference a BAQ as a table in another BAQ?

Kinetic ERP
1

I’ve found a couple posts on here about this, some are a couple years old. The ones I found seem to say this is not a feature. I’ve been doing some digging and can’t find anything about it. I also don’t see anything on the Epicor menu that looks like it does this (deploying it as a view or something). So, I’m looking for a reference or confirmation its now available.

Here is what I’m trying to do:

I have 1 BAQ I’ll call DateInfo that is doing some calculations through many CTEs and UnionAlls (it is 17 different sub queries) and spits out a list of week numbers and dates. It is more complex and large than I would want to recreate in other BAQs. The DateInfo BAQ data is the data I want in my top level query of my second baq, then I want to build sub queries linking off of DateInfo baq as a table in my toplevel query of BAQ 2.

Is this possible? Can you use a BAQ as a table or data source in another BAQ?

I appreciate the responses!

2

This functionality is available in more recent versions using the newer Kinetic BAQ Designer. You can pull in a BAQ as a Reference Query.

Can’t remember exactly when this became available, maybe 2024.1?

3

Must be…we don’t have it in 2023.2

4

Can confirm 24.2 has this ability.

5

Thank you for confirming this. Would this be in the same section that is Tables / Connected Tables / (Sub)Queries on the Query Diagram card?

6

sort of - there is another icon to click - the 3-dot icon, then in that list there is an item call ‘Reference Query’

2 Likes
7

There is/was a problem with Reference Queries that have CTEs in them:
PRB0283006

I ran into a similar symptom, where I was unable to create a Kinetic dashboard when the BAQ used a reference query, even though the reference query did not have any CTEs. The dashboard did deploy to Classic correctly. Epicor accepted this as:
PRB0296393 - “Accepted - Not Yet Planned”