Accessing table notes, simple question

Finance and Operations/AX Developer Forum
1

Hello, friends

Could you provide a code example of how to access particular table notes in attachment? For example I have added notes to one of the purchase orders in PurchTable and I need to access them from code in another table.

Kind regards,

Roberts

2

In which version of AX? Please always attach a version tag, such as AX 2012 or D365FO, when creating a new thread.

How will you find the particular note? (A single order may have many attached notes.)

3

Sorry, I m talking about DFO365. Yes, I would need particular note.

4

All right, I’ve attached “D365FO” tag for you.

Regarding the other question, I didn’t ask if you meant your requirement seriously. I asked how you want to find the particular note. Let’s say that the order has five attached notes. How will you decide which one of these five notes is “the particular”?

5

I would need the first note from the list (the oldest one).

6

You’ll need to think harder about your requirements. You don’t seem to realize that there may be different kinds of notes.

Anyway, this is something that should help you:

DocuRef docuRef;
select firstOnly docuRef
	where docuRef.RefCompanyId  == 'dat'
	   && docuRef.RefTableId    == tableNum(PurchTable)
	   && docuRef.RefRecId      == purchTable.RecId;
	   && docuRef.TypeId		== 'My note type';
	   
info(docuRef.Notes);
7

Thanks!

Best regards,

Roberts