API-1015 error on grids when filtering by date ranges

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

API-1015 error on grids when filtering by date ranges if a widget is present and the Manage Widgets option is on

STEPS TO REPRODUCE

1. Log in to MUX and go to any grid, let's say the project grid.
2. Open the filter and add the Start field
3. Start filter criteria must be Is Between (provide any date)
4. Add the Finish field
5. Finish filter criteria must be Is Between (provide any date)
6. Notice that the grid filters, regardless of this returning data
7. Create any widget and add it to the grid
8. Ensure the Manage Widgets option is enabled
9. Go to either the Start or Finish field on the filter and change the date

Expected Results: The data in the grid is filtered down with no errors
Actual Results: Data is filtered down, but an error pops up

Error: API-1015: Invalid filter string ') and ( scheduleStart <= '2024-05-22T23:59:59' )' . The '<=' is not a valid operator for the resource or attribute.

Cause

This is caused by DE80756

Resolution

Resolution for this use case will be covered by the work done for DE81005. Reference KB 370191: Widget performance is slow. 

Planned for Release 16.2.3 and for Patch #1 on 16.2.2 (16.2.2.1). 

Workaround: Toggle off the Manage Widgets option