Skip to main content

Posts

Showing posts with the label query

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

Add custom Lookup for Employee id in Ax 2012

To Add customLookup for Employee id in Ax 2012 you can try below code sample in datasource filed of the form. You can add data method to lookup easily to get the name of the employee. Here HcmWorker is a master table of employee and personnel number and name is the field of Hcmworker table. SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker),_formControl); Query query = new Query(); QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(HcmWorker)); queryBuildDataSource.addRange(fieldnum(HcmWorker,Tester)).value(queryvalue(Noyes::Yes)); sysTableLookup.addLookupfield(fieldNum(HcmWorker,PersonnelNumber)); sysTableLookup.addLookupMethod(tableMethodStr(HcmWorker,Name)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup();

Add Lookup Method for Dimension fields for UI Builder class in Axapta SSRS

To Add Lookup Method for Dimension fields like division ,branch etc using UI Builder class in Axapta SSRS Report you can refer below code. #define.DimensionName("Branch") Query query; QueryBuildDataSource qbds,qbds1; SysTableLookup sysTableLookup; DimensionAttribute dimAttr; ; dimAttr = DimensionAttribute::findByName(#DimensionName); sysTableLookup = SysTableLookup::newParameters(tablenum(OMOperatingUnit),branchCodeLookup); sysTableLookup.addLookupfield(fieldnum(OMOperatingUnit, OmoperatingunitNumber)); sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name)); query = new Query(); qbds = query.addDataSource(tableNum(OMOperatingUnit)); qbds.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(queryvalue(OMOperatingUnitType::OMBusinessUnit)); sysTableLookup.parmQuery(query); sysTableLookup.parmUseLookupValue(False); sysTableLookup.performFormLookup(); Division dime

Some important interview question and answers on queries in axapta technical

Q) why do we use queries? Ans:queries are user interactive, faster, compiles, reusable components query, queryrun,querybuilddatasource,querybuildrange if(qr.prompt()) Q) what is difference between temporary table and container??? Ans:when there  are more than 50 columns then  we go for  temp tables and also there are some advantages using temp tables - we can create index, methods , fieldgroups Q) How  do u share tables across the companies???? Ans: Tablecollections and virtual companies Q) when is configuration key used?? Ans:To  enable  and disable the features for all  users [tables, fields, indexes, form controls, edt.enum...etc] Security  key   for   set  of  users  or  usergroups - tables, forms, report, menuitems etc RLS [Record level security] Q) What are display methods? Ans:Display  methods  will help you to show the data from some other table or hard-coded strings..these are not bound controls and we cannot use filter or sorting option