E9: EpiCombo on UserCodes Filter only for IsActive = true

Epicor ERP 9
12

Ah, true - I forgot so the way I always did that was, there is a HiddenColumns Property I would add IsActive column

Then I would just make an event BeforeDropDown is Shown to hide the Non-Active ones.

private void epiComboC2_BeforeDropDown(object sender, System.ComponentModel.CancelEventArgs args)
{
  	// ** Place Event Handling Code Here **
	EpiDataView edv = oTrans.Factory("Contact");

	epiComboC2.Rows.ColumnFilters["CodeID"].FilterConditions.Clear();
	epiComboC2.Rows.ColumnFilters["CodeID"].FilterConditions.Add(Infragistics.Win.UltraWinGrid.FilterComparisionOperator.StartsWith,edv.dataView[edv.Row]["ShortChar03"]);
                                            
}

private void cmbPartClass_BeforeDropDown(object sender, System.ComponentModel.CancelEventArgs args)
{
	// ** Place Event Handling Code Here **
	EpiDataView edv = oTrans.Factory("PODetail");

	// Reset Filters
	cmbPartClass.Rows.ColumnFilters["ClassID"].FilterConditions.Clear();

	if (edv.dataView[edv.Row]["CalcTranType"].ToString().Equals("PUR-UKN"))
	{
		cmbPartClass.Rows.ColumnFilters["ClassID"].FilterConditions.Add(FilterComparisionOperator.StartsWith, "R");
	}
}

FYI: In E10 it looks like they auto remove the inactive UD Codes.

2 Likes