Support Article

Last X Days not accepting values other than predefined(e.g 7,30)

SA-64438

Summary

When defining the date filtering value for 'Last X Days' in a report definition, an error displays for any value other than the predefined periods (for example, last 8 days, last 31 days).

Error Messages

Filter Value - ** An invalid comparison value or an invalid column has been entered for the right-hand side of a filter condition. Enter a valid column, calculation, or literal value.

Steps to Reproduce

Create a report definition
Add a DateTime column.
Use the Last X Days function.
Enter any value other than 7, 30, 60, etc.

Root Cause

A defect in Pegasystems’ code or rules.

The Last X Days and Next X Days options were introduced erroneously after creating pySymbolName.Next X Days or pySymbolName.Last X Days for the supporting template grid filtering options.

In the pzdisplayTimePeriod control, all field values in the 'Embed-ReportingPeriod' class name with pySymbolName Field Name are returend.