About the Data Table wizard

03-02-50 C-426 Use the Data Table wizard to generate a data table: creating the concrete class and associated properties and other rules. After you generate the data table, you can then edit it with the Data Table editor. Typically, developers 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 instances of other classes for which an Excel template rule is defined. The Data Table editor allows for easy entry and maintenance of data instances for classes that have a simple structure. See About the Data Table editor. PROJ-158

You can use the Data Table wizard to generate an edit form for a class that meets these requirements:

• Derived from the Data- base class
• Contains properties of mode either Single Value or Value List
• 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, you can maintain instances of the class using either a Process Commander HTML form or an Excel spreadsheet.

Any Value List properties cannot be maintained with an Excel spreadsheet. If an instance of the class has both Single Value and Value List properties, only the Single Value properties can be maintained with an Excel spreadsheet. OSMAE

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. SR-1384

The system is initially limited to 200 data tables. This limit can be increased if needed. SR-3521 B-20233

To create a data table

To create a new data table (concrete class and associated properties and rules):

1. Select>Data Model> Data Tables. A list of existing Data Tables in your application appears. kowal 03/08/10
2. Click Add a new Data Table .
3. Complete the Data Table wizard 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 preferably can expose additional scalar properties as needed. 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