Business Activity Query (BAQ)

Every business needs an intuitive and easy to use query engine. Epicor ICE 2.0 provides the business activity query (BAQ) Designer, which allows you to create personalized queries or to copy standard queries so that they can be modified. Once the query is created, it can be used throughout Epicor next generation business applications—to generate reports, for quick searches, or to view the results in a role-based dashboard. Epicor ICE BAQ lets you create queries that display the data you need, when you need it. 


The BAQ Designer includes the following features: 
 •     Multiple ways to define a BAQ (free form or wizard).

•          Use of temp tables for BPM.

•          A graphical mechanism for showing table linkages.

•          Calculated columns in free form.

•          Easy to use wizards.

•          The ability to access the BAQ wizard or other components from other parts of the application (such as customization).

•          Multiple instances of a single table are allowed.

•          A double-pass approach for additional filtering of data on  the server.

•          BAQs are “callable” from within BPM.

•          Ability to test the BAQ before putting in production.

•          Ability to see .every place that a BAQ is used

In addition to providing a visual presentation of the query being created, the BAQ designer also provides tabs where you can analyze, test the syntax, and run the query to confirm the query is correct before it goes into production. There is also a tab to display where an existing query is being used— dashboard, quick search, or dynamic report. The BAQ designer provides all the tools you need to quickly and easily create queries that return the relevant data you need.

  Reference Epicor ICE documents