Last X Days not accepting values other than predefined(e.g 7,30)
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).
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.
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.
After installing the hotfix, Last X Days and Next X Days options are not listed as options for selection.