Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Attachment notes (fact box)

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 70,191 Super User 2024 Season 2 on at
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator 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,744 Moderator 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans