Skip to main content

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 options





Popular posts from this blog

X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )

Below is sample X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )      Args                       args = new Args();     CustInvoiceJour            custInvoiceJour;     SalesInvoiceJournalPrint   salesInvoiceJournalPrint;       select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';       // Add record to be printed.     // In order to have the context table we need to set args.record().     args.record(custInvoiceJour);       salesInvoiceController = new SalesInvoiceController();     salesInvoiceController.parmReportName(         PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());       salesInvoiceContract = salesInvoiceController.parmReportContrac...