It is now possible to select weather the Key Mapping should be made case sensitive or case insensitive. This allows for more Flexibility in matching with your master Data.
Exclusion of Columns
To mitigate heavy data load and memory pressure of large and wide tables we have introduced the possibility to exclude columns which will not be used in conditions or formulas.
Analyse Preview Data
Extended Domain Filter
The Domain Filter option was extended.
– Numbers can now be prefixed with >, <, >= and <= to filter respectively eg. > 1.2 will filter for numbers greater 1.2. if the prefix is omitted the default operator = will be used.
– The format for Dates has now the possibility to consist only of the date portion eg. 2024- 01-01 this will then filter all the rows which have the same date portion. Dates containing the time portion, eg. 2024-01-01T00:00:00, will respect the time portion, so the example would only find dates which actually represent midnight on January 1st, 2024. Microseconds will be ignored.
– Similar to Numbers , dates respect the prefixes >, <, >= and <=. Eg. < 2024-01-01 will filter for dates smaller than January 1st, 2024.
– The token $NOW was introduced to be able to filter for dates in comparison to the current timestamp.Eg. >= $NOW.
– The token $TODAY was introduced to be able to filter for dates in comparison to the current date. Eg.<= $TODAY.
The NULL value has changed from <NULL> to $NULL.
Fixed Import Knowledge Base from Databricks were Precision, Scale and Length were not correctly set.
Fixed an Issue in Databricks All Purpose Api where wide tables did not return all Data.
Fixed an Issue with Precision Validation in Dotnet Runner on some cases.
Fixed an Issue in Forms where an empty description could be entered in RichText Component.
We introduced a new feature where you can select a Value from the Member List, analog to referencing the Value of another Domain or Lookup. To achieve this, you require a Domain with Member Search enabled being on the Domain Selection of the Condition. In the Value Field you can now enter the @ Symbol as you would do to reference another Domain or Lookup. A new Tab “Member” should be available. Selecting it will load the List of Parent Members from which you can choose. Note: Other than a reference to a Lookup or Domain, this will not insert a reference to the Member Value but enter the selected value directly, meaning there is no connection or information left that this value was chosen from the Member List.
We added a new possibility to manipulate processed data which helps achieving new possibilities in the Business Rule processing. Initially started as Formulas, which should help utilize better data e.g. fixed casing or trimmed strings to be used in Conditions, it soon transformed into a new Step in the Processing of a Business Rule, the “Preparation”. This approach allows to clean the data before being utilized in a Condition, it can also be used to have something like “calculated” Domains which can be directly utilized on the left and right hand side of a condition, which also includes setting those Domains from Data Links, etc. So values from Data Links on the Left side of a condition are now possible too.
The Following Formula Items are included:
String: Provides a String value either directly or from a reference like Lookup or Domain
Concat: Concatenates multiple Strings together, an optional Separator can be entered
Lower: Transforms to Lower Case
Upper: Transforms to Upper Case
Regex Replace: Performs a regex Transformation, Capture Groups can be accessed with $1, $2, … in Replace Field
Replace: A Regular String Replace
SubString: Gets a part of a String from a zero based Start value and an optional Length
Trim: Removes white spaces from String. Either on both sides or only from front or end
String from Date: Creates a String from a Date with a specified Format
String from Number: Creates a String from a Number with a specified Format
String from Boolean: Creates a String from a Boolean where the representing Bool Values can be entered
Number: Provides a Number value either directly or from a reference like Lookup or Domain
Addition: Adds multiple Numbers
Multiplication: Multiplies multiple Numbers
Subtraction: Subtracts multiple Numbers starting from top to bottom
Division: Divides multiple Numbers starting from top to bottom
Round: Rounds the Number to desired decimal count. Rounding can be either up, down or commercial
Number from String: Transforms a Number from a String with possibility to provide thousand and decimal separators
Number from Date: Takes the Seconds from Unix Epoch
Date: Provides a Date value either directly or from a reference like Lookup or Domain
Add Time: Adds Time to a Date
Date from Number: Creates a date from a Number based on Unix Epoch seconds
Date from String: Parses a date from a String based on provided Format
Boolean: Provides a Boolean value either directly or from a reference like Lookup or Domain
Boolean from String: Creates a Boolean from a string where the True and False Value can be Provided
Boolean from Number: Creates a Boolean from a Number(0or1), otherwise null
‘AlwaysTrue’ logical Condition
An ‘Always True’ logical Condition is now available. This new Condition will always be met successfully regardless of nested Conditions and can be used to e.g. skip the evaluation to immediately proceed with the Action of a Business Rule. Conditions within the ‘Always True’ Condition remain editable.
Databricks SQL Warehouse API Support
Added Databricks SQL Warehouse support to HEDDA.IO which has performance improvements over the Databricks Command API and should drastically reduce load times for lookup and preview operations which rely on Databricks.
Improved performance when loading statistics
Improved Value Field to not show Lookup Tab if no Lookups are present
Added multiple receivers to Twilio alert sink
Removed profiling from python example code temporarily
The Data Type Validation option will now be selected by default in the Runs Execution Widget under the Domains tab
Improved DotnetRunner Performance
Extended Business Rule Node in Rulebook Overview. Condition will now be partially shown directly in the node and can be viewed in full on click without leaving the page.
Hardened publishing to exclude generated items through the API within valid references
Improved default templates for events
Drastically improved load times when initially loading a Project in the UI
Domains can now be marked as Variables. Variable Domains can still be used in BusinessRules and Actions but will not appear in Mappings as they are not read from the Source Data. This means that they no longer need to be present in eg. the source data frame. On top of this Variable Domains can also have a Default Value configured. On Preview Screen, Variable Domains are hidden by default but can be made visible through the Domain Selection.
Last Applied Changes in Preview
The Preview Row Result View will now display the Last Rule which made a change to a specific Domain. Every Domain which has changed during the execution will display an Info Icon on hover. Clicking on it will display the Last Rule and Rulebook.
Support for Databricks as a Transport has been implemented. It is now possible to utilize Databricks as Lookup or External Member Source. Furthermore Databricks can be used to create Knowledge Bases. This Transport uses the General Cluster, a version with SQL Warehouse Cluster support is also planned for the future.
The Support Page now gives you the possibility to submit an email ticket to our customer support. Enter a subject and click the corresponding button to open your email client.