Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

How to correct the Not Column or Scalar warning for list view rules

Suggest edit Updated on September 20, 2019

Summary

Remediate this high-priority warning before using the rule in a production environment.

In v5.4 sp2 or greater, use the Download High Priority Warnings option in the Application Preflight tool to research all high-priority warnings in your application. As a best practice, perform the preflight check before you lock a RuleSet version.

Rule TypeWarning Type
Rule-Obj-ListViewPerformance
NameNot column or scalar
MessageThese properties are neither database columns nor scalar properties in database tables and can adversely impact performance: < .property (in database table)>.

Read-only mode can not be used. (appended to above if you select Read-only on the Content tab).

Details

<n> properties

where n equals the number of properties that are causing the warning condition.

Severity2

 

 

 

Suggested Approach

This message indicates that one or more properties in your report are either embedded (page, page list, or page group) or they are single-value properties that are not exposed as columns in the appropriate database table. These property values are stored in a BLOB column in a compressed form. Such properties cannot support selection in list view and summary view reports, and can slow retrieval and processing in other operations.

  • For single-value, non-embedded properties, you can directly change the schema of the storage tables by adding new columns for the properties. Use the Modify Database Schema wizard to expose the properties (select Tools > Database > Modify Database Schema in the Developer portal). Refer to Developer Help for information on how to use the wizard.
  • For complex or embedded properties, you must use declarative indexing to expose the properties. To create a Declarative Index rule, use the Declarative Index wizard. See How to create Declarative indexes for embedded properties for information on how to use the wizard.

Tags

Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare Insurance Media and Advertising Government Life Sciences Utilities Hospitality and Entertainment Manufacturing Retail
Did you find this content helpful? YesNo

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.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us