BRF+ Decision Tables

General Information

Decision tables are used to store new settings for your PPP without any need for code. Here’s how they work:

1. Switch to edit mode;
2. Add lines to the table and fill in the required columns;
3. Save changes;
4. Activate your changes

 
There are two types of columns: Condition Columns and Result Columns.

One of the possible models of a decision table.

When you add new rows, PPP provides Search Helps to make the process easier. Remember to save and activate your changes. You’ll also need to create a task for your user under a customizing request.

Condition Columns

Condition Columns set the criteria which has to happen to trigger a specific outcome. They usually contain parameters, expressions or comparisons against certain values or ranges. These columns have a grey background.

In the image, the Condition Columns are highlighted with a red box. These columns include “Text ID” and “Language.”

Key points about Condition Columns:

1. Table’s result expression

   1. In BRF+, a decision table may return all matches found or just the first match depending on its configuration.

   2. It is generally recommended that you do not change this setting on your own. This setting is crucial for the correct operation of decision tables, and altering it without proper knowledge could lead to unexpected results.

   3. To check a table’s result expression:

      1. Go to the decision table page.
      2. Navigate to “Table Settings”.
      3. Look at the “Result Data Object” section.
      4. Check the “Return all matches found” checkbox to see if the table returns multiple values.

2. Values

   1. Leaving a value empty means any value matches the condition.

      1. This is different from setting it to an empty string (" “) which means only empty values match a condition .

   2. You can add multiple values for a Condition Column in a single row.

      1. click on the condition cell -> ‘Change’ -> Insert include condition -> add another value

3. Adding new columns

   1. You can define your own Condition Columns if the existing ones aren’t enough. It will be discussed in BRF+ Functions part.

   2. Adding new columns is available for the following Tables:

      1. FORM_CONTROL_… → All Form Control Decision Tables
      2. PPP_AUTHORIZATION → PPP Authorization
      3. PARTICIPANT_TABS → Participant Tabs
      4. PROJECT_NODE_TABS → Project Node Tabs
      5. and others.

Result Columns

Result Columns specify the outcome or action to take when conditions are met. They represent the output of the decision table. These columns have a green background once a row is added.

In the image, the Result Column is column ‘Text’. It determines the outcome (particular phrase in this case) which depends on the Condition columns (“Text ID” and “Language.”)

See also

• BRF+ Applications
• Create a BRF+ App

Keywords

decision tables, condition columns, result columns, PPP settings, BRF+ applications