November 14, 2020

SuiteScript Example – Rendering Query Results in a PDF

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:



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

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Related posts

March 3, 2021

Does the physical location of a competent employee change the amount of value they can deliver for your organization? If it does, I’d be keen to hear your story. If it does not, why ...

Read More

March 2, 2021

Today a friend and former colleague of mine – who happens to now be in a development leadership role for a NetSuite partner – was lamenting the extreme difficulty of finding and hiring NetSuite ...

Read More

March 1, 2021

Software is never finished; clients are always changing and re-prioritizing. NetSuite is ever a moving target – always updating and evolving. Market forces are always shifting and shoving, forcing new demands on your business. ...

Read More