Projects filters are missing in a saved view

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

In some views, some filters have been set up. After making a change in the view and clicking on the filter icon to see the filter logic, nothing is displayed. 

Environment

Release : 15.9.1

Cause

The filter is corrupted.

Resolution

1. Get the CMN_SEC_USERS.id of the user having the issue.
2. Run the below query:
   
   SELECT * FROM
odf_ui_views a,
odf_ui_view_settings b
WHERE a.id = b.view_id
AND b.name = 'advFilter'
AND a.type = 'projects'
AND b.last_updated_by IN (enter_resource_id)
order by b.last_updated_date DESC
   
   
3. As the missing filters cannot be recovered, have the impacted end-user delete the filter via the UI. At this time, this is the only solution.

For assistance with this issue, please open a case with Broadcom.

Additional Information

See also: MUX views / flyouts - master KB of known issues