Hi,
How can I sort this lookup values? This is the only way to reach data from AX i need to order dates in desc order…
protected void TblDateLookup(object sender, AxLookupEventArgs e)
{
AxLookup lookup = (AxLookup)sender;
Proxy.SysDataSetBuilder sysDataSetBuilder;
sysDataSetBuilder = Proxy.SysDataSetBuilder.constructLookupDataSet(AxSession.AxaptaAdapter, TableMetadata.TableNum(AxSession, “bphRPayTblDates”));
lookup.LookupDataSet = new DataSet(AxSession, sysDataSetBuilder.toDataSet());
lookup.Fields.Add(AxBoundFieldFactory.Create(AxSession, lookup.LookupDataSetViewMetadata.ViewFields[“TblDate”]));
lookup.SelectField = “TblDate”; // This is date format
}
Thanks in advance.