Version 18.51 (02/16/2023)
- Merged changes that allow rendering running quickapps by tag number in quickapp.k.
Version 18.49 (10/27/2022)
- Bug fix to display the available memory level in the Dashboard correctly.
Version 18.48 (10/20/2022)
- Bug fix for login activity not displaying in the logger.
Version 18.47 (09/23/2022)
- Bug fix that prevents the AQI from dropping some requests.
Version 17.43 (12/02/2021)
- Fix for 400 error when a query against a physical table returns 0 results.
Version 17.41 (11/04/2021)
- Added <merge ... materialize="1" path="[PATH]" virtual="0"/> support for exattr values with stripe and stripe_factor. If an exattr with stripe (or stripe_factor) exists in tables being merged, the minimum stripe (or stripe_factor) is used in the exattr of PATH. If no stripe exists in any table, but a minimum stripe_factor that is strictly smaller than 1.0 exists, and if the user can upload to more than one mach, a stripe of 2 is set in the exattr PATH.
- The combine_tabs call will remove segby from exattr in its result, should any constituent table contain it. It will include the minimum stripe and/or stripe_factor from the constituent tables if those attributes exist in at least one table. If the resulting exattr contains stripe_factor but no stripe, then a stripe=2 (which in conjunction with stripe_factor indicates a minimum value) will be added to the resulting exattr.
Version 17.39 (10/15/2021)
- The format string option padwith: may now be used along with numeric (such as num, commas, pct, currency) and text (char) formats (not date/time etc.) to specify that the displayed value should filled or "padded" out to the column width with a particular character or sequence. Alternatively, padto: may also be specified, in which case the value may be padded to fewer characters than the full column width. Furthermore, a negative value for padto: specifies padding on the right.
- The format string option locale: may now be used to modify the display behavior for numeric, date, and date+time values, overriding user preferences. The currently valid values of locale are US, UK, EU, and INT; other locale specifications may be added in the future.
- The format string attribute type:months may now be used to specify that an integer value is to be construed as a year-to-month interval representing a whole number of months and displayed broken down as years and months. Also, the format string attribute type:days specifies that a floating-point value is to be construed as a day-to-second interval representing a possibly fractional number of days and displayed broken down as days, hours, minutes, and (possibly fractional) seconds. The dec: option specifies the number of digits shown after the decimal place for seconds, and defaults to 0. Also, supplementing the existing type:datehms24 as a format type for timestamps (date+time values), it is now possible to specify type:datehms12, type:date4yhms24, and type:date4yhms12.
Version 17.33 (06/10/2021)
- Attempting to display a table containing a ragged string column in single-row view yielded a “valence” error; this has been fixed.
- The new attribute insertxml_= can be supplied to <widget> and takes either an XML value (or list of XML values) or a string value representing XML. The XML is used as the body of the widget.
- The GUI Table Downloader tool (as well as the Save Table and Save for FTP tools) now properly handle queries containing <import> exported from, for example, MLW or TRS.
- Table-valued functions may now be polymorphic (have multiple argument signatures) and nulladic (zero arguments is a valid signature).
- <do action_="sql"> offers new functionality related to table-valued functions (parameterized views or “stored procedures”). You can specify a definition of a table-valued function with <do action_="sql" add_="tvf">. You can also delete a table-valued function, list TVFs and signatures, and get a TVF or signature.
Version 16.49 (02/25/2021)
- Improved communication between TRS/MLW and the CSV/XLSX/PDF file export tool.
Version 16.47 (02/04/2021)
- Fixed display of User Groups in the User Manager.
Version 16.42 (12/03/2020)
- Allow logo to be repositioned through gui2 preferences.
Version 16.41 (11/19/2020)
- Fixed Create/Save Multiple Users functionality in the User Manager.
Version 16.40 (11/12/2020)
- Fixed default behavior on double-clicking query in Object Manager when preference is not set.
- Fixed unevaluated dynamic variable presented in the Object Manager after searching for and then double-clicking a folder.
- Improved error messaging for error within unquoted query tag.
Version 16.39 (11/05/2020)
- Fixed misaligned cross-tabulation headers when there are so many row breaks that columns need to be unfixed.
Version 16.38 (10/22/2020)
- Fixed a typo that was breaking API2.
Version 16.37 (10/16/2020)
- Temporarily removed menu option for Focused Mode, since it is not launching with v16.
- /api/ep?_fmt=xyz can now be used instead of /api/ep:xyz to specify output format.
- add /api/ep/@ syntax to explicitly request the widget status table when ep contains an index widget. Also, /api/ep/.w is now the preferred syntax for fetching widget w. /api/ep/@w still works for now, but should be considered deprecated.
- Fixed extraneous _path value in HTML UI links.
- Fixed path for the 1010data logo in Windowed Mode and Focused Mode, so they work under quickapp.k.
- Fixed the terminal widget and thus the K3 and JS consoles for x1010 users.
- Implemented <widget class_="bokehchart" type_="geograph">. This widget provides interactive continental USA and Mexico map charts. (Available through Macro Language Workshop only for now.)
Version 15.40 (9/10/2020)
- Symbol values in packages and lists are now no longer treated differently from string values. It is still good practice when using such a value to specify that you want to construe it as a string (by using @$foo instead of just @foo) but it should no longer be strictly necessary. Also, {} is construed as the empty list (such as {lst()}) and {:} is construed as the empty package (such as {pkg(;)}). These changes are intended to make it more convenient to use the existing short-form list and package literal syntax. For example, you can write {'foo','bar','baz'} instead of {lst(’foo''bar''baz')} and {a:'foo',b:‘bar’,c:‘baz’} instead of {pkg(’a''b''c';'foo''bar''baz')}.
- In XML views, list and package values in XML attributes are now represented explicitly. Previously, the attributes were simply omitted; now they are converted into the short-form literal syntax where lists are represented as {value1, value2, value3, …} and packages as {key1:value1, key2:value2, key3:value3, ...}. This prevents the situation in which a converted legacy PQQ is edited in XML without replacing omitted attributes, then resaved or reexecuted, leading to an error.
- In TRS view-only mode, when a legacy PQQ is run, it will now be consolidated automatically after conversion. Also, an error condition resulting from consolidation of a converted legacy PQQ that begins with a non-strict legacy parameterized drop-down selection has been corrected.
- In TRS view-only mode, execution of the partial timeline is delayed as long as possible to shift wait time from before to after parameter entry whenever possible (such as when the partial timeline is not used to generate options for parameter entry).
- In TRS view-only mode, once data is displayed, a new Open TRS timeline icon is displayed on the right side. Clicking will open a full TRS with the timeline displayed and ready to do further analysis.
- The default Object Manager action for both QQs and legacy PQQs is to run the query in TRS ("view-only" mode), rather than the Query Runner. Running in TRS view-only mode can now be chosen as an association for queries in Workspace Settings. (The Query Runner will be considered deprecated in V16 as equivalent functionality should now be present in TRS view-only mode.)
- In a Simple Select panel, submission of an “is one of” or similar comparison is no longer possible when no values are entered in the taglist field. This prevents the error that formerly occurred after submitting such a comparison.
- When a legacy PQQ is opened in MLW, parameterization annotations will now be shown in their respective XML attributes (with the same [[ \ \ ... ]] syntax as used in Edit Actions (XML) in the old interface). The XML can be edited and resaved with the annotations, thereby preserving (or even modifying) legacy parameterization. Legacy parameterization for the <block> and <insert> operations is also preserved. This is an enhancement over the old interface, which did not represent block parameterization in Edit Actions (XML).
- Within a block’s <declare> section, each <param> tag may take an optional require="expr" attribute, where expr should be a Boolean expression (generally in terms of the parameter @variable). The expression does not need to be surrounded in curly braces. For example, <param name=”foo” label=”Foo” type=”string” require=”@foo<>''“/> declares that the block parameter foo should be a non-empty string.
- When constructing an op panel GUI for a <block> that declares at least one parameter with a require= condition (see previous change), the panel will not permit submission of the block (submit buttons will be dimmed) unless all such require= conditions are satisfied. This is equivalent to using @trs_ready in a custom GUI declared in the <trs> section of <declare>.
- When a simple selection operation is parameterized using direct value entry and with the Allow this selection to be bypassed option unselected, the parameter declaration require condition capability (see previous change) is now used to prevent an empty selection value from being submitted. When the Allow this selection to be bypassed option is selected, an empty selection is permitted (as before) and causes the selection to be bypassed.
- When a legacy PQQ is converted to a parameterized timeline and it contains a selection parameterized with Text, Required, the declaration require condition capability (see previous change) is now used to prevent an empty selection value from being submitted. When the selection is parameterized with Text, Opt-out (or Opt-in) an empty selection is permitted (as before) and causes the selection to be bypassed.
Version 15.39 (8/13/2020)
- New tables added to the db tree now get () instead of _n for their ops0 field, preventing a type error when manually opening the table in TRS.
- The delay before the progress bar appears in the user interface has been increased to 2 seconds.
- Legacy PQQ conversion will now occur whether a PQQ is opened directly by the user from within TRS, or via a GUI 2.0 sentence, such as the Object Manager. Futhermore, a parameterized timeline will now have all steps loaded into TRS when opened, whether from within TRS or the Object Manager. The Object Manager option to open a query in TRS has now been renamed to "Open in TRS" from "Open results in TRS" to reflect this change.
- The taglist widget for entering multiple values in parameterized timelines is now height-limited. A scrollbar will appear if there are many input values.
- It is now possible to add a legacy PQQ to Favorites.
- When advancing through a TRS timeline with the "play" button, and when a query is loaded "hot" into TRS, if a link or merge operation contains parameterized operations, rather than popping up a new TRS for the worksheet, the timeline will dive into the worksheet, then surface back to the main timeline when the user has advanced to the end of the worksheet. This will facilitate a more intuitive sequential workflow.
- It is now possible to open a legacy parameterized quick query (PQQ) in the initial file browser of TRS. Parameterized operations, including operations in nested worksheets, are converted into parameterized blocks in the timeline. Currently, the PQQ must be opened from within the initial file browser of TRS in order to take advantage of this new functionality.
Version 15.37 (6/5/2020)
- Fixed issue where <tcol="ucnt"> (or other "count" functions such as ucnte and valcnt) was not always properly promoted to floating point in tables of greater than 2 billion rows.
- Added Training to the Help menu in regular and Focus mode. This selection takes you to the Lessonly login screen.
Version 15.36 (3/12/2020)
- The background wallpaper is no longer version-specific.
Version 15.35 (3/5/2020)
- The following fixes for the SQL engine: multiple complex aggregate functions no longer give the same result, IN(list,of,string,expressions) no longer fails when expressions are not string literals and typo in TIMEOFDAY() function is now fixed.
Version 15.34 (2/27/2020)
- Added the following functions:
isodayofwk(X) - Returns the ISO-8601 day of the week for date or timestamp X.
isoweek(X) - Returns the ISO-8601 week-numbering week for date or timestamp X.
isoyear(X) - Returns the ISO-8601 week-numbering year for date or timestamp X.
Version 15.33 (2/20/2020)
-
The New operation panel of TRS will now display only operations from the Basics and Miscellaneous categories by default. The operations in the Retail category will no longer display by default. The trs_op_categories user preference must be set to re-enable the Retail category.
-
Improved the behavior of the link panel in TRS when included/excluded columns have been customized via the cols attribute of a query. Previously, the customized cols attribute was being ignored.
Version 15.32 (2/13/2020)
- By default, the public schema now contains tables (mapped to default.empty, default.lonely, and default.test.solar).
- Added the following functions:
dayofyr(P) - Takes a date or a timestamp and returns the number of its day in the year. For example, dayofyr(20191225)=359, while dayofyr(20201225)=360, because 2020 is a leap year.
trunc(X;Y) - This function is similar to round(X;Y), but instead of rounding X to the nearest multiple of Y, it always rounds in the direction of 0 (down if X is positive, and up if X is negative). For example, trunc(1234.567;0.1)=12345.5, while round(1234.567;0.1)=1234.6, and trunc(-1234.567;0.1)=–12345.5, while round(-1234.567;0.1)=–1234.6.
atan2(X;Y) - This function calculates the conventional 2-argument arctangent function (equal to atan(x/y)) when Y is positive, and arbitrarily defined as 0 when both X and Y are zero.)
Version 14.44 (12/26/2019)
- Fixed params bug for the case where <merge> without ops has a filter that references @params_.
Version 14.42 (12/5/2019)
- Removed "width" column format information from data renderer. This means that having columns with "format=width:40" will no longer be formatted with spaces to achieve that width in the output of the data renderer.
Version 14.43 (12/12/2019)
- Rollups are now working properly in the tabulation panel.
Version 14.42 (12/5/2019)
- Removed "width" column format information from data renderer. This means that having columns with "format=width:40" will no longer be formatted with spaces to achieve that width in the output of the data renderer.
Version 14.38 (10/24/2019)
-
Several aesthetic adjustments to the launch bar and Object Manager, including:
- The launch bar now dims along with the rest of the GUI when an action such as the Save dialog box appears.
- When the launch bar is permanently made visible via the Workspace Settings and then a window is launched, the window no longer renders behind the launch bar.
- Adjusted the metadata screen in the Object Manager so that the Users text area no longer lays on top of the Long Description text area.
- Tooltips in the launch bar now display the entire option instead of just the first word.
Version 14.37 (10/03/2019)
-
"Compatibility Mode" has been deprecated.
-
Option added to the workspace preferences panel to always show the launch bar.
-
Overhauled the lineup widget, adding the following new functionality:
- Inner queries now support positional (as opposed to named) data columns, like most other widgets.
- A label column is no longer required, since it is more convenient in some situations to use names as labels.
- Tooltips are now customizable, making them more useful for situations where a user is manipulating something other than 1010 columns.
- Updates to itemsvalue_ will now trigger a refresh of the widget, as is conventional for value_ attributes.
- Some error messages have been made more clear, and several common mistakes which were producing untrapped error messages will now result in relevant ones.
-
Generalized the worksheet link/merge procedure, allowing Trillion-Row Spreadsheet and Macro Language Workshop instances to freely reference one another as "worksheets".
Version 14.36 (09/19/2019)
-
Updated xlsx and data render targets to perform the same functionality for the extend_umbrella_ attribute on nest widgets as the web target.
Version 14.35 (09/12/2019)
-
Integrated a total rewrite of the taglist widget. This introduces maxcompletions_, inputheight_, and delimiters_.
- The inputheight_ attribute (optional) accept a number of pixels for the vertical size of the widget's input area. If there is not room to display the current tags, this area will scroll.
- The maxcompletions_ attribute (1000 by default) will cap the number of options used for this constraint.
- When text is pasted into this widget, it is automatically split into tags based on the optional delimiters_ attribute, which by default is "\n\r ". Each character in the delimiter is considered in turn. If that character exists in the input it is used to split the pasted text; otherwise the next character is considered. The space character in this list is treated as a match on any number of any whitespace characters.
-
Improved the default behavior for included/excluded cols in a link, and simplified the emitted query.
-
Simple selections now provide a date picker for columns with month formats.
Version 14.33 (08/22/2019)
-
The buildgrid widget now exposes a boolean attribute show_metadata_ which, if true, will display metadata rows by default. Metadata rows are now additionally shown as fixed rows at the top of the table as a user scrolls vertically. The Table Editor tool opts into this feature, so metadata rows will always initially be visible.
Version 14.29 (07/22/2019)
-
Integrated the Image Encoder gadget for generating image URIs for use with static renderers. This tool can be launched by dragging and dropping image files ( png, jpeg, gif) onto the workspace.
-
The XLSX static renderer now handles data URIs.
Version 14.28 (07/15/2019)
-
Workspace settings are now correctly applied on startup.
-
It is now possible to export tables which contain 0 rows.
-
Added a new standard table, default.test.json. This contains columns with various JSON payloads as strings, permitting easier experimentation with both JSON and (via dejson()) packages in a vector context.
-
The expression widget now treats the magic columns i_() and ii_() as functions, to reflect their optional base argument. Completion no longer creates a malformed expression with a B placeholder.
-
Introduced pkg_default(P;K;D) function.
-
Repaired several broken features in the Debug menu, notably "Clear caches then render".
-
TRS in viewonly_ mode now displays error messages appropriately if the underlying query fails.
-
Fixed a problem where converted PQQs were not being given an explicit <base> op.
-
Integrated the new and improved 2-way-bound scope widget.
VERSION 14 PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the production release of the 1010data Insights Platform Version 14, see Release Notes.Version 13.47 (03/21/2019)
-
The delay associated with a tooltip_ on any widget or layout can now be configured via the optional tooltipdelay_ attribute. Like the hintdelay_ attribute on some existing widgets, tooltipdelay_ takes a non-negative floating point number of seconds by which to delay before the tooltip appears.
Version 13.45 (02/21/2019)
-
Adjusted tabu so that performing a rollup with no tcols no longer results in a rank error.
Version 13.44 (02/14/2019)
-
Addressed race condition observed in ggrid when scroll events are interleaved with a widget refresh. It will now deal more gracefully with this case instead of throwing an index error.
-
Updated all application favicons to a new style, including the animated favicons during query progress.
-
The ggrid column header context menu button is now on the left side of the header instead of the right side, to make it accessible if a column is partially scrolled off to the right.
-
The ggrid context menu now includes an option "Copy name", which copies the selected column's name to the clipboard.
-
The splitter layout now calls resize handlers for widgets such as ggrid inside of it so it properly resizes.
Version 13.43 (02/07/2019)
-
Adjusted tabu so that performing a rollup with no tcols no longer results in a rank error.
Version 13.42 (01/24/2019)
-
Fixed an issue with the "Open in Standalone" option in the object manager, which had been causing an error when double clicking on an object with the association set to standalone.
-
Added code to handle edge cases for tabpanels inside of windows and fix tabpanel sizing issues.
Version 13.41 (01/17/2019)
-
The merge operation has been re-enabled in the timeline's new op panel.
-
The "quick stats" menu options in the grid context menu have been disabled; these features are not available yet in Macro Language Workshop.
-
Quick Analysis panels now work properly if the parent Trillion-Row Spreadsheet window is closed.
VERSION 13 PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the production release of the 1010data Insights Platform Version 13, see Release Notes.Version 12.51 (09/20/2018)
-
Empty <tabu fun=ucnt/> is now consistently integer typed.
Version 12.50 (09/13/2018)
-
The GUI menu item "admin / user profile" is now available to all users.
Version 12.49 (08/30/2018)
-
Standalone quickapp runner now properly sets the session cookie on login.
Version 12.48 (08/16/2018)
-
Fixed the ggrid "quick fit width" feature in MLW.
Version 12.43 (07/12/2018)
-
There is now a preference called custom_css, which can contain custom CSS rules for styling the GUI.
Version 12.42 (07/05/2018)
-
Added usergroupdata('UID') scalar function. Returns a comma separated list of the groups a the 'UID' is a member of. Includes direct membership as well as transitive membership.
<willbe name="mygroups" value="usergroupdata('my_uid')"/>
Version 12.41 (06/28/2018)
-
Updated the items in the Help menu by grouping similar items into sub-menus. Additionally, removed the Interactive Reference option.
-
Fixed an issue rendering quick queries where the quick query was not the base table and operations were present. A broader range of quick queries can be rendered as a result.
-
Fixed an issue that caused <widget class_="dropdown"> to fail if the break_ attribute was used.
-
Updated <widget class_="dropdown">and <widget class_="dropdownlist"> to re-render (instead of refresh) when their configuration changes.
-
Fixed an issue that caused duplicate tray entries if Always show window tray at bottom was selected.
Version 12.40 (05/24/2018)
-
Removed stray text reading "hello" from the template for standalone quickapps.
-
Fixed an issue with tabulations on empty tables causing a type error.
Version 12.39 (04/12/2018)
-
Updated the alt text of the Find icon from "Search this table..." to "Find rows". Additionally, updated the alt text of the Close icon from "Hide search dialog" to "Hide the find dialog".
-
The <widget class_="dropdownlist"> attribute rowvalue_ now preserves the order of the selections.
Version 12.38 (04/05/2018)
-
Updated the documentation links to point to the Prime version of the Documentation Center.
-
Removed the Spreadsheet and Macro Language views from the View panel.
-
Internal bug fixes and improvements
Version 12.37 (03/29/2018)
-
Added support for display format nocommas to the bigint data type.
-
Fixed an issue that caused tables with 0 rows and a bigint column in a link produced a type error.
-
Fixed an issue with indexed bigint data producing type errors.
-
Added various updates for <widget class_="dropdown"> and <widget class_="dropdownlist"> including:
-
The <disabled> attribute produced an error instead of updating if <serverfilter_="1">.
-
<widget class_="dropdownlist"> with <serverfilter_="1"> was unable to retrieve data due to special characters.
-
The <hints_> attribute now accepts both <1> and the name of the column.
-
Fixed how <widget class_="dropdownlist" breaks_=""> columns interact with sorting. If the groups defined by the breaks column are mixed together, the Insights Platform attempts to preserve the original order as much as possible, with the exception of re-arranging by group.
-
Fixed an issue with the <widget class_="dropdown"> attribute serverfilter_ that caused an error when the variable, whose name is in the attribute, was populated instead of being set to "".
-
Version 12.36 (03/22/2018)
-
Deprecated the Amend by expression option from the More menu in the New Operation panel. This functionality is now available in the New Operation as Amend.
VERSION 12 PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the production release of the 1010data Insights Platform Version 12, see Release Notes.Version 11.46 (03/01/2018)
-
Updated the standalone QuickApp settings to prevent displaying the Beta disclaimer when rendering the QuickApp in Prime.
Version 11.45 (02/15/2018)
-
In the Trillion-Row Spreadsheet, in issue was fixed with sorting columns after performing a distribution. Distribution is found in the right-click menu under Analyze.
Version 11.44 (02/01/2018)
-
Interface design updates to the Information dialog and the search bar in the Object Manager.
Version 11.43 (01/25/2018)
-
Instances of Macro Language Workshop restored via the Recent Workspaces tab in the Dashboard window now fully render correctly.
-
A Firefox-specific strict mode compatibility issue that was interfering with initialization of the Insights Platform web interface has been corrected.
-
Instances of <widget class_="grid" type_="scroll"> with conditional formatting attributes (e.g., colstwtbgcolor_, bgcolorforcol_) no longer return a rank error when the query associated with the widget results in a table with no rows.
-
An issue in the Trillion-Row Spreadsheet that was preventing worksheet merges to work properly has been corrected.
-
Several enhancements were made to the Group Manager, including:
- The styling of the buttons in the Groups Found section now changes correctly when the user hovers over them.
- The workflow related to adding users to groups as well as removing them has been improved.
- The Group Manager no longer throws an error about bad @variable names when clicking on a group.
-
Several enhancements were made to the User Manager, including:
- The User Manager now provides a notification after an unsuccessful user search.
- The layout and styling of the User Manager has been updated.
- Superflous scrollbars have been removed.
-
A run limit gauge has been added to the Scheduler to show how many runs will occur for the rest of the month when a new job in scheduled or an existing job frequency is altered. Users will be able to see their run limits and make sure any new jobs or existing jobs will remain within their limits for the rest of the month.
-
Styling changes have been made to the Uploader tool.
Version 11.42 (01/18/2018)
-
Fixed an issue where sorting a total column and then rearranging columns generated an error.
-
In Macro Language Workshop, if a set of fixed columns are close to exceeding or exceed the current width of the grid, those columns are rendered as normal scrolling columns. They are still rendered as the leftmost columns.
-
Fixed an issue in the Trillion-Row Spreadsheet with displaying existing worksheets during a link operation has been fixed.
-
The Object Manager Users and Uploaders fields now handle carriage returns.
-
In the Object Manager, the functionality to drag multiple objects was updated to make the action easier.
-
Fixed an issue in the Object Manager that displayed an error when a user attempted to add an object to their favorites.
-
Fixed an issue in the Object Manager that prevented opening an object from the right-click menu multiple times in a row.
-
Several enhancements were made to the Object Manager, including:
- Moving an object automatically causes the Object Manager to update.
- Changes to the Add Subfolder window that make it more user friendly.
- Preventing users from moving objects in directories they don't have the correct permissions.
-
Added the find attribute to the <directory> operation, which allows users to search on title or path.
Version 11.41 (01/11/2018)
-
Internal bug fixes and enhancements.
Version 11.40 (01/04/2018)
-
Fixed an issue with the mutiple <widget class_="gmap"> windows on the same page appearing in the wrong place when rendered.
Version 11.39 (12/14/2017)
-
Fixed a bug in the Object Manager. The right-click options menu used when multiple objects are selected now renders without producing an error.
-
For columns with the big integer data type, the display format is used to specify the data type the columns are cast to when exported to XLSX files. Big integer columns formatted using format="type:num" or format="type:nocommas" are cast to the floating point number type when exported to XLSX. Columns formatted using format="type:char" are cast to the string data type when exported to XLSX.
Version 11.38 (12/07/2017)
-
An issue opening the Workspace Settings tool has been resolved. Minor aesthetic updates were also made to the Workspace Settings window.
-
Exporting data from TRS using the backslash or other character as a masking character no longer produces incorrect placement of the masking character.
-
Fixed an issue casting alphanumeric decimals to the big integer data type.
Version 11.37 (11/16/2017)
-
In the User Manager, the user names are now visible when you hover over the user ID in the search list. Additionally, general changes were made to to the User Manager window and layout of user IDs.
Version 11.36 (11/09/2017)
-
In the Trillion-Row Spreadsheet, hiding a column on which a table is segmented no longer causes the Select rows and Computed column panels to become unusable.
Version 11.35 (11/02/2017)
-
The Link tables and Merge tables panels in the Trillion-Row Spreadsheet are now displayed correctly when using IE11.
-
The Reference Manual menu item in the Help menu in the Insights Platform web interface has been renamed to Interactive Reference. This menu item opens the Macro Language Elements section of the 1010data Reference Manual in the integrated documentation viewer and provides interactive examples and functionality.
-
A User's Guide menu item has been added to the Help menu in the Insights Platform web interface. This menu item opens the WebHelp version of the Insights Platform User's Guide in a new browser tab.
-
A Reference Manual menu item has been added to the Help menu in the Insights Platform web interface. This menu item opens the WebHelp version of the 1010data Reference Manual in a new browser tab.
-
The Help menu in the Insights Platform web interface now contains the menu item Launch Support Portal, which opens the 1010data Support Portal in a new browser tab.
Version 11.34 (10/26/2017)
-
The attribute emptytext_ has been added to <widget class_="browser">, which specifies the text to display in the browser widget input field when the dynamic variable associated with the value_ attribute is not set to anything. Previously, the input field displayed the text All Databases; it will now appear blank unless the emptytext_ attribute is specified.
-
In the Trillion-Row Spreadsheet, the Excel workbook export settings now include an option to specify whether to convert big integers to a decimal value or to text when exporting to Excel. The Excel workbook export settings can be accessed by clicking Microsoft Excel from the Export tab.
-
In the Trillion-Row Spreadsheet, the Back and Export buttons have been moved to the top of the Excel workbook export settings. The Excel workbook export settings can be accessed by clicking Microsoft Excel from the Export tab.
-
The Scheduler can now be accessed from the Admin menu. See Scheduler for more information.
-
The Help menu items Documentation Center and Change Log now correctly open the Prime-related content.
Version 11.33 (10/19/2017)
-
Production release of 1010data Insights Platform Version 11.
VERSION 11 PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the production release of the 1010data Insights Platform Version 11, see Release Notes.Version 11.32 (10/12/2017)
-
Internal bug fixes.
Version 11.31 (10/05/2017)
-
Internal bug fixes.
Version 11.30 (09/28/2017)
-
This release includes all changes up to and including beta-12.08. See the Beta Changelog for more information.
Version 11.29 (08/10/2017)
-
Implemented memory optimization for row-shifting-related g_functions. See the section titled Shifting and Windows in the 1010data Reference Manual for a list of these functions.
Version 11.28 (07/20/2017)
-
Performance enhancements.
Version 11.27 (07/13/2017)
-
Internal bug fixes.
Version 11.26 (07/06/2017)
-
Removed disclaimer on the login page incorrectly stating that the version was not a production version.
-
Added additional support for 64-bit integer values and bigint columns as parameters in functions.
Version 11.25 (06/27/2017)
-
Limited production release of the 1010data Insights Platform Version 11. (Full release slated for later this year.)
-
This version offers many new features and enhancements to support 64-bit integers.
-
This release includes changes up to and including beta-11.25. See the Beta Changelog for more information.
VERSION 11 LIMITED PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the limited production release of the 1010data Insights Platform Version 11, see Release Notes.Version 10.64 (08/10/2017)
-
Implemented memory optimization for row-shifting-related g_functions. See the section titled Shifting and Windows in the 1010data Reference Manual for a list of these functions.
Version 10.63 (06/08/2017)
-
This release contains changes related to PowerLoader and Custom Uploader.
Version 10.62 (06/01/2017)
-
The URL associated with the Help > Technical Interfaces menu item in Compatibility Mode (Session > Open Compatibility Mode) was corrected.
-
The max(X;Y) function was updated to correctly return NA when one argument is a scalar value and the other is NA.
Version 10.61 (05/25/2017)
-
This release was not made publicly available.
Version 10.60 (05/11/2017)
-
A bug was fixed where <widget class_="alert"> set the dynamic variable associated with the responsevalue_ attribute to integer rather than string, so it was not recognized as a trigger for subsequent alert widgets in the same <dynamic>.
Version 10.59 (05/04/2017)
-
Bug fixes and system enhancements.
Version 10.58 (04/27/2017)
-
Internal bug fixes.
Version 10.57 (04/20/2017)
-
Upon logout, the user is now returned to the URL at which they logged in via a relative URL so that https is preserved. Previously, they were redirected to the fully-qualified URL for the version of the 1010data Insights Platform in which they had logged in (e.g., https://www2.1010data.com/prime-10.54/).
Version 10.56 (04/13/2017)
-
The redirect after login to the 1010data Insights Plaform Version 10 was removed, which could potentially change the domain name.
Note: This change may potentially break the preference that determines your default interface, which was set incorrectly for some users. This can be resolved by manually setting the Default interface option under the Advanced settings panel on the Settings tab of the User Profile.
Version 10.55 (04/06/2017)
-
The Forgot Your Password? link on the login page for standalone QuickApps has been been fixed.
Version 10.54 (03/23/2017)
-
An issue causing a domain error on SSO login was resolved.
Version 10.53 (03/09/2017)
-
The Trillion-Row Spreadsheet Getting Started Guide accessed from Help > Getting Started Guide was updated.
-
The 1010data Reference Manual accessed from Help > Reference Manual was updated.
Version 10.52 (02/23/2017)
-
A correction was made to address a "TenTen is not defined" error when using certain Chrome extensions.
-
The path to the 1010data logo in the integrated documentation viewer was updated.
Version 10.51 (02/02/2017)
-
In the Trillion-Row Spreadsheet, the interface now displays displays the Simple comparisons options in the Select rows panel by default.
Version 10.50 (01/26/2017)
-
On the Help menu, the menu item Reference Guide was changed to Reference Manual to reflect the correct title of the document.
-
The path of the 1010data logo in the integrated documentation viewer was changed.
-
A fix was made related to running standalone QuickApps on vanity domains.
-
The Trillion-Row Spreadsheet Getting Started Guide accessed from Help > Getting Started Guide was updated to reflect changes in the interface.
Version 10.49 (01/19/2017)
-
Issues with QQ-to-QA conversion of queries containing <library> and <import> have been resolved.
-
Specifying a path to an <import> within a <widget> when that path had not yet been referred to elsewhere in the session no longer causes an error.
-
A warning message is now displayed when clicking on a favorite that no longer exists.
Version 10.48 (01/12/2017)
-
Bug fixes and system enhancements.
Version 10.47 (01/05/2017)
-
Fixed missing context menu when subsequent Object Manager windows are opened after the initial instance.
-
Fixed issue when submitting queries with <loop> ops or that use certain special values.
-
Fixed issue that caused previous row/next row arrows to signal and error in one-row view.
-
A more informative window label is now given when exporting a query from Macro Language Workshop to TRS and vice versa. In addition, renaming of the window is allowed.
Version 10.46 (12/29/2016)
-
Enabled TRS-style grid interactions (sort, reorder columns, right-click context menu with select, analyze, etc.) when viewing the results of a query in Macro Language Workshop.
Version 10.45 (12/22/2016)
-
Production release of the 1010data Insights Platform Version 10.
VERSION 10 PRODUCTION RELEASE
For the highlights, technical advisories, and release details for the production release of the 1010data Insights Platform Version 10, see Release Notes.