When a user has more than 300 completed to-dos, no to-dos are shown under the "open" tab in the Service Portal - Known Error

When a user has more than 300 completed to-dos, no to-dos are shown under the "open" tab in the Service Portal Description This affects instances on version New York before Patch 10 and on version Orlando before Patch 5

When a user has more than 300 completed to-dos (which typically have due dates that are prior to open to-dos), no to-dos are shown under the Open tab despite the user having open to-dos.

The problem exists because too many records are queried at a time for each tab and the over-all limit of 300 to-dos is reached prematurely. Since completed to-dos typically have an earlier due date than open to-dos, they are fetched first.

Steps to Reproduce

Log in as a user with to-dos. Make sure the user has more than 300 completed to-dos and at least one open to-do. Navigate to the ESC portal and click "To-dos" Observe: There are no to-dos shown under the "Open" tab.

Workaround Navigate to Employee Service Center -> Administration -> To-dos Configuration. For each configuration record for the Completed tab (i.e. "Tab=Completed"), add a query that limits the number of results; for instance: "Due date after 3 months ago". This way the to-dos queries will not retrieve every completed item and will leave room for open to-dos.