Features

Member Select in Business Rule

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.

Formulas/Preparation

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:

For Strings

• 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

For Numbers

• 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

For Dates

• 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

For Boolean

• 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.

Miscellaneous

• 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
• Added Collapsible Sidebar
• Added Live / Edit Switch to Global Search
• Added Search to Mapping Detail and Form