Use Temporary Table as form datasource in ax 2012

Hi All,

In many scenarios we need to use temporary table as form data source. So below steps are used to achieve this target.

Step 1 - Create a temporary table and make "Table Type" property as "TempDB"

Step 2 - Create a class to fetch or generate the data and insert into temporary table.

Step 3 - Create a method in class for executing your code.

For ex- 

public TempTableTmp  GenerateTempTable()

{

    TempTableTmp       tempTable;

    ;

    Write your logic and insert into temporary table then write below line:

    return tempTable;

}

Step 4 - Create a form and used temporary table created in step 1 as data source.

Step 5 - Override init method at form data source level.

Step 6 - In this method we need to instatiate the class which we have developed at step 2

For Ex - 

public void init()

{

TempTableClass temptableclass = new TempTableClass();

super();

tempTable = temptableclass.GenerateTempTable();

TempTableTmp.linkPhysicalTableInstance(tempTable);
//In above line if you will not use "LinkPhysicalTableInstance" method then you will not get the data on form.

} 

Step 7 - Create a display type menu-item and place at your desired place.

It will solve your issue.