Projects filters are missing in a saved view
search cancel

Projects filters are missing in a saved view

book

Article ID: 212564

calendar_today

Updated On:

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