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

Grid Filter does not work if the value has quotes at both ends

SA-19280

Summary



A repeating grid is used to display the workbasket contents. When user tries to filter a column with values in double quotes, no result is displayed.
For example, if the value to be filtered is "Alpha", nothing is displayed.


Error Messages


None displayed in the screen.


Steps to Reproduce

  1. Create a Repeating grid.
  2. Source the data from any varied source Report or Data page.
  3. The source should have a text column for which values are like "Alpha",Alpha,Al"pha".
  4. Try to use filter for the columns to see if results are filtered properly.
  5. Filtering for "Alpha", the result displayed are Alpha and not "Alpha".


Root Cause



This behavior is as per the design. As per the internal code, PRPC internally strips the outer double quotes for a value whilst filtering.
Hence "Test" will be returned as Test, and ""Test"" will be returned as "Test".

Resolution



Use single quotes instead of double quotes, for example 'Test' or add another set of double quotes to the values like ""Test"".

Published February 9, 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