The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Merging picklists of different users
Posted: 06 Jun 08 5:07 AM
|
Hello,
When few users edit (add new items) to some picklist, then all of them have different versions of picklist.
Is there built-in way to merge this changes so every user will see changes made by other users?
thanks! |
|
|
|
Re: Merging picklists of different users
Posted: 06 Jun 08 11:14 AM
|
No there is not. One approach is:
1. Use the following query to get the list of items for the picklist in question:
SELECT P.ItemId 'PicklistID' , P.Text 'Picklist' , C.Text 'Picklist Item' , U.UserName FROM sysdba.picklist P INNER JOIN sysdba.Picklist C ON C.PicklistID = P.ItemID INNER JOIN sysdba.UserInfo U ON U.UserID = C.UserID WHERE P.PickListID = 'PICKLISTLIST' AND P.Text = '[PickList Name Here]' ORDER BY 2 , 3 , 4
2. Identify the items that should be in the picklist and correct the picklist via the Picklist Manager. This will ensure that the records sync.
3. Delete the non-administrator items for that picklist using the Administrator Execute SQL feature: DELETE FROM PickList WHERE PickListID = '[PicklistID Here]' AND UserID <> 'ADMIN'
Please backup your database, test on a dev system first, etc. before running this. Since you are deleting data with SQL there is a risk that things could go awry. This is not a high risk in my opinion but it is wise to play it safe.
HTH,
Timmus |
|
|
| |
|
Re: Merging picklists of different users
Posted: 07 Jun 08 5:09 AM
|
I am polishing up an external app that deals with those kinds of picklist issues. It lets you have a user level admin take care of those issues easily without needing the admin password. No SQL required. You can contact me offline if you are interested
|
|
|
| |
| |
|