Skip to main content

Posts

Showing posts with the label QueryBuildDataSource

Add custom Lookup for Employee id in Ax 2012

By
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();
Read more

Code to set range in lookup for SSRS Report in Ax 2012

By
This is sample Code to set range in lookup for SSRS Report in Ax 2012 in UI Builder class. First create lookup method in this sample code EmpLookUp is method for lookup then using post build and build method you can get lookup with range. public void build() { contract = this.dataContractObject(); dialogReportNatureofSaration = this.addDialogField(methodStr(TestSummaryContract, parmModeofSeparation),contract); dialogreportEmpCode = this.addDialogField(methodStr(TestSummaryContract, parmEmpId),contract); dialogreportEmpCode.value(""); dialogReportNatureofSaration.value(""); } private void EmpLookUp(FormStringControl EmpLookUp) { Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildDataSource queryBuildDataSourceLocal; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup; ; { sysTableLookup=SysTableLookup::n...
Read more

Some important interview question and answers on queries in axapta technical

By
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 t...
Read more