How do I access the base table where the fact box notes are stored?
I need to gather all notes from the system.
How do I access the base table where the fact box notes are stored?
I need to gather all notes from the system.
Hi, Just adding some links that I feel are informative. Hope this helps.
How to make web service with links from items? — mibuso.com
Add Record Link via webservice? — mibuso.com
How Do I: Use Record Notes in an AL Page or Report? – think about IT
Record Links in Microsoft Dynamics NAV(NAVISION ERP) (olisterr.blogspot.com)
(+) BC Item Card -> Attachments -> link table? - Dynamics 365 Business Central Forum Community Forum
For excel buffer:
Thanks.
ZHU
I think the best way would be to go through the ExcelBuffer
Read them from the recordlinks table.
Put them into the Excel buffer and then create an excel sheet based on the excel buffer.
I do not have any samply code specifically for the record link table.
But here is some samples on how to use the excel buffer.
Let me know if you bump into any issues and i will see if i can make some sample code unless someone else here got something ready.
What is the best way to get this data into excel in bulk?
for instance all customer notes
thanks
You find them in this table:
RecordLinks (2000000068)
The notes are stored in a blob filed in that table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,570 Super User 2024 Season 2
Martin Dráb 228,683 Most Valuable Professional
nmaenpaa 101,148