Releases self-hosted SeekTable

2019 Oct 25

Public reports: added ability to embed reports in a secure way with JWT authorization. JWT may include report parameters for row-level security rules.
Public reports: added CSS-animated preloader if report rendering takes more than 300ms.
Usability: sync report/cube config when SeekTable is opened in several tabs (share the same login session).
Usability: show 'confirm overwrite' dialog on cube save if configuration was changed during edit

2019 Oct 02

Team sharing: added Groups to simplify management of large teams. You can create any number of user groups and configure access to cubes/reports for these groups.
DB cubes: added Apply pivot table filter as condition parameter that enables translation of user-defined table filter into database query condition. This option unlocks any-level drill-down even for large databases.
SQL cubes: added Use "GROUP BY CUBE" option that enables totals/sub-totals calculation for custom-SQL measures (Type=FirstValue)
ElasticSearch: now it is possible to configure custom ES bucket or metric aggregation ("histogram", "extended_stats" etc)
Charts: use integer-labels for axis labels with numbers
Charts: if line/area/scatter axis contains a lot of labels display only some of them (by interval)
Public reports: more memory-efficent rendering (affects huge reports)
Public reports: when auto-refresh is enabled do not refresh if page is not visible (document.visibilityState is 'hidden')
Public reports: use webcombo instead of dropdown for parameters with Editor=Dropdown and if number of items > threshold (20 by default, configurable)
Public reports: warning is displayed when report parameters passed in URL are ignored because of incorrect format
Other minor improvements and fixes (including vertical page scroll issue)
Reporting engine: see PivotData microservice v.1.5.5 changes log

2019 Jul 18

Added WS-Federation single sign-on (SSO) for Azure Active Directory or Azure Directory FS
White-label mode new settings: ability to specify custom favicon, signup button text, get started content. Now colors for charts may be customized with CSS rules (including legend colors in the table).
Fixed issue with CSV file upload if JWT for API is not configured
CSV cube: added "Variance" measure type that can be used for calculation of [sample] variance/standard deviation
Expressions: added math functions like Math.Round, Math.Pow, Math.Sqrt (unlocks possibility to calculate standard error by standard deviation)
More convinient validation of 'Dropdown (dynamic)' editor of report parameters
Other minor improvements and fixes
Reporting engine: see PivotData microservice v.1.5.3 changes log

2019 Jun 17

CSV connector: now it is possible to use report parameters and specify filtering expression for rows
Cube parameters: added ability to populate dropdown values dynamically
Calculated members: added Html.Raw function that accepts 2 arguments to specify different value for non-HTML exports
Published report: fixed UI issue with input=date (inside ST app datepicker is also replaced with native input=date that used browser's settings for date format)
Published report: fixed issue with incorrect chart tooltips (on mouse over)
Minor UI fixes and usability improvements
Reporting engine: PivotData microservice v.1.5.2 changes log

2019 Apr 02

CSV connector: now it is possible to use report parameters and specify filtering expression for rows
MongoDb connector: added possibility to specify custom stages (before/after $group)
Report parameters: added ability to choose an editor (textbox, dropdown or multivalue dropdown, checkbox) and specify custom expression to evaluate parameter value
White-label mode new options: "Custom Public Report CSS", "Custom Public Report footer HTML", "Custom Signup Page HTML"
Added API key generation that may be used with Zapier or MS Flow
Share by email: if chart is enabled it is also included into email body as image
When there is no saved reports for the cube SeekTable tries to suggest several reports (by date, by location etc).
Pivot table report type: quick links to change "expand/collapse" mode if several dimensions are selected for rows or columns.
Set of minor UI fixes and usability improvements
Reporting engine: PivotData microservice v.1.5.1 changes log

2019 Feb 22

New feature: expand/collapse mode for pivot tables (can be enabled in "Format" tab)
New feature: "show rows" in drill-down menu (appears on value-cell click in pivot tables)
Expressions: now Html.Raw and Html.Link are supported in pivot tables
Reporting engine: PivotData microservice v.1.5.0 changes log

2019 Feb 01

Added ability to enable "Clone" for CSV cubes (with variable in 'docker-compose.seektable.env')
Added new option for "Restore" dialog (available for self-hosted SeekTable admins): "Generate new record IDs" which restores cubes/reports with new IDs. This mode is useful for 'mass-clone' when backup is restored in the same account, or to re-create the some sample cubes in another account(s).

2019 Jan 22

New feature: white label mode (available only for self-hosted SeekTable with paid subscription): use your company logo/brand instead of SeekTable, hide "Generated by" and "Powered by" notices in app/exports/shared reports, hide links to seektable.com website, set custom footer content for emails and PDF export, customize SeekTable app visual styles by adding your own CSS.
Added ability to override saved report options with 'cfg' URL parameter
A lot of minor improvements / bugfixes
Reporting engine: PivotData microservice v.1.4.4 changes log

2018 Nov 29

New feature: Configure Published Report form (UI for public link options)
New feature: Backup cubes/reports configuration (XML) that can be restored by self-hosted admin
Fix: filter autcomplete positioning issue
Expressions: added Html.SetReportParameters function (sets report parameter(s) on click), Html.Link and Html.Raw (for 'flat table' reports only)
Public report: when parameters are changed this is reflected in URL, browser back can be used as 'undo'
ElasticSearch data source: now parameters are supported and may be used in special filtering condition
Reporting engine: PivotData microservice v.1.4.3 changes

2018 Oct 23

New feature: self-hosted administration (available only for self-hosted SeekTable with paid subscription)
New feature: team sharing when cubes/reports may be shared to other SeekTable users with access control (paid subscription)
New feature: advanced publishing/embedding options for reports published to web (paid subscription)
New data source: Oracle
Flat tables optimization: supported up to 50k rows, this limit can be increased in self-hosted SeekTable
Reporting engine: PivotData microservice v.1.4.1 changes

2018-Sep-14

SeekTable web application migrated to .NET Core 2.1 (better performance and stability)
Now report parameters may be specified in public report URLs (reports published to web)
A lot of minor enhancements and bugfixes
Reporting engine: PivotData microservice v.1.4.0

2018-Jul-25