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

Unable to filter blank values in a Table grid



Unable to filter blank values in a Table grid.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a table layout.
  2. Populate sample data with blank values in some columns in the layout.
  3. Enable the out-of-the-box Filtering on the table.
  4. 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.


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

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