Clarity Studio Object views published accidentally - Is there a way to restore from backup?
search cancel

Clarity Studio Object views published accidentally - Is there a way to restore from backup?

book

Article ID: 139737

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We lost all the custom configuration in PROD.
 
Is there a way to fix this situation retrieving the data for custom configurations from the backup?

Environment

Release : All Supported Releases

Resolution

Unfortunately a partial backup restore isn't possible for just one particular area.

  1. The one suggestion would be to restore a non production environment with a copy of the impacted environment backup data from prior to the publishing.
  2. Then, the users who customized their views can log in to non production, and use that to reconfigure their views in the impacted environment. 

 

Additional Information

Query to identify the users who customized their list views:

select dal_code, cg.code, u.user_name , u.first_name||' '||u.last_name Who , cg.last_updated_date When_Customised
from cmn_grids cg
inner join cmn_sec_users u on cg.principal_id = u.id
and principal_type = 'USER' and u.USER_STATUS_ID = 200
and cg.code is not null