Use Temporary Table in AX 2009

Temporary table(Table whose property temporary set to "yes") is not persistent media , so at run-time you have to populate the temporary table and attach the same to the form/report.
For illustration purpose ,I am using inventTable data and attaching the items whose group is Parts.

Steps
1. Create temporary table as TmpTestTable with 3 fields(ItemId,Itemname,ItemGroup).
2. Create a form as TempTestTable and attach the table as datasource
3. Create a new method on the form and copy the following code
TmpTestTable populateRecords(ItemGroupId _itemGroupId)
{
TmpTestTable tmpTable;
InventTable inventTable;
;
while select inventTable
where inventTable.ItemGroupId == _itemGroupId
{
tmpTable.Itemid = inventTable.ItemId;
tmpTable.ItemName = inventTable.ItemName;
tmpTable.Itemgroup = inventTable.ItemGroupId;
tmpTable.insert();
}
return tmpTable;
}

4. Call the above method in init() after super as belowpublic void init()
{
super();
// Call the setTmpData method to attach records to datasourceTmpTestTable.setTmpData(element.populateRecords("Parts"));
}

For details about Types of Temporary tables in AX 2012, check this post.

Comments

Post a Comment

Popular posts from this blog

Change Tracking in Data Entities and latest changes

Image
If you’ve ever worked on data integrations or migrations in Dynamics 365 Finance & Operations (F&O), you know the pain of moving large datasets repeatedly. Enter Change Tracking - a feature that feels small but makes a huge difference. What is Change Tracking? Change Tracking lets you detect and export only what changed since the last sync, instead of dumping the entire dataset every time. This is used by Microsoft already in the out-of-the-box frameworks : Inbuild Integrations with Microsoft CRM or BI scenario. Could be used for integration towards external apps. Incremental data migration  using DMF during cutovers. BYOD exports where performance matters. Why It Exists Without Change Tracking: Every export = full dataset. More time, more cost, more risk of throttling.  Most costs (per transfer / transaction). With Change Tracking: Only inserts, updates, and (sometimes) deletes are exported. Faster, lighter, and easier to schedule. Lesser costs. Types of Change Tr...
Read more

Finding Table Names and Data Entities in D365 F&O

Image
When working with data in Dynamics 365 Finance & Operations , one of the most useful skills is knowing where your data lives - which table or data entity holds the field you’re looking at. Why? Because this knowledge unlocks so many possibilities: Extracting data for analysis. Mass updates through Data Management . Building integrations or troubleshooting issues. Think of it as peeking behind the curtain to understand the architecture that powers your forms. Why This Matters Here’s a little reality check: Different fields on the same form can belong to different tables . A single field can appear in multiple data entities . And not all users have equal access - System Admins have the most visibility (SysTableBrowser, entity lists, etc.). So, if you’ve ever wondered “Where does this field actually come from?” , the below could guide you. Part 1: How to Find the Table Name for a Form Field Open the Form Navigate to the form where the field lives. Say, CustTableListPage. Right-C...
Read more

D365Ops Tip #1: Table browser

Image
It has been few months that the new AX, Dynamics 365 for Operations is released to market. And being a web client, the Business users and/or Application consultants working with AX, don't have the privilege of going into the AOT from the Client even with 'System Administrator' role in AX . And one of the most used tool used by any Developer and also sometimes by App. consultants is the Table browser accessing which is a bit different with the New AX - this post illustrates on how to achieve this with a Change in URL. We can start with an example, please observe the URL in the browser when you try to open the Users form (System Administration > Users > Users). https:// d365ops0516devaos.cloudax.dynamics.com / ?cmp=USRT&mi=SysUserInfoPage so now, from here if you want to open Table browser for "Users form", you can do so without using any tools by just changing the URL. https://d365ops0516devaos.cloudax.dynamics.com/?cmp=USRT& mi=SysTableBrow...
Read more