@IchsanM16625601

Please see the suggestion given on our MSP GenAI Buddy:

⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.

Based on the error you shared ("The reference .pyTextValue(2) is not valid. Accessing invalid index 2 whereas the list has 0 elements from Requestor: null"), there appears to be two interrelated issues occurring:

1. Filter Logic Behavior: There is a known issue in Pega where the filter logic does not consider the filter by value setting and instead uses the pyUILabel property by default for showing unique values in the filter pop-up. This can cause problems when using functions like .pyTextValue() in column definitions.
2. Index Access Issue: The error specifically indicates that when the system tries to access index 2 of the pyTextValue list, it finds that the list has 0 elements. This explains why .pyTextValue(1) works while other indexes fail. It seems the filter functionality attempts to access the list values differently than the regular column display.

The section 'pzGetGridColUniqueValues' that's generating the error is responsible for populating the filter dropdown with unique values from the column. When it encounters .pyTextValue() with indexes other than (1), it appears to be unable to process the values correctly.

Possible solutions:

1. Column Configuration Workaround: Since you've noticed that .pyTextValue(1) works correctly, consider restructuring your Report Definition to use this index instead of higher indexes when possible.
2. Alternative Property Access: Instead of using .pyTextValue(2) directly in the column, you could create a calculated property in your data model that extracts and formats the desired value, then reference this property in your column definition.
3. Custom Filter Implementation: For critical columns where filtering is essential, you might need to implement a custom filter solution using JavaScript and the grid's API if the built-in filtering cannot be fixed.

References:

• Duplicate value are displayed on filter
• Table column filter popup value doesn't showing properly