About the Data Table wizard

Developers can use the Data Table editor to add, update, or delete instances of a concrete class derived from the Data- class for which no form is defined, or other classes for which an Excel template rule is defined. This facility allows easy entry and maintenance of data instances for classes that have a simple structure. See Editing a Data Table class.

Developers can create additional Data Tables to edit with the Data Table wizard. You can use the wizard to create an edit form for any class that meets these requirements:

• Derived from the Data- base class
• Contains only properties of mode Single Value
• Does not require user input for properties inherited from any higher classes
• Contains a Single Value property that defines a unique key

After a data table is defined for the class, developers can maintain instances of the class using either an HTML form or an Excel spreadsheet.

Don't attempt to create a Data Table class derived from the Work- base class. Work objects are not designed to define reference data, though they may contain properties that have values from Data Tables.

The system is initially limited to 200 data tables. This limit can be increased if needed.

To create a class, properties, and editor

To create new Data Tables:

1. Select Application > Data Tables to access a list of existing Data Tables in your system.
2. Click  Add   at the bottom of the form.
3. Complete the form to define the class and properties in the class. See Using the Data Table wizard.

Database Table

By default, instances of classes created through this facility are stored in the PegaRULES database table named pr_other and are limited to 1,000 rows.
If your data table may eventually contain hundreds of rows, has high turnover, or may be moved to other Process Commander systems, it is advisable to have the database administrator create a new table for the data table class. The column structure of the new table can be the same as the columns in the pr_other table, or can expose additional scalar properties as desired. After the new table is created, create a database table instance (Data-Admin-DB-Table) that links the Process Commander class with the new table.

About Access of Role to Object rules Troubleshooting Excel

Tools, accelerators, and wizards