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

(1) Share

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 (2)

Answers (0)

Sort by

André Arnaud de Cal... 307,893 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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?
Jason0810M 8 on at

Like (0)

Report
Copy link

Link copied!

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.