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

 

 

Leave a Reply

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

Post Navigation