Passing Parameter/Filter in Dynamic Query

Epicor ERP 10
14

I have a couple of “light code” options for you - I am short on time so will post second option separately.

Option 1

Add a Text Box to allow user to enter a filter value. Add a Button that will execute the BAQ and apply the value entered in the TextBox as a filter against one of the Columns in the BAQ. Filter applied is in addition to any criteria defined on the BAQ.

Pros - not much code; Simple Setup; allows BAQ level where clause filtering without pop-up prompt
Cons - Only Supports filter condition against one column; Filter condition is always “Equal”
Pro and Con (depending on need) - Allows standard DBD Refresh to execute without filter applied

My Specific setup - use as example for your use case:
BAQ called “DemandSearch” created with Customer CustID as one of the display columns.
DBD created with DemandSearch BAQ. Tracker Panel added - No Fields set as Prompt
DBD AppBuilt and added to menu

Run DBD from Menu in Customization Mode. Customize:
Add TextBox control - leave it unbound
Add Button control - Set Text to “Refresh”
On Event Wizard - Add “Click” Event for Refresh Button

Add Code via Script Editor:
TextBox reference to Custom TextBox
Dispose Custom TextBox reference
Line of C# added for Click event - OnSearch has three parameters (we will look at the third one in Option 2 sample). First Param is the Column you want to filter. Second is the Value to use as the Filter. This one is applying Filter to the Customer CustID column.

// Code Sample Pulled from Script Editor

public class Script
{
// ** Wizard Insert Location - Do Not Remove ‘Begin/End Wizard Added Module Level Variables’ Comments! **
// Begin Wizard Added Module Level Variables **

// End Wizard Added Module Level Variables **

// Add Custom Module Level Variables Here **

private EpiTextBox epiTB1;

public void InitializeCustomCode()
{
	// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
	// Begin Wizard Added Variable Initialization
    this.epiTB1 = (EpiTextBox)csm.GetNativeControlReference("your TextBox EpiGUID here");

	// End Wizard Added Variable Initialization

	// Begin Wizard Added Custom Method Calls

	this.epiButtonC1.Click += new System.EventHandler(this.epiButtonC1_Click);
	// End Wizard Added Custom Method Calls
}

public void DestroyCustomCode()
{
	// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
	// Begin Wizard Added Object Disposal

	this.epiButtonC1.Click -= new System.EventHandler(this.epiButtonC1_Click);
	// End Wizard Added Object Disposal

	// Begin Custom Code Disposal
    this.epiTB1 = null;

	// End Custom Code Disposal
}

private void epiButtonC1_Click(object sender, System.EventArgs args)
{
	// ** Place Event Handling Code Here **

    // DemandSerch is the ID of the BAQ I am using. DemandSearch as in On Demand Search...

  V_DemandSearch_1View_Row.OnSearch("Customer_CustID",epiTB1.Value.ToString());

}

}

3 Likes