Count Links

117320

Hi All,

How can I count how many Links on a document from C/AL code?

If I open the form(my attachment) manually, I can see there are 2 links.

Luc_VanDyck

Count the number of records in table 2000000068 "Record Link" for the given record.

117320

Hi Luc,

I want to count by per document.

If possible, please advise me the code.

Thank you

lubost

Hi,

Table "Record Link" is based on RecordID and the main part of RecordID is the table part. RecordID field can not be filtered directly and you have to use some trick:

RecRef := YourRecord.GETTABLE;
RecordLink.SETFILTER(RecordID, '%1', FORMAT(RecRef.ID));

and now you are able count resulting recordset.

117320

Hi Lubost,

thank you for the code, appreciate it. It work with some modification :

RecRef := YourRecord.GETTABLE;
RecordLink.SETRANGE(RecordID, RecRef.RECORDID);

tinoruijs

Just 'discovered' Notes are record links of type Note.
So I just added this to count the notes.

RecordLink.SETRANGE(Type, RecordLink.Type::Note);