![]() ![]() If testing goes well, and the feedback is positive, then I'll officially release the tool in a week or two. To set it, look at the "toolUpgradesEnabled" value in the script.) (The tool upgrades function is enabled by default. However, if you're already running the first beta, and have "tool upgrades" enabled, you can use the tool's built-in upgrade function. SuiteQL Query Tool Version 2021.2 Beta 2 is available for download by clicking here. When the table is wide (meaning, it consists of a large number of columns), the table is horizontally scrollable. That means you can now search against those tables, and more easily find what you're looking for - especially in tables such as Entity, Employee, and Transaction, which include a lot of columns, and join to a lot of other tables.Īnd one additional UI improvement worth mentioning has to do with the way that the query results table is displayed. You'll also find that I've added Datatables support to the Columns and Joins tables in the Tables Reference. It also helps when you're working on a PDF / HTML document. Hiding the Query Editor frees up space to display additional query results. There's a new button that you can use to hide or show the Query Editor area of the app. This will very likely change as I continue working on the project.Īs I mentioned earlier, this release also includes a few improvements to the UI. In the meantime, here's a screen shot showing the interface in its current form. I'm hoping to release the Document Generator sometime this Fall. ![]() You can also include data from external systems by setting up RESTlets to pull the data. The application can be used to dynamically generate PDF and HTML documents based on data from a variety of sources, including SuiteQL queries, saved searches, and records. The new PDF and HTML Document Generation function is based on another solution that I have been working on, a project that I've been calling the "Document Generator." (Yeah, I know. The query and template that I used in the example are included at the end of this post. Here's an example, where I'm merging the results of a query against the Employee table with a simple PDF template. If all goes well, a new browser tab (or window) will open, and the generated document will appear. Then click the "Generate Document" button. A new "Template Editor" area will appear, in where you can enter your PDF or HTML template. To use the feature, enter a query as you normally would, and then select either "PDF" or "HTML" from the "Format Results As" field. (BFO and FreeMarker are two of the technologies that the Advanced PDF functionality is built on.) There are also buttons available so that you can easily view BFO and FreeMarker resources. If not, I'm planning to provide examples in the coming weeks, which should help bring you up to speed. If you're familiar with Advanced PDF templates, then this new function will likely be easy for you to put to use. These options give you the ability to generate PDF and HTML documents based on the results of a SuiteQL query and an advanced PDF/HTML template. This version of the SuiteQL Query Tool supports two new results formats: PDF and HTML. They can provide clues with regards to the tables and columns that you're looking for, as well as how various tables are joined. Regardless, it is interesting to see the underlying queries of some of the workbooks. ![]() I believe this has to do with the use of functions that SuiteAnalytics uses, and that we don't yet have access to (yet). That being said, in many cases the query that is loaded from a workbook will not run properly. (To be more specific, I'm waiting for the N/dataset SuiteScript module to reach General Availability status, which is expected to be in late September.) This is an experimental feature, and will evolve in future releases. The tool will then load the workbook, extract its query, and load the query into the query editor. To load a workbook's query, you simply click the new Workbooks button, select a workbook from the list, and click the Load button. The tool now supports importing the SuiteQL queries that power SuiteAnalytics Workbooks. With this release, I've added a couple of new features, as well as a few interface enhancements. For information about the first beta, please click here. This afternoon I released the second public beta of the NetSuite SuiteQL Query Tool v2021.2. ![]()
0 Comments
Leave a Reply. |