Performance of Modern UX Timesheet Grid Layout Slow - PostgreSQL only

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Performance of modern ux timesheet grid is slow when updated by columns is added in the grid view 

Steps to Reproduce: 

1. Login to Clarity Modern UX Navigate to Timesheet Workspace
2. On the timesheet grid, navigate to columns and add 'Updated By' columnFilter for timesheet data 

Expected Results: The dataset fetched on the grid should be fast. 

Actual Results: The dataset fetched takes longer time when updated by columns is added to the grid. 

Environment

Release : 15.9.2 15.9.3

Cause

DE62405 -    

• The query executed in the grid view has the column PRMODBY as part of select query.  

Workaround:

• Remove the updated by column from the timesheet grid 

OR

• Remove the timesheet grid module using the blueprint functionality

   

Resolution

Fixed in Clarity 16.0.0 and 15.9.3.1