Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have an urgent request to extract some data from a temp table... I need to use a query to get some info from these two(2) tables:
Please and thanks.
What kind of query are you interested in? Where and how do you plan to consume the data?
Temp table has data only if you populate it, and the data disappears once the table pointer is no longer in scope. So you need to have the population and data retrieval in the same process.
Thanks Nikolaos, so what I want to do is extract some data from the AX 2012r2 database. Some of the data am interested in would be coming from the CustAgingReportTmp table. This is data for auditing purposes. I thought that when i run the report Customer Aging and keep the report open, I would be able to see the data in CustAgingReportTmp table.. Please help if you can I urgently need it.
given this is one time request for Auditing purposes, you can change the table to permanent. That would retain the data that you can further extract. Once extracted, revert the change. See if you can leverage this approach.
I think the table is discarded when the report is printed.
Anyway, during the existence of the table you will find it in the tempdb database. But I don't think you should pursue this path longer. Instead you need to figure out some other way to get this data.
For example, you can copy this table and make this copied version a non-temporary table.
Then, when data is inserted in the temp table, populate the same record in your normal table.
When you don't need the data anymore, delete it from your normal table.
Also this is a "quick and dirty" solution but since you requested for urgent help, perhaps you could try that.
This cannot be done. i went on the table properties and change the TableType to Regular but when i run the report it gave me a message saying the table has to be TempDB
CAn you please advise how i do this.... It didnt work form the properties of the table
Table properties the only way i know. Give the solution that Nikolaos proposed a try.
Hi Lionel ,
You cant change the table property because of DP class. DP class is extended with standard class that allow only Temp table to populate data in report.
Nikolaos approach is the good option for your requirement . But if you need this on regular practice then you have to find some other option.
Thank you, everyone for your suggestions and help.
Business Applications communities