With the advent of Analytics Workbooks and the N/query module, NetSuite has also added a method for rendering your query results within your PDF templates. Let’s say you have a function to define your query, like so:

Notice we don’t actually run the query; we just create the Query
instance. From there, we can leverage a TemplateRenderer
from the N/render
module and its addQuery()
method, like so:

where ./custom-query.ftl
(our custom template) contains a section like this:

The templateName
we specify in addQuery()
is the same variable name we use within our template to access the query results; in our example, that’s individuals
. From there, we can loop through (#list
) the results, and we access values from individual columns with Array indexes (e.g. ind[1]
). The order of the columns in the template is the same order in which they were defined when we created the Query.
Combining all those components renders a PDF like so:

HTH
-EG
This is an example from the Rendering PDFs with SuiteScript Cookbook.