2 Replies Latest reply on May 14, 2010 8:34 PM by Stephane Gervais

    setting user preferences

    jjacobs2005

      is it possible to change user preferences (manage dipslay columns) either globally (for all users) or for groups? So far, i have not been able to find a way of doing this!

        • 1. Re: setting user preferences
          $Nith$ Level 4

          There is no straight way to do this. Rather, you can modify the tb_ws_properties table. See the following queries.

          You can copy the preference of one user and update for all users in the domain.

           

          Updating the To Do Column order for all Users as same as the User XXXXXXXXXX

           

          UPDATE tb_ws_properties SET propertyvalue=(SELECT property_value FROM tb_ws_properties WHERE property_name='XXXXXXXXXX/client/listview/Default Options for To Do') WHERE property_name LIKE '%client/listview/Default Options for To Do'

           

           

          Updating the Tracking Column order for all Users as same as the User XXXXXXXXXX

          UPDATE tb_ws_properties SET propertyvalue=(SELECT property_value FROM tb_ws_properties WHERE property_name='XXXXXXXXXX/client/listview/Default Options for Tracking') WHERE property_name LIKE '%client/listview/Default Options for Tracking'

          Note:- Please be aware of the Adobe's support agreement before modifying this table. Replace XXXX with the user's OID (Principal Id)
          Take a backup before you run this query.
          Nith

          • 2. Re: setting user preferences
            Stephane Gervais Level 1

            While those queries may work for users who have logged in at least once to Workspace, users who haven't yet logged in to Workspace will get the default hardcoded properties.