How to correct the Not Column or Scalar warning for list view rules
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 Type | Warning Type | |
---|---|---|
Rule-Obj-ListView | Performance | |
Name | Not column or scalar | |
Message | These 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. | |
Severity | 2 |
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.