BAQ Documentation

Does anyone have any idea where to get documentation on BAQ Designer? I am specifically looking how to change the type of join that is created when dropping two tables into the Query Builder. Brand new to Epicor and have been unable to find much documentation.

I just posted something similar on another thread:

1 Like

The help file has pretty good explanations of most of the things in the BAQs.

For your specific question, it’s the dropdown that shows up here when you click on the join.
image

1 Like

@NateS , the tools guide is now in the help file. So you don’t need to go to Epic web anymore.

1 Like

You can find the Join Type in the BAQ Designer. Make sure you are in Business Activity Query Designer, not the BAQ report designer.
From there, look at the Query Builder Tab. Then look in the bottom right corner to find a drop down list of the join types. Join two tables with the little chain link icon in the top left. Choose the line that joins the two tables together, and change the join type with that drop down box.
Good luck!

1 Like

Thanks so much everyone