How to get a join field's value from a search results object in Advanced PDF Templates

AI generated answer (using internal Slack threads):

To get a join field's value from a search results object in Advanced PDF Templates, you need to ensure that the join field is included in the search results. In SuiteScript, you can use the

nlobjSearchColumn

function to include join fields in your search results. Here's an example of how you can include a join field in your search results:

javascript
var columns = [];
columns.push(new nlobjSearchColumn("externalid", "item")); // "item" is the join id

In the above example, "externalid" is the field id and "item" is the join id. This will include the "externalid" field of the "item" join in your search results. Once you have included the join field in your search results, you can access it in your Advanced PDF Template using the following syntax:

html
${result.externalid}

In the above example, "externalid" is the field id of the join field. This will display the value of the "externalid" field of the "item" join in your Advanced PDF Template. Remember to replace "externalid" and "item" with the actual field id and join id that you want to include in your search results and display in your Advanced PDF Template. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******