CODEWITHSUNDEEP
dynamics-ax-2012dynamics-ax-2012-r3
masoud
masoud

Reputation: 478

How to fetch data from Archive database

i'm working with Dynamics ax 2012 and I've archived data with IDMF

Is there any way to show both of live data and archived data in Ax Grids ,

best regards

Upvotes: 0

Views: 323

Answers (2)

10p
10p

Reputation: 6758

According to this diagram, the archived data resides in a different database, which can be accessed from AX only using bespoke functionality e.g. using such system classes as OdbcConnection, LoginProperty, SqlStatementExecutePermission, Statement, etc. You could fetch this data into temporary tables and view them in AX grids, but that wouldn't work well for large sets of data.

enter image description here

Upvotes: 1

FH-Inway
FH-Inway

Reputation: 5117

You could create a temporary table and combine the live data and archived data at runtime in this table. You can then use the temporary table in a form grid.

But I would question why this data was archived in the first place since there still seems to be a business need for it.

Upvotes: 1

Related Questions