Using Temporary Tables On Data Entities

(0) Share

Report

Posted on by uzk_dynamics

170

Hello,

Can anyone tell me how to add a temporary table on data entity on dynamics 365 ax 2012.

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is your question about Dynamics 365 for Finance and Operations or AX2012?

I guess you would like to use a temporary table as a data source for export. I think that's not possible, rather you have to populate a real physical table, export the data and then remove the records from your physical table.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

Adding temporary table is not possible. Why you want to add temp table ?

Was this reply helpful? Yes No
André Arnaud de Cal... 306,632 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Uzair,

Have you perhaps data on a form that is build up with temporary data which you would like to export? In that case, follow the procedure mentioned by Nikolaos or create a view on tables if the temporary data logic is simple to catch in a view.

Was this reply helpful? Yes No
uzk_dynamics 170 on at

Like (0)

Report
Copy link

Link copied!

It is about dynamics 365. Actually in our scenerio, we want to import some data from Legacy System, and process run AX process based on that temporary data. We dont want to store the imported data permanently, but either use it for some AX process, using odata entity

Was this reply helpful? Yes No
uzk_dynamics 170 on at

Like (0)

Report
Copy link

Link copied!

It is about dynamics 365. Actually in our scenerio, we want to import some data from Legacy System, and process run AX process based on that temporary data. We dont want to store the imported data permanently, but either use it for some AX process, using odata entity

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

The correct solution is to read the data into a normal table (non-temporary) and clean it up after it's not needed.

If you don't use OData, instead data management project, the data is imported to staging tables. Perhaps you can then put your code in the data entity, staging to target process. And finally clean up your staging data with standard D365FO functionality.

Was this reply helpful? Yes No
uzk_dynamics 170 on at

Like (0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No
Kurt.Warner 55 on at

Like (0)

Report
Copy link

Link copied!

If the data entity populates the regular table, then how does the entity distinguish records it has just populate for the current session user from other session entity user records?

Thanks in advance.

Was this reply helpful? Yes No