setting user preferences

[Former Community Member]

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!

[_Nith_]

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

[Stephane_Gervai]

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.