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:
Here’s the example al project: