Filter values for years greater than 2049 is not working as expected in MS SQL systems
search cancel

Filter values for years greater than 2049 is not working as expected in MS SQL systems

book

Article ID: 396162

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

In system using an MS SQL database when filtering for years greater than 2049, the filter does not function as expected—it returns all projects instead of only those beyond 2050. However, filtering for years up to 2049 correctly displays the expected results.

Steps to Reproduce:

  1. Login to a system using MS SQL database
  2. Navigate to New UI
  3. Access Projects menu -> Grid view
  4. Make sure there are few project with Finish Date greater then 2050
  5. Add a filter on Finish date field for year after 2049
  6. Observe that only the project greater than the selected finish date are displayed
  7. Now update the Finish date filter condition to display projects with Finish date greater than 2050


Expected Results:
Project with Finish date greater then selected date (greater then 2050) are displayed

Actual Results:
Filter is not applied and all the projects are displated

Environment

v16.3.1

Cause

Due to DE170044

Resolution

DE170044 is fixed in v16.3.3

Powered by Wolken Software