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.

Support Article

Exposed decimal value columns rounded down to nearest integers

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.

 
 

Published February 11, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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