SA-19655

Summary

Exposed decimal values in a Page List are rounded down to the nearest integer when indexed.
For example, 1.246 is recorded as 1 in the index table.

Error Messages

Not Applicable

Steps to Reproduce

1. Create a Page List with Decimal type properties.
2. Expose the Page List to use it in Declare Index.
3. Create a work object with multiple rows in the Page List with decimal values.

Root Cause

The decimal value column in the index table is defined as a NUMBER, with no precision or scale values defined, instead of NUMBER(18,9). This type is given to Decimal columns when indexes are created through Developer Studio and uses Optimize for reporting functionality. 

Resolution

 

1. Update the column in the index table to type NUMBER(18,9).
2. Open the Database Table instance for required index class. It looks similar to the screen shot given below.
3. Change the Table name to another table like PR_INDEX, and save the rule.
4. Click Test Connectivity to ensure the mapping shows as PR_INDEX.
5. Change the Table name back to the original index table, and save the rule.
6. Click Test Connectivity button to ensure the mapping shows as the correct index table.
7. Retest the required index.