Filtering a DataSet from Code behind | Tmao Coders

Filtering a DataSet from Code behind | Tmao Coders — Tue, 18 Nov 2008 01:55:57 GMT

PingBack from http://www.tmao.info/filtering-a-dataset-from-code-behind/

Filtering a DataSet from Code behind

Microsoft Dynamics AX Enterprise Portal Team Blog — Tue, 18 Nov 2008 10:40:10 GMT

Enterprise portal allows filtering the list pages using the Filter control available on the EP Grid.

re: Filtering a DataSet from Code behind

AlanFlanders — Fri, 07 Aug 2009 02:01:18 GMT

This is really great stuff, but can't get it to work on an AxLookup. This code doesn't end up doing anything, as in the filter does not show up in the lookup popup window. I've debugged and everything appears to be fine but it just won't show the filter in the lookup.

Alan

void a_Lookup(object sender, AxLookupEventArgs e)

{

// The underlying control in this case is the lookup control

AxLookup lookup = e.LookupControl;

// Get the edit value of the cell

String lookupString = tDesc.Text;

DataSetView dsv = lookup.LookupDataSet.DataSetViews[0];

Microsoft.Dynamics.Framework.Data.Ax.filterObject flt = new filterObject();

flt.name = "DVCAXLookupBoundFieldCustomFilter";

Microsoft.Dynamics.Framework.Data.Ax.conditionType myConditionType1 = new conditionType();

myConditionType1.@operator = Microsoft.Dynamics.Framework.Data.Ax.operatorType.startswith;

myConditionType1.status = Microsoft.Dynamics.Framework.Data.Ax.conditionStatus.open;

myConditionType1.value = lookupString;

myConditionType1.attribute = DataFieldLookUpDesc;

flt.conditionCollection.Add(myConditionType1);

dsv.UserFilter.Add(flt);

}