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

Filtering on grid column throws error



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.


An enhancement request, FDBK-16938, has been created for consideration by Pega Product Management. 



Published October 25, 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