Recently someone asked me if it is possible to programmatically access information from notes and add them on a page or report, so I thought, why not blog about it?

The first thing you should know is that notes are saved in the table: “Record Link“:

And you should also know that there’s a codeunit “Type Helper” that can help you:

This codeunit contains a lot of very useful functions such as:

And that’s exactly what you need.

So let’s put this in an example. Let’s create a codeunit, with a function: GetNotesForRecordRef:

Now you can use this procedure, for example in a page extension:

And voila the result:

Now you can use this procedure, for example in a report:

And voila the result:

Here’s the example al project:

FindNotes

 

 

One Thought on “How Do I: Use Record Notes in an AL Page or Report?

  1. Matthias Rabus on March 24, 2019 at 13:33 said:

    Hi Steven,

    interessting post! You could optimize the read of the RecordLinks by using SETAUTOCALCFIELDS instead of CALCFIELDS 🙂

    Best regards & a nice weekend to you

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation