Template =No in MUX Project Grid filter causing very slow performance

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

A MUX Project Grid view can become significantly slower or times out when Template filter is added

STEPS TO REPRODUCE:

1. Go to MUX Project Grid as admin user
2. Create a new view returning 200 results
3. Add Template =No as one of the filters

Expected Results: View to be fast as we are adding filtering so less results to return

Actual Results: View is significantly slower, in some cases can take many minutes & can time out

Environment

Release : 16.0.2, 16.0.3

Resolution

This is DE65855, fixed in 16.1.0

Workaround: Remove Template =No from the View filter