I have created a Toplevel query and a sub query. However, when I go to drag the subquery on the board to join with the Toplevel query no sub query’s show up when I click the sub query button. Anyone have any ideas? Thanks in advance
Best answer by todd caughey
View originalWhat type is the SubQuery? Most of our are InnerSubQuery - implying a join I think.
-Todd
I have a top level and an innersubquery. When I click on the sub query button nothing appears.
The one I am working on currently shows:
The TopLevel query was renamed TopLevel.
I have seen strange things in BAQ Designer many times and usually need to exit Epicor and go back in to BAQs from scratch and open the BAQ. Usually resolves it without rebooting but there is that too. Or try Options - Clear Client Cache sometimes does it.
-Todd
This sounds dumb, but check query order. If you top level is query 2 in might not be able to “see” query 1. There are several places this happens. I don’t know if this is one of them.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.