Release Notes v3.2.0.68

v3.2.0.68
Dec 17, 2018

Dashboard Server

Features

  • Integrated User Management Server with Dashboard Server – Authentication and Authorization system is provided to manage the Dashboard Server and data integration platform applications, users, and their access.
  • #209124, #213794 - Built-in web designer has been provided to create and edit dashboards from the Dashboard Server.
  • #189711, #208701, #215114, #215813 - Dashboards can be added as slides and presented as a slideshow in a TV or a large monitor.
  • #167711 - Tune control of the data will be shown to users and groups inside a dashboard by choosing the data sources specifically.
  • #206780 - Unlisted attribute for dashboards – Hide dashboards from listing and share it privately to users.
  • #185119 - Configure password policy – Provided an option to configure the password policy by the administrator.
  • #208527, #211487, #212552, #212814 – Performance improvement has been achieved in various modules.
    Rest APIs
  • Dashboard Server – New APIs in items and schedule module. Know more
  • User Management Server – New APIs in user module. Know more

Bug fixes

  • #218360, #218976, #216204 - User filter will not be applied when the widget is pinned to the homepage.
  • #216897 - An issue has been fixed where the scheduler web job in the Azure deployment taking 100% CPU.
  • #221397 - An issue that occurs when validating the Site URL has been fixed.
  • #210446, #214336 - The issues that occur when updating the schedule have been fixed.
  • #214856 - An issue that occurs while rendering the dashboards when the user ID exceeds 32787 has been fixed.
  • #213915 - The issues have been fixed in starting the Dashboard Server with MySQL by restricting to inherit the MySqlRoleManager from parent config.
  • #213205 - An issue has been fixed while getting data from the GetSharedDataSource API when passing the valid Dashboard ID along with the dashboard path.
  • #212811 - An issue that occurs when sending the error status code for Authentication Token API has been fixed.
  • #210153 - An issue in the scheduler service when the Dashboard Server is configured with MySQL database has been fixed.
  • #210218 - An issue that occurs while accessing Rest APIs when the SSL is enabled and requested with the HTTPS protocol has been fixed.
  • #217649 - User based filter is now working properly for scheduled Excel export.
  • #210446 - Error is thrown in the dashboard service when you create the schedule using increase condition.
  • #210446 - Custom type is automatically changed into actual type while editing the data alert schedule.

Upgrade

Follow the steps from here to upgrade the Syncfusion Dashboard Server from an older version to this version.

NOTE

In versions 3.2.0.68 and newer, Dashboard Server comes with a separate User Management Server deployment. Please read the upgrade documentation carefully before proceeding to upgrade Dashboard Server.

Dashboard Designer (Desktop)

Features

  • #201749, #206057, #206209, #206209, #207510, #210666, #212903, #202022, #207895, #211539 - Asynchronous implementation in dashboard designer to avoid hanging issue.
  • #201151, #212234 - Settings and preferences to set common property for dashboard and designer.
  • #185630, #185849, #189573, #191353, #192764, #194322, #197364, #205774, #207609, #210100, #210898, #213288 - Global filter panel, will be accessible from all dashboard tabs.
  • #201644, #204050, #206209, #212252, #214797 - Virtual loading in Dashboard Designer drop down to improve performance.
  • #193275, #202713, #210017, #214691 - Defer update option in dashboard designer to suspend widget refresh for every action.
  • #196873 - Utility to change data source connection without opening the designer.
  • #209301, #209300 - Sorting and refresh support for data column parameter.
  • #209851, #210264, #215682 - Retaining widget configuration when executing query in SQL code view.
  • #204025, #192514, #209421 - Data blending support in SQL connection.
  • #202699 - Query view support for SQL Server Analysis Services.
  • #201972, #207477, #215895 - Retain schema support for stored procedure.
  • #200232, #184052, #201756, #200795 - Custom OAuth support in dashboard application.
  • #195822, #201742 - Stored procedure support for ODBC ANSI SQL connection type.
  • #192096, #195822 - Code view support for ODBC ANSI SQL connection type.
  • #190529, #199637, #212975 - Support to connect POST request RESTful web services.
  • #182258, #193081, #204316 - Support to filter parent column based on its child column in Pivot Grid.
  • #182021, #185850, #190631, #204486, #210946, #212681, #212898, #212890, #214869, #218138 - Summary row support has been provided in the Grid widget.
  • #175754, #188596, #190322, #205409, #213565, #217566 - The display formatting option has been provided in the Grid like text wrapping, column header, and value text alignment.
  • #187681, #190595, #193670, #196806, #202286, #202865, #207249, #211942, #213126, #216880, #216903 - Date-time format customization has been added in the Date Picker.
  • #209274 - Support to export an IFrame Custom Widget to image and PDF has been provided.
  • #189721, #190271, #199980, #191184 - Support to view the aggregated and non-aggregated data of widgets in the Dashboard Viewer has been provided.
  • #185630, #185849, #189573, #191353, #192764, #194322, #197364, #205774, #207609, #210100, #210898, #213288 - Support to add the Global Filter Panel common for all the tabs in the Dashboard has been provided.

