Skip to main content

Posts

Showing posts with the label lookup dataset

Add Financial dimension Lookup at Enterprise portal in Axapta

To Add Financial dimension Lookup at Enterprise portal in Axapta you can to help with below code. protected void BusinessSector_LookUp(object sender, AxLookupEventArgs e) { //Getcurrent user to filter record based on current user String usr = WindowsIdentity.GetCurrent().Name; int pos = usr.IndexOf('\\'); usr = pos != -1 ? usr.Substring(pos + 1) : usr; AxLookup lookup = (AxLookup)sender; // Create the lookup data set. The respective table will be used. Proxy.SysDataSetBuilder sysDataSetBuilder; sysDataSetBuilder = Proxy.SysDataSetBuilder.constructLookupDataSet(AxSession.AxaptaAdapter, TableMetadata.TableNum(AxSession, "DimensionFinancialTag")); // Set the generated data set as the lookup data set. lookup.LookupDataSet = new DataSet(AxSession, sysDataSetBuilder.toDataSet()); using (Proxy.Query query = lookup.LookupDataSet.DataSetViews[0].MasterDataSource.query