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
- Create a Repeating grid.
- Source the data from any varied source Report or Data page.
- The source should have a text column for which values are like "Alpha",Alpha,Al"pha".
- Try to use filter for the columns to see if results are filtered properly.
- 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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.