Notifications
Announcements
No record found.
Hello,
I want to know if there is a way to look 'inside' a tmp table in d365fo.
I would like to see exactly what lines are there in at the moment.
If I would create my own project i could propably just don't delete data after insert but how about already created ones? Like freetextinvoice I would like to know what data is in this table after I created a invoice.
Your question is too generic to be answered.
For example, when you say "after I created a invoice", do you mean a moment when the temporary table is still in scope or not? If it got out of scope, the temporary buffer was already destroyed and therefore looking at the data isn't possible.
If it still exists and you can get a reference, you could use a piece of code to iterate the buffer and check the data. It might be possible even if the Immediate window in Visual Studio.
If you want to check it outside F&O, think twice if it's a good idea and then find out which kind of temporary table it it. TempDB tables are stored in TempDB database (with generated names) and InMemory tables are either in memory (which is likely inaccessible for you) or in files on disk.
Hi RadekM,
You can always try to use infolog and inserted\updated eventhandler for table to push info messages (data can be pushed to xml via record.xml() or you can output only needed fields manually).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
