GetSaleDocuments renders no results

Hi John,

I believe those are only documents that have been linked to the sale via the Links tab on a Sale. Using CRMScript, you can use the archive agent to search for the documents you want based on the saleId. Here is an example:

NSArchiveRestrictionInfo[] restrictions;
NSArchiveRestrictionInfo res1;
res1.SetName("sale/saleId");
res1.SetOperator("=");
res1.SetValues(String("35").split(","));
restrictions.pushBack(res1);

NSArchiveOrderByInfo[] order;
 
String[] entities = String("document").split(",");

Integer pageSize = 250;

NSArchiveAgent archiveAgent;
NSArchiveListItem[] rows = archiveAgent.GetArchiveListByColumns("simpledocument", String("documentId,sale/saleId").split(","), order, restrictions, entities, 0, pageSize);

foreach (NSArchiveListItem row in rows)
{
  Map rowData = row.GetColumnData();
  Integer documentId = decodeDBValue(rowData.get("documentId")).toInteger();
  Integer saleId = decodeDBValue(rowData.get("sale/saleId")).toInteger();
  printLine("Processing document with id '" + documentId.toString() + "'");
}

Hope this helps!

Hi,

Thank you for swift answer.

The Documents were added by New -> Document and adding them to the Sale

So they are added to the Sale. They fit the definition of the function:

Or how do you add documents to a sale that you can get by using GetSaleDocuments? 

Hi John,

Actually no, the way you added the documents does not fit the definition of the function.

Linking a document to a sale is done via the Sale Links tab.

Adding a document (creating a document entity) and having it appear as a document activity is not the same thing as a Linked document.

Hope this helps.

Hi,

Thank you for clearing that out! 

I will do some tests. 

Have a nice weekend!