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

Filter criteria issue in grids



In a database table there is a column with data type decimal, when using a repeating grid with a filter configuration and a data page as the data source for that particular column the value is rounded off.

For example, if the value in database table is 2500.67 then in the repeating grid it is displayed as 2501. In the filter it shows the rounded off values, but when using "from and to" in the filter and entering the range 2501 to 3500 then it does not pick
2500.67 (displayed as 2501 in the repeating grid) as it filters the values on the basis of the database contents.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a grid and add a column of number/integer type.
  2. Add a filter to it.
  3. Run and enter any value present in the grid and apply the filter.
  4. The result set now will exclude the number which is entered.

Root Cause

The display values of a number control in the column of a repeating grid are not being honored whenever range filtering is used.


Round off the value when populating the grid source example: use a function to round off the value in the report definition or use a data transform to round off the value while populating a datapage.

Published May 1, 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