Pass parameter to PartBinSearch in a button search

Epicor ERP 9
1

When executing Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(this.oTrans, “PartBinSearchAdapter”, out recSelected, true, whereClause), the result is empty. Anyway of passing the filter parameter to run the search?

2

the “whereClause” you should be able to populate with whatever pre-filter you’d like to use.

3

Hi Jose, I tried that but it’s not returning any results, the datagrid is empty. Ran the tracing and can see it calling the correct methog but the parameters are empty.

4

Can you paste your whole code (that method at least)
It should return something as long as your whereClause is valid

5

private DataRow binSearch(string wareHouseCode)
{
bool recSelected=false;
bool morePages = false;
string whereClause = “warehouseCode=’” + wareHouseCode + “’ and uomCode=‘LB’ and partNum =’” + partEpiTextBox.Text + “’ and lotNum=’” + fromLotEpiTextBox.Text + “’” ;

	System.Data.DataSet dsLotAdapter=null;
	System.Data.DataRow adapterRow =null;

dsLotAdapter = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(this.oTrans, “PartBinSearchAdapter”, out recSelected, true, whereClause);

	if (recSelected)
	{
		adapterRow = dsLotAdapter.Tables[0].Rows[0];			
	}

	return adapterRow;

}

6

Try narrowing it down, just add a simple whereclause like
“WarehouseCode=‘XX’” and see if that works, your whereClause has a lot of parts so maybe not everything on there is true?>

7

Tried that as well and still no value returned. I can run the same filters on another scree, say inventory transfer, and will get the expected results.