You are here: Reference > Rule types > Decision Tables > More about Decision Tables

  More about Decision Tables
 

  1. About 
  2. New 
  3. Table 
  4. Results 
  5. Parameters 
  6. Pages & Classes 
  7. Test Cases 
  1. History 
  2. More... 

Uploading an Excel spreadsheet to start

If you have in advance a Microsoft Excel spreadsheet in XLS file format that contains useful starting information for a decision table, you can incorporate (or "harvest") the XLS file and the information it contains directly into the decision table. See About the Rule from File wizard.

This feature lets people with no access to the Pega 7 Platform record their decision rules using a familiar software program.

Evaluating a decision table

In an activity, to evaluate a decision table and derive a value, your application can:

Method

In an activity, call the method Property-Map-DecisionTable method. As parameters, enter the target property name and the name of the decision table.

Standard function

In an activity, call the standard function named DecisionTable.ObtainValue to evaluate a decision table. Use the syntax:

Lib(Pega-RULES:DecisionTable).ObtainValue(this, myStepPage, "decisiontablename")

Performance

The Pega 7 Platform does not limit the number of rows in a decision table. However, as a best practice to avoid slow performance when updating the form and also avoid the Java 64KB code maximum, limit your decision tables to no more than 300 to 500 rows.

Standard activity

The standard activity named @baseclass.DecisionTableLookup also evaluates a decision table. (This approach is deprecated.)

Java code display

When you save a decision table, the system converts the rule to Java source code. As a learning or debugging aid, you can review this Java code.

Click the Show Java toolbar button (Show Java) to see the system-generated Java code that implements the decision table. The window presents a read-only preview of the Java that implements this rule instance. This Java code is not identical to the Java that executes at runtime, which includes Java code inlined from other rule instances and reflects rules in the requestor's RuleSet list.

Special processing with Declare Expression calls

When a Declare Expression rule has Result of decision table for the Set Property To field, special processing occurs at runtime when a property referenced in the decision table is not present on the clipboard. Ordinarily such decision rules fail with an error message; in this case the Otherwise value is returned instead. For details, see PDN article Troubleshooting: Declarative Expression does not execute when a decision rule provides no return value.

Not declarative

Despite the class name, the Rule-Declare-DecisionTable rule type does not produce forward or backward chaining. Technically, it is not a declarative rule type.

About Decision Tables