7/9/2025 12:36:15 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
User Added Picklist Values
Posted: 12 Sep 07 11:34 AM
|
Hello, does anyone know where the picklist values that are added by the users are stored. I have a picklist that was open for user edits and I just locked it down to standardized values and I want to clear the user values and reset the list.
Thank you. |
|
|
|
Re: User Added Picklist Values
Posted: 12 Sep 07 1:05 PM
|
Picklists and their values are all stored in the PICKLIST table in SalesLogix. The table contains two different types of records, representing the list itself, as well as the values in that list.
This script will give you the common ID for all items in a particular list.
select itemid from picklist where text = '(your picklist name') (All top-level picklist records in that list will have a picklistid value of 'PICKLISTLIST')
AFter you have the itemID, you can use that to find all enteries for that list in the DB. All user-defined values should have a userid value other than 'Admin'
select * from picklist where picklistid = '(itemid from above statement)' and userid <> 'Admin'
|
|
|
|
Re: User Added Picklist Values
Posted: 12 Sep 07 1:34 PM
|
All picklist items are stored in the Picklist table.
When you log in as Admin you can see all items on the Picklist Manager, but off course, it is hard to identify which ones are User Added.
Your best bet is to go against the table, but remember that if you make changes directly on it, the changes will not synchronize.
To view all the items on a picklist, run the following statement:
SELECT * FROM PICKLIST WHERE PICKLISTID IN (SELECT ITEMID FROM PICKLIST WHERE TEXT = 'HERE GOES YOUR PICKLIST NAME')
I would recommend that you define your Target list of values after reviewing the list, and then proceed to just remove all values, then adding your new values, specially if you have remote users or offices that will require the data to be synchronized down to them.
Also, keep in mind that you don't want to set the "Text Must Match a List Item" until after you have cleaned up the data, otherwise you will be lose data on records where you don't have a match.
In other words, define your Target values and your translation from current to new values.
Update your picklist
Clean up your data
Set the "Text Must Match..." property
By following the steps outlined above on that order you will avoid any casual data loss. |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|