search cancel

Portlets or object views customized by users

book

Article ID: 212973

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Is there a way to know what portlets have been customized by your users? This may be needed when you have to publish a portlet (Example: Resource Planning \ Workloads) but after publishing, your end user-related settings will get reset. You may want to send notifications to those who have configured / customized columns to warn them prior to publishing. If there is nothing available in the Clarity UI, is there a SQL query (or table) that can be provided to show the list of users that have customized their columns on the portlet?

Environment

Release : Any

Resolution

Out of the box, there is no view/function to check which out the box portlets have been changed by users. This can be checked by querying the database.

The following query can help to find who has configured their portlets:

select
p.id,P.PORTLET_CODE, cg.is_customized, dal_code, cg.portlet_id,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
left join cmn_portlets p on P.ID=CG.PORTLET_ID
where
cg.principal_type = 'USER' and u.USER_STATUS_ID = '200'
and cg.is_customized = 1

Additional Information

See also the following communities discussion: How to preserve user's portlet customisation