How Do I: Use Record Notes in an AL Page or Report?

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

 

 

Comment List
Related
Recommended