How to Call a BAQ from Script Editor in Epicor ERP

    ERP tech help

    Call a BAQ from Script Editor

    For this Epicor tutorial, I wanted to share a tip I have learned while working with a Business Activity Query (BAQ) in Epicor: how to call a BAQ from Script Editor.

    After a BAQ has been created, you can then call the BAQ from code within the script editor inside of a customization, which allows you to access the data the BAQ returns.


    Step 1

    Assuming you are familiar with creating a customization, click on the “Script Editor” tab in your customization.

    The first thing you must do is add in the necessary assemblies for calling a BAQ. In the menu bar of the customization screen, select “Tools” and then “Assembly Reference Manager” to open a new window. In the lower, right-hand corner of the window, click on the “Add Custom Reference” button.

    Step 2

    Select the following DLL files and click on the “Open” button.

    Epicor.Mfg.AD.DynamicQuery

    Epicor.Mfg.BO.DynamicQuery

    Epicor.Mfg.Core.BLConnectionPool

    Epicor.Mfg.IF.IDynamicQuery

    Step 3

    You will now see your newly added assemblies under the “Custom Assemblies” folder.

    After you have closed the window, be sure to add the following using statement to the top of your code:

    using Epicor.Mfg.Lib;

    Step 4

    Next, you will need to create a “session” variable inside the Script class:

    // Add Custom Module Level Variables Here **

    Epicor.Mfg.Core.Session session;

    Inside the “InitializeCustomCode” method, initialize the session variable using the current form you are customizing:

    public void InitializeCustomCode()

    {

    // End Wizard Added Custom Method Calls

    session = (Epicor.Mfg.Core.Session)CustShipForm.Session;

    }

    Step 5

    Last, in the method where you want to call the BAQ, initialize the “QueryDesignDataSet” and “DynamicQuery” objects, followed by the actual call.

    You can pass query parameters in as well.

    private void ShipHead_AfterFieldChange(object sender, DataColumnChangeEventArgs args)

    {

    // Initialize objects

    QueryDesignDataSet dataset = new QueryDesignDataSet();

    DynamicQuery query = new DynamicQuery(session.ConnectionPool);

    // Point the dataset to the BAQ

    dataset = query.GetByID(string.Format("{0}-BAQName", session.CompanyID))

    // Pass in a parameter

    dataset.QueryWhereItem[0].RValue = 123;

    // Execute the BAQ

    DataTable table = query.Execute(dataset).Tables["Results"];

    }

    Step 6

    The data is returned in a DataTable to make it easy for you to access.

    Wrap Up

    Have more questions about your ERP instance? Datix is an Epicor Platinum Partner, meaning we're experts in all things ERP. Contact us today to learn more about our innovative solutions!

    CONTACT AN EXPERT AT DATIX TODAY!

    Amanda Hagedorn

    Amanda Hagedorn

    As the Marketing Associate, Amanda constantly researches new trends in enterprise software as well as the manufacturing and distribution industries to generate fresh content about Datix's premium solutions and services.

    Why Middle Market Companies Flourish Revive Your ERP System

    Contact Us

    Categories

    see all

    Recent Posts