Support Article
Unable to filter blank values in a Table grid
SA-81424
Summary
Unable to filter blank values in a Table grid.
![](https://gcsprdsa.lab.pega.com/articles/datacontent/Image/rteImages/table_blank1559829759433.png)
![](https://gcsprdsa.lab.pega.com/articles/datacontent/Image/rteImages/table_blank11559829776553.png)
Error Messages
Not Applicable
Steps to Reproduce
- Create a table layout.
- Populate sample data with blank values in some columns in the layout.
- Enable the out-of-the-box Filtering on the table.
- Filter the column that has blank values. Records are not selected.
Root Cause
Space was added in the column and it was displayed as null in the UI. The space was getting added to the columns which has null value in the data base level.
Resolution
As a local-change, handle the null values at the database level where the space is appended to the null values in the table.
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.