NEW
- Slack Integration
Slack integration allows you trigger actions in your slack channel(s) for a given condition triggered by an alert. When the condition is triggered, the system will send a message to a predefined channel(s) including the attachment of full data or conditional data depends on the options selected. - IFNULL function
A new IFNULL function has been added to C9QL. The syntax is:
IFNULL(<field name>, < alternate value>)
E.G>, select IFNULL(Customer, "N/A")
- IS NULL and IS NOT NULL Mongo Filter Support
The system now supports both is null and is not null as filter options again the Knowi Elastic Store. These 2 functions will check both {$eq, null} and {$exists}, respectively.
- Support for (optional) final join query C9QL statement
The ability now exists to perform a final Cloud9QL step, if required, when creating queries that involve one or more joins. No other joins can be added once the final C9QL query has been entered. In this case, the final C9QL statement would need to be removed first. This provides the same transformation flexibility that is obtained from using the Steps function on the preview grid but instead using C9QL syntax directly, in a programmatic way.
IMPROVEMENTS
- CASE statement error message
Improved the error message displayed it a CASE statement alias is the same as the source column name - Dashboard Filter Performance
Dashboard filters now apply without the need for a dashboard reload/page refresh - Linked Datasets
When adding a linked dataset, the system now selects the Cloud9 Datasources owned by the current user. If the current user does not have a Cloud9 datasource defined, then the system will create one - Cloud9 Dataset selection
When a Cloud9 datasource is selected, the system will now only show the datasets that the datasource can access, rather than all datasets for the user in question - Mongo Data Sampling Control Limits
A new setting has been added to the Mongo datasource Database Properties option that can control how much data to sample in order to get the field list populated.
schemaSample: How many rows (most recent) we will retrieve from the collection.
schemaNestedSample: if the retrieved rows contain nested field, how many nested entries we will sample.
- Filter Improvements
The process of modifying a dashboard or widget filter has been improved. The user will now be presented with the magic suggest option directly without unnecessary navigation. The filter will also be applied in place, therefore eliminating the need for a refresh.
- Nested Elements within Knowi Datasource
The system now shows any nested elements within a Knowi datasource
- Widget Sharing
Widgets can now be shared independently of any dashboard association. A share icon is now available on the widget listing page and the sharing can be either View of Edit.
If a widget is shared to the user or group, then it will show in the widget list for that user/group.
If view only, then the widget settings will not be displayed in the widget list or in the dashboard. The ability to delete a widget will also not be available.
FIXES
- Fixed a Data Grid issue where null date values were displaying 1/1/1970 (zero timestamp in milliseconds)
- Fixed an issue with the query filter suggestion list not refreshing upon a change of join datasource
- An issue with date sorting on the Data Grid has been addressed
- Addressed an issue with the query filter field not accepting multiple values
- Fixed an issue with the C9 query cursor position not being correctly positioned
- Fixed an issue with the widget list reserving it's order each time a widget was added
- The Analyze Grid function suggestion no longer persists once the function is selected
- Addressed an issue with widget settings persisting from the previous widget selection
- Fixed an issue with the str_to_date function failing if the object is already a date object
- Fixed an issue with derived or modified column metadata not being populated in the visualisation Settings dropdown
- Addressed an issue with widgets being created without a name
- Fixed an issue with the Data Summary chart ignoring aggregation inputs
- Fixed an issue with the Data Preview option not working correctly from with the Machine Learning module
- Fixed a difficulty associated with trying to select Today as a dashboard date filter option
- Addressed an issue brought on by single quote usage when selecting a dashboard filter
- Fixed an issue with the filter date range pop-up persisting after the filter is closed
- Fixed an issue with the Last 30 Days filter option displaying as $c9_today-30d and the inability to then save the date or edit