News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Get all note attachmen...

Finance | Project Operations, Human Resources, ...

Unanswered

Get all note attachments of sales order based on a specific type of attachment

(1) Share

Report

Report

Posted on by Jason0810M

Hello,
I am trying to concatenate all note values of docuref of sales orders.

I have a custom field on the docutype which needs to be set to Yes to work.

My request is as follows:
while select Notes from docuRef
join RecId from docuType
where docuRef.RefRecId == salesTable.RecId &&
docuRef.RefTableId == salesTable.TableId &&
docuRef.RefCompanyId == salesTable.DataAreaId &&
docuRef.TypeId == docuType.TypeId &&
docuRef.ActualCompanyId == docuType.DataAreaId &&
docuRef.Notes != '' &&
docuType.XXXCustomField == NoYes::Yes
               {
               stringValue += docuRef.Notes;
               }

The sales table record has a value when debugging.

However, the while loop is not being executed.

I have run a T-SQL statement for the record and it is returning records in MSSQL.

All responses Img

All responses (2)

Answers Img

Answers (0)

Jason0810M on at

Like (0)

Report

Get all note attachments of sales order based on a specific type of attachment

Hello Andre,

I have removed the condition DocuRef.Notes != ''.

I have an if condition inside the while loop and it seems to be working fine now.
André Arnaud de Cal... 291,861 Super User 2024 Season 2 on at

Like (0)

Report

Get all note attachments of sales order based on a specific type of attachment

Hi Jason0810M,

Can you tell where exactly you added this coding? Is the debugger hitting the while select statement or is your code skipped at all?

Have you tried taking out the condition DocuRef.Notes != '' and have an additional if-statement to check for contents before filling the stringValue variable?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2

Martin Dráb 230,540 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans