Clarity

Hi All,

Is there any way to preserve user's customization for portlets when these portlets are restored from admin side?

To solve one of our issue, i.e after upgrade to 13.3 patch 7, all four portlets present on a custom page are appearing twice or thrice. So, to correct them we have to publish them again from the admin side.But, this page is heavily used by the users and they have customized these portlets filter according to their needs.

So, we want that if it can happen after re-publishing these portlets we can restore the user's customization.

Thanks,

Pragya Singh

Have you checked these ?

https://communities.ca.com/message/101452024#101452024

https://communities.ca.com/message/98770428#98770428

https://communities.ca.com/message/99230784#99230784

https://communities.ca.com/message/101601874#101601874

https://communities.ca.com/message/98286958#98286958

NJ

Hello,

I went through all the posts mentioned and can conclude two things:

1. The query to find out the users who have configured their portlets : (to analyse the impact of restoring portlets)

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

principal_type = 'USER' and u.USER_STATUS_ID = 200

and cg.is_custoimized=1

But, we could not found the list of users who have configured only filters (saved filters)? I have also checked ODF_VIEWS table but correct list cannot be filtered out.

2. We can try out xogging portlets and can check if user customizations are also xogged out or not.

Has any one tried this ? and how to get users list who have only configured portlet filters?

Thanks,

Pragya Singh

sparc.helpdesk wrote:

 

But, we could not found the list of users who have configured only filters (saved filters)? I have also checked ODF_VIEWS table but correct list cannot be filtered out.

 

From thread Best Practices for Migrating Portlet Configurations ;

"Portlet LIST configurations are in the CMN_GRIDS table.

Portlet FILTER configurations are in the ODF_VIEWS table. ( the code on that table is the portlet id)"

Hello David,

To retreive saved filters information from  ODF_VIEWS, I saved three filters for Weekly details, Resource workload and  Role Capacity portlets.

When I checked ODF_VIEWS, none of the filters information was present in this table.

Actually I found the new filter names along with the portlet name in  "cmn_attribute_value_sets" table.

  a.*

FROM     cmn_attribute_value_sets a

WHERE    view_code is not null

and   a.user_id = 5507965  order by a.name

Here, view code is PORTLET_ID.

Some customization information is there in ODF_VIEWS table for project list and resource list pages w.r.t my account. May be I have configured few fields in the filter section of these page, so customization is showing in this table.

Thanks,

Pragya Singh

OK I think I am talking about configured filters not saved filter "sets".

Saved filters are all in the cmn_attribute_value_sets and cmn_attribute_values tables (as you have found).