Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Attachment notes (fact box)

(0) ShareShare
ReportReport
Posted on by 10

How do I access the base table where the fact box notes are stored? 

I need to gather all notes from the system.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Attachment notes (fact box)

    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.

    www.kauffmann.nl/.../

    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.

  • Rjohnson1607 Profile Picture
    Rjohnson1607 10 on at
    RE: Attachment notes (fact box)

    What is the best way to get this data into excel in bulk? 

    for instance all customer notes 

    thanks 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Attachment notes (fact box)

    You find them in this table:

    RecordLinks (2000000068)

    The notes are stored in a blob filed in that table.

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans