Is it possible to dot walk a DocumentID type field in an Email notification ?


Description

Is it possible to dot walk a DocumentID type field in an Email notification ? 

Problem

How to reference a Document ID type field that is associated with a linked table in the body of any notification when the linked table is not known.


Resolution

The Document ID field references any record on any table, therefore you need to check what is the associated table.

 

  • Go to Dictionary
  • Search for the DocumentID field: "document_id" in the columns
    • Verify which table name this is associated with. For example table [sysapproval_approver], the source field contains the table name it is associated with. 
    • It is the Document ID record that contains the source table.

 

 

 

 

  • For example,  open up a sample record in the [sysapproval_approver] and show the XML source view
<document_id>41cdb152db252200a6a2b31be0b8f527</document_id>
<source_table>change_request</source_table>

 The source table is [change_request]

Therefore the "DOT WALK" notation with that document ID will pull in all fields related to the change_request table and other linked fields.

Note: The actual name of the source table is not shown in the dictionary entry.