Support Article
Filtering on grid column throws error
SA-29156
Summary
The develper has a grid column with a function alias and formatting in order to sort case IDs numerically. When the column is from a class join, trying to bring up the filter popup results in an error:
Error Messages
Array index out of range: 2
Steps to Reproduce
Define a function alias to return the numeric part of a case ID:
This allows the case IDs to be sorted numerically rather than as text.
Define a control to add the prefix back onto the numeric ID:
This will restore the case ID to its original format after sorting.
Use these in a report definition on a column that comes from either a join or a sub-report.
Root Cause
A defect in Pegasystems’ code or rules: Filtering on a function alias for a joined property is not supported in this release.
Resolution
An enhancement request, FDBK-16938, has been created for consideration by Pega Product Management.
Published October 25, 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.