Support Article
Filter criteria issue in grids
SA-22648
Summary
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
- Create a grid and add a column of number/integer type.
- Add a filter to it.
- Run and enter any value present in the grid and apply the filter.
- 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.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.