• 1.  Publishing Views

    Posted Jul 24, 2013 02:10 AM
    Hi Everyone,

    We upgraded our clarity system from V12 to V13. My project manager wants to publish the views for project and other work object.
    But other users are having their own configuration in views. How can we get back the users personal configuration after publishing the views?

    Please let me know your views.

    Any help would be appreciable.

    Madhuri Thakur

  • 2.  RE: Publishing Views

    Posted Jul 24, 2013 02:25 AM
    In theory you could XOG read those views and write them back. The challenge is to define the content pack view query correctly.
    You could also read the objects and clean the xml files to contain only those views you want.

    You could also query the cmn_grids table to see if you get the users who have actually configure personal views and instruct them to record their view definitions.

    You can search this forum for more ideas.

    Martti K.

  • 3.  RE: Publishing Views

    Posted Jul 24, 2013 03:41 AM
    Check the below -

    Avoid overwriting user's custom view when publishing new view

    CA Clarity Tuesday Tip - When to use the 'Publish' button

    Query to return which users have adjusted their 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 =
    where dal_code='teams'
    and principal_type = 'USER' and u.USER_STATUS_ID = 200
    and cg.code is not null


  • 4.  RE: Publishing Views

    Posted Jul 24, 2013 07:57 AM

    Thanks for your quick response.

    The query you provided, will retrieve those users who personalized their views (that is great. thanks for that).

    But here is one question,how can we get the details of the personal views of the individual users?.

    (I think xog will give admin side views not personalized views) Please correct if I am wrong.

    Please help me out.

    Thanks in advance!!!!!

    Madhuri Thakur

  • 5.  Re: Publishing Views

    Posted Mar 11, 2015 09:05 AM

    Updatet link to

    Query to return which users have adjusted their views

    is today

  • 6.  RE: Publishing Views

    Posted Jul 24, 2013 10:03 AM
    An idea has been already requested for this functionality

    Ability to Save Portlet Configuration as a Part of a Filter

    As suggested above, you could could also try the XOG route.

  • 7.  RE: Publishing Views

    Posted Jul 25, 2013 03:03 AM
    When you XOG out views - say the views of and object - you also get the user customized views.
    In most of the cases you don't want that, but just the standard views, because that can increase the sized of the xml file considerable.

    Martti K.