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)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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,710 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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,160 Moderator on at

Like (0)

Report

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

Thanks

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

Like (0)

Report

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