The Prolecto Query Renderer provides the ability to define NetSuite SQL (SuiteQL) queries to render results in a variety of ways, with convenient features for linking queries to other queries or records.

As an alternative to NetSuite's analytical workbooks, users can get control to create user-driven reporting, data export, printing, and rendering like saved search.

Build ID 144

Version: 20251229.RC

• Added the ability to control which links to include in the email (individual PDFs, combined PDF, and ZIP download).

---

Version: 20251112.RC

• Mass Print PDF Utility Enhancements: Added support for specifying the subject and the body of the email in addition to the sender and recipient which are already supported.
   

---

Version: 20250812.RC

• Added the capacity to trigger a bulk record updates from query results. It leverages the existing utility for updating records from query.

---

Version: 20250507.RC

• Send Query Results Scheduled Script Enhancements: Added bcc and reply parameters as well as auto-conversion of new lines in the body to the corresponding HTML tag.
• Added header and byte prefix to download file to help Excel when file contains special characters.
   

---

Version: 20250123.RC

• Added new options for background script processing, allowing one to select a different script to be notified when the query completes.

---

Version: 20240805.RC

• New Scheduled Script for Mass Printing: Expands on the feature added in 20231226.RC for mass printing, by allowing it to be done via a scheduled script deployment rather than in the UI.
   

---

Version: 20240112.RC

Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.

---

Version: 20231226.RC

• Added the ability to use Query Renderer to Mass Print PDFs, using both native Advanced PDF Templates, or CRE2.
• Added a more powerful totalling feature, including the ability to use formulas in totals. 
• Added a feature to allow you to define defaults for filters, including the ability to use date math for dates, and queries to select a default dynamically.

---

Version: 20231006.RC

1. Option to hide query running in the background.
2. Reset criteria on the renderer page.
3. Display bundle version in the title bar
4. Resolve error on double-down error downloads.

---

Version: 20230906.RC

Option to avoid allowing query results downloads.

---

Version: 20230831.RC

Added total columns to NetSuite SuiteQL pivot results

---

Version: 20230516.RC

1. Refine messaging when queries return zero results.
2. Moved query execution references from Employee to Entity.

---

Version: 20230413.RC

• Minor revision for handling automatic totals.
• Inclusion of Verify Bundle Installation Utilities 

---

Version: 20230316.RC

Ability to Submit Queries for Background Execution resulting in CSV output.

---

Version: 20230127.RC

1. Scheduled execution and saving of results into a file cabinet.

---

Version: 20221230.RC

• Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
• Enhanced default CSS

---

Version: 20221006.RC

Provided an easy way to generate a TOTALS row by specifying literal text, or function name, in new TOTALS ROW column on the “Columns” tab.

---

Version: 20220922.RC

When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).

---

Version: 20220902.RC

Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.  

---

Version: 20220810.RC

1. Add Hide filter option for better IFrame presentation.
2. Options to display with or without NetSuite navigation system.
3. Enhanced form lookup logic when passed cf URL parameter   

---

Version: 20220712.RC

Ability to render a NetSuite SQL query in an IFrame.

---

Version: 20220620.RC

Ability to retrieve the finished HTML so that the results can be stored versus displayed.

---

Version: 20220124.RC

Enhancement for user event script for rendering query on records.

---

Version: 20211227.RC

• Refinements for validation
• Helper utilities to confirm deployments are set up correctly
• Refinements when "More' links are offered
• Enhanced documentation.

---

Version: 20211102.RC

Additional revisions to support new client requirements.

---

Version: 20210924.RC

Revisions to support new client requirements.

---