Skip to main content

Table of Contents

Exposing properties and populating database columns


Only available versions of this content are shown in the dropdown

You can expose a property as a database column, and populate the new column by extracting values from the Storage Stream (BLOB or pzPVStream) column using the Property Optimization tool in a development system. You can also use this tool to "expose" values of an embedded property by automatically creating an appropriate Index- class and Declare Index rule.

To expose and populate a property, or to view the status of column population jobs, your access group must have the SchemaPropertyOptimization privilege and the dynamic system setting database/AutoDBSchemaChanges must be true.

You can view the classes for which a property has been optimized on the Advanced tab of the Property form.

  1. Using the Application Explorer, expand the Data Model node and the Property list.

  2. Right-click a property name and click Optimize for reporting.

  3. Select the tables in which you want to create a dedicated database column for this property. You must select at least one table.

  4. If the property is embedded, specify the RuleSet and Version that is to contain the new Index- class, the properties in that class, and the Declare Index rule.

  5. Select whether to optimize the property now or later. If you select later, click the calendar icon to select a date within seven days of the current date to optimize the property.

  6. Click Next.

  7. Review the tables to which the property column will be added and the classes that will be mapped to each table.

  8. Click Next.

  9. Click Finish.

Background processing may take minutes or longer, depending on volume, and computations in your applications involving the property value may fail or produce incorrect results until all background processing is complete.

You can view the status of your background job by clicking Configure System Database Column Population Jobs .

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us