NEW
- New Cloud9QL Date Functions
Knowi's Cloud9QL library has been enhanced to now include the following date delta functions :- MINUTES_DELTA: number of minutes between two dates
- HOURS_DELTA: number of hours between two dates
- DAYS_DELTA: number of days between two dates
- MONTHS_DELTA: number of months between two dates
- REGEX_REPLACE: regex function that can act on a field
IMPROVEMENTS
- Drill down capability for Geo-clusters
Knowi has been enhanced to now allow for data drill down capability from the geo-cluster range widget type - Preview Query - Runtime Parameters
The system has been enhanced to allow for query preview for those queries that contain runtime parameters. A popup will now ask the user to enter parameter values so that the query can run. - Pivot Configure Option
Disabled the pivot table 'configure' option for all users except Admins and the widget creator themselves
FIXES
- Fixed an issue with existing user content parameters not being displayed on the User edit page
- Fixed several issues with the data grid:
- the group name not showing correctly if there is a 'dot' in the name
- total counting rather than summing when there are 0’s
- multiple groupings perform a count instead of total
- Addressed an issue with the Dataset Alert listing page not displaying all the summary details
- Fixed the issue with a spurious character appearing as part of the first column name of a file upload