The following NetSuite application is available to all active Prolecto Resources clients without license charge. Click here to get back to the bundle list.
Prolecto Query Renderer
Provides the ability to define NetSuite SQL (SuiteQL) queries, and render results in a variety of ways, with convenient features for linking queries to other queries or records.
Bundle ID
Ask for Bundle ID: 379607.
Version History
20251229.RC
- Added the ability to control which links to include in the email (individual PDFs, combined PDF, and ZIP download).
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.
20250812.RC
- Added the capacity to trigger a bulk record updates from query results. It leverages the existing utility for updating records from query.
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.
20250123.RC
- Added new options for background script processing, allowing one to select a different script to be notified when the query completes.
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.
20240112.RC
Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.
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.
20231006.RC
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
20230906.RC
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Added the ability to control which links to include in the email (individual PDFs, combined PDF, and ZIP download).
- 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.
20250812.RC
- Added the capacity to trigger a bulk record updates from query results. It leverages the existing utility for updating records from query.
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.
20250123.RC
- Added new options for background script processing, allowing one to select a different script to be notified when the query completes.
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.
20240112.RC
Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.
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.
20231006.RC
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
20230906.RC
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Added the capacity to trigger a bulk record updates from query results. It leverages the existing utility for updating records from query.
- 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.
20250123.RC
- Added new options for background script processing, allowing one to select a different script to be notified when the query completes.
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.
20240112.RC
Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.
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.
20231006.RC
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
20230906.RC
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Added new options for background script processing, allowing one to select a different script to be notified when the query completes.
- 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.
20240112.RC
Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.
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.
20231006.RC
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
20230906.RC
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
Bug fix: Added missing artifact required for the Print feature introduced in the previous version (20231226.RC) to work.
- 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.
20231006.RC
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
20230906.RC
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Option to hide query running in the background.
- Reset criteria on the renderer page.
- Display bundle version in the title bar
- Resolve error on double-down error downloads.
Option to avoid allowing query results downloads.
20230831.RC
Added total columns to NetSuite SuiteQL pivot results
20230516.RC
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
Added total columns to NetSuite SuiteQL pivot results
- Refine messaging when queries return zero results.
- Moved query execution references from Employee to Entity.
20230413.RC
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
20230316.RC
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Minor revision for handling automatic totals.
- Inclusion of Verify Bundle Installation Utilities
Ability to Submit Queries for Background Execution resulting in CSV output.
20230127.RC
- Scheduled execution and saving of results into a file cabinet.
20221230.RC
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Scheduled execution and saving of results into a file cabinet.
- Support for JQuery DataTable for HTML rendering for enhanced paging, formatting and filtering
- Enhanced default CSS
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.
20220922.RC
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
When rendering a query on a record, allow the ability to use a function on the subttab name such as sum({myfield}).
20220902.RC
Added ability to schedule query definitions to email SQL query results to mimic features provided by native NetSuite Saved Search.
20220810.RC
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Add Hide filter option for better IFrame presentation.
- Options to display with or without NetSuite navigation system.
- Enhanced form lookup logic when passed cf URL parameter
20220712.RC
Ability to render a NetSuite SQL query in an IFrame.
20220620.RC
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
Ability to retrieve the finished HTML so that the results can be stored versus displayed.
20220124.RC
Enhancement for user event script for rendering query on records.
20211227.RC
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
- Refinements for validation
- Helper utilities to confirm deployments are set up correctly
- Refinements when "More' links are offered
- Enhanced documentation.
20211102.RC
Additional revisions to support new client requirements.
20210924.RC
Revisions to support new client requirements.
Revisions to support new client requirements.
Obtain Access to Prolecto Query Renderer Bundle
If this Prolecto Query Renderer bundle has interest for you, make a request and let's have a conversation.
