Saturday, July 6, 2013

Dynamics AX technical consultant interview questions - Part II

In continuation of my last post regarding Dynamics AX technical consultant interview questions, here are some additional questions for technical interview preparations:

  1. Difference b/w this.queryBuildDataSource(); and this.queryRun().QueryBuildDataSource();
  2. Difference b/w temp table and a  Container
  3. Difference b/w active/passive/delayed join
  4. Can we use regular table as temp table
  5. Can we use temp table for cachelookup
  6. Difference b/w .Net business connector and AIF web service
  7. What is load balancing
  8. How many tiers we normally used for installing dynamics ax 2012
  9. What is the purpose of ‘Dynamic’ property of AOT Query Field node
  10. Can ‘select firstonly’ statement return more than one record? If Yes, How?
  11. How we can achieve ‘View detail’ / ‘Go to main table’ functionality in Any form’s lookup field?
  12. Can a form’s grid contain columns from more than one datasource?
  13. How we can achieve ‘Drag and drop’ functionality of selected record in to separate form or Grid?
  14. What is the purpose of Debug::assert()?
  15. How we can achieve lookup functionality on EDT level in Dynamics AX 2012
  16. How we can change Right click menu in Dynamics AX 2012

 

Friday, July 5, 2013

Example for using a tempDB table in a Query

Below job is adding and retrieving data into tempDB via query object.

static void TempDB(Args _args)
{
    PurchLineMarkTmp    tmpUnionedResult;
    InventTable         inventTable;
    InventTableModule   inventTableModule;
    Query               query;
    QueryRun            queryRun;

    // Execute insert_recordset with TempDB table as a target
     insert_recordset tmpUnionedResult(PurchLine)
        select RecId from inventTable
            exists join inventTableModule
                where   inventTableModule.ModuleType == ModuleInventPurchSales::Sales
                    && inventTable.ItemId == inventTableModule.ItemId
                    && inventTableModule.Price != 0; 

    query = new query();
    query.addDataSource(tableNum(PurchLineMarkTmp));
    queryRun = new QueryRun(query);
 
    // Force queryRun to fetch from the right temporary table
    queryRun.setRecord(tmpUnionedResult);

    // Iterate all registered quantities
    while (queryRun.next())
    {
        tmpUnionedResult   = queryRun.get(tablenum(PurchLineMarkTmp));
 
        info (strFmt('%1', tmpUnionedResult.PurchLine));
    }
}


 

Microsoft Dynamics AX 2012 White Paper - Enterprise Portal Development Cookbook

You can find EP Dynamics AX cookbook under the following link:

Microsoft Dynamics AX 2012 White Paper: Enterprise Portal Development Cookbook