Bug fixes

  • #215898 - Time support in date range type of dashboard parameter.
  • #215815 - Saving file name with dot(.) character.
  • #214250 - Show header property for custom widgets.
  • #214250 - Minimum size of custom widget reduced to 1*1.
  • #214381 - Source column’s selection maintained properly in the linking parameter window.
  • #213629, #212903 - Displaying proper error message in designer.
  • #212900 - Configure data with dashboard parameter works fine.
  • #212903 - Dashboard title allows ‘_’ character.
  • #212903 - Allows saving an expression without any issue.
  • #212890, #213631 - Executes valid result when passing date parameter to stored procedure.
  • #212678 - Creating expression with dashboard parameter works fine.
  • #211079 - Recent dashboards list will be maintained, when upgrading designer application.
  • #219723 - Able to drag fields into ‘Size value’ section of the Bubble chart after resetting the data source.
  • #219723 - Filter panel columns added in dashboard linking.
  • #218800 - User based filter dashboard loading properly in designer.
  • #217678 - Dashboard instance(temp) folder will be deleted from ‘AppData’ every two weeks.
  • #205639 - Designer will open properly, when custom widget file is double clicked.
  • #214381 - When a widget is dropped to the canvas, it works fine without any issue.
  • #216406 - Scrolling improvement in design canvas.
  • #216292 - Trace log improvement at data source loading time.
  • #214977, #213629, #215189 - User login succeeds when connecting the server URL with slash.
  • #212042 - Negative values are maintained properly in the custom range of card widget.
  • #208246 - Preview works fine when custom widget name is provided with large characters.
  • #214336 - Publish option in the context menu of the dashboard container.
  • #220301, #220209 - Multiple previews from designer works fine.
  • #212252 - Execute query view (Postgre SQL) with data column mode parameter works fine.
  • #214066 - Trace log improvement in chart widget.
  • #215723, #215722, #220238 - Saving unloaded dashboard tab works fine.
  • #218503 - Widget resize works fine when the previous version dashboard is opened.
  • #220861 - Dashboard created with PostgreSQL can be saved without any issue.
  • #212903 - Query view with data column parameter works fine.
  • #220614 - Applying template columns for stored procedure connection works fine.
  • #217562 - Manual sorting works fine, if any special character is present in the data.
  • #215443 - SQL stored procedure is working properly in designer for all cases.
  • #216606 - Widget filter is maintained in the sorting window.
  • #216292 - Reopening the designer designed using Postgre SQL views works fine.
  • #213220, #216882 - Expressions are not cleared when executing the query in query view.
  • #212903 - Query will not disappear when switching the tab in PostgreSQL.
  • #212678 - Creating the expression using PostgreSQL query view works fine.
  • #212550 - .SQLite extension files for SQLite database is handled.
  • #211888 - SQLite query builder supports ‘Seconds’ time format.
  • #211527 - Dashboard designed with user defined schema in postgres view works fine.
  • #211055 - Reconnecting the data source will not throw any error.
  • #210258 - Top N filter with None summary type in SQL server.
  • #219704 - Stored procedure with XML parameter works fine.
  • #222239 - Widgets are refreshed properly with current user parameter in stored procedure.
  • #221816 - The Grid column URL linking, which is not working properly when the column has special characters issue has been fixed.
  • #218163 - The Grid that is not loaded in the scrollable dashboard when scrolling the dashboard using the mouse wheel issue has been fixed.
  • #220304 - Parameter date ranges are now updated properly when switching between Relative dates.
  • #218250 - An export option that does not show in the viewer when you click the control menu issue has been fixed.
  • #220126 - Export to Excel with Dutch date filter that gives DV008 issue has been fixed.
  • #219808 - Drill down is now working properly in the Pivot Grid when you use custom date format in viewer.
  • #219808 - State persistence that is not maintained while using the custom date in the Pivot Grid issue has been fixed.
  • #219723 - An issue for not passing the parameters to the filter panel in the target tab, when you apply linking in the chart after performing drill down from a chart widget has been fixed.
  • #214381 - The target dashboard is now rendered properly when you apply linking in the first tab.
  • #218587 - Parameter value that is not passed to the SQL query during the Pivot Grid drill down issue has been fixed.
  • #218552 - The issue, displaying a minimum value as negative value in the column type sparkline Card widget has been fixed.
  • #140498 - Exception is thrown when opening the old report designed with Date Picker widget issue has been fixed.
  • #218129 - The filter panel is now working properly in the multi-tabbed dashboard.
  • #218094 - The format that is not applied to the target column in the Card widget issue has been fixed.
  • #217245 - Grid widget URL column linking that is not applied for null value issue has been fixed.
  • #217552 - Grid widget conditional formatted background color is now applied when exporting to PDF.
  • #217202 - Multi-tab PDF exporting is now worked properly when applying the whole dashboard export without switching tabs.
  • #213463 - Label widget that does not act as slave properly if you set the filter settings in the Dashboard Designer issue has been fixed.
  • #217073 - Exception thrown when you apply drill down in the chart after tab switching issue has been fixed.
  • #217061 - Multiline is created and empty labels are shown when you apply drill down in the Chart widget.
  • #217061 - Drilled charts get overlapped with normal view charts when minimizing or maximizing the window has been fixed.
  • #216842, #217760 - Custom sorting that is not worked in Chart widget issue has been fixed.
  • #216837 - Grid URL linking that is not worked in IE 11 Browser issue has been fixed.
  • #218587, #221540 - Pivot Grid that is not rendered after expanding the rows issue has been fixed.
  • #213463 - Exception is thrown when opening the dashboard designed using the Pivot Grid with initial selection issue has been fixed.
  • #216620 - Date column custom formatting that is not applied in exported Excel file issue has been fixed.
  • #216421 - Exception that is thrown when binding data to row section in the Chart for MySQL query view data source issue has been fixed.
  • #215482 - The dashboard parameter prompt window that is shown each time for the multi-tabbed dashboard issue has been fixed.
  • #214861 - Dashboard that is freezing when auto refreshing issue has been fixed.
  • #213463 - Label parameter that is getting rounded off issue has been fixed.
  • #214381 - Internal linking that is not working when the Chart is linked to the Grid widget issue has been fixed.
  • #213899 - An issue in expanding the Pivot Grid drill level if it has date values in the columns has been fixed.
  • #213640 - Dashboard linking does not filter the second dashboard when the value has ‘&’ symbol issue has been fixed.
  • #213562 - While applying currency format for numeric column, null values are now treated as ‘$0’in viewer.
  • #214105, #221608 - Data retrieval error that is thrown in widgets when changing the date format in viewer issue has been fixed.
  • #214093 - 100% Stacked Chart throws an exception when drill down column is a TIME data type.
  • #213395 - An issue in exporting to Excel throws an error when the data has negative values in it has been provided.
  • #213717 - Exception is thrown when binding data to row values in the Chart for PostgreSQL data source issue has been fixed.
  • #213562 - Fraction values that are not displayed when setting the decimal places for numeric values issue has been fixed.
  • #213899 - Standard date format implementation that is missed for Custom date format query issue has been fixed.
  • #213338 - Exporting to Excel that appears empty when Grid is applied with wildcard search has been fixed.
  • #212678 - An issue with internal linking that is not working in the Card widget has been fixed.
  • #213565 - Column linking that is not working when using the hidden columns or other columns except given column name as a parameter has been fixed.
  • #213562 - Grid conditional formatting color values that are varied with opacity issue has been fixed.
  • #213395 - Error that is thrown randomly in the Excel export when the Grid is exported issue has been fixed.
  • #213184 - The issue with Pivot Grid values that are truncated when you enable the frozen headers has been fixed.
  • #211304 - Chart widget that is not exporting to PDF issue has been fixed.
  • #213050 - An issue, DV009 Error thrown while rendering the Dashboard Widgets(SYDW) has been fixed.
  • #212848 - An issue, linking with inner level parameter does not working for drilled down Chart has been fixed.
  • #212678 - In dashboard parameter, when setting the default date range, the date outside the range couldn’t be selected. This bug has been fixed now.
  • #212670 - Grid pager text that is not localized issue has been fixed.
  • #212403 - Dashboard that is now rendering properly when the dashboard path is long.
  • #212042 - Negative values in custom range of Card widget that does not retain issue has been fixed.
  • #213311 - Displaying the NaN label when the segment value is not present in the Stacked Bar Chart issue has been fixed.
  • #212042 - The issue in Choropleth Map legend that shows empty value in viewer has been fixed.
  • #212125 - An issue, allow filtering search text in Grid and Combo box does not working in IE browser has been fixed.
  • #211942 - The issue for missing the last line, when the Grid is exported to PDF has been fixed.
  • #211204, #211230 - Process cannot access the Dashboard file error thrown randomly when pass the dashboard path through web API has been fixed.
  • #211641 - Data retrieval error that is thrown in the Proportion Chart bounded with stored procedure issue has been fixed.
  • #213899, #217701 - The issue, Pivot Grid drill down throws a console error and columns are misaligned has been fixed.
  • #210649 - The issue, change connection string is not working for OAuth web data source has been fixed.
  • #210275, #210643 - The occurrence of date time parse error when initial selection of the Date Picker has been fixed.
  • #205409 - The issue, data is not updated for internal tab linking when it has initial filter has been fixed.
  • #209006 - The issue, data is not refreshed for widgets in maximized mode and normal mode except Grid has been fixed.
  • #210336 - The dashboard parameter empty dialog is shown properly in preview even after setting it to false state.
  • #208236 - Grid values that are not formatted when loading the data through scrolling issue has been fixed.
  • #213618 - Now, the expression field can be bound to the Pivot Grid rows properly.

Dashboard Platform SDK

Features

  • #142735, #170169, #201381, #200326, #201381, #202011, #204292, #203132, #204687, #208155, #214482, #214916 - Added the Dashboard Service as an assembly.

Bug fixes

  • #218415 - The Chart that is not rendered properly in ASP.NET Web Forms multi-tabbed dashboard sample has been fixed now.
  • #216150 - Fixed widget excel exporting using the API in Dashboard SDK.