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!
|
|
Picklist Table
Posted: 06 Feb 08 8:46 AM
|
I created a custom picklist and wanted to reference the table that stores the picklist name. What table stores the picklist definition (meaning the name of the picklist and its settings)?
Thanks,
John G. |
|
|
| |
|
Re: Picklist Table
Posted: 06 Feb 08 9:50 AM
|
Actually, no. The picklist table contains the list of items for a picklist. What I am looking for is the table that stores the picklist name and the definitions of the picklist (Sorted, Multiple Choice, etc).
John G. |
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 10:10 AM
|
It is the picklist table. The name of the picklist is stored in the picklist table. the piclistid will be "PICKLISTLIST"
the definitions like sorted, multiple etc are stored in the shortext field as some numbers.. u need to find out which number corresponds for which option.. |
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 10:39 AM
|
To be more clear, lets say you have a pickilst named 'Testing'
SELECT * FROM PICKLIST WHERE TEXT = 'TESTING' AND PICKLISTID = 'PICKLISTLIST'
in the result you can see the TEXT which is ur picklist name and SHORTTEXT which is your definitions. and if u want to see the items of your picklist then ...
SELECT * FROM PICKLIST WHERE PICKLISTID = (
SELECT ITEMID FROM PICKLIST WHERE TEXT = 'TESTING' AND PICKLISTID = 'PICKLISTLIST')
hope this helped.. |
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 10:54 AM
|
You are thinking about the actual pick list names. I am talking about the actual name of the Picklist. For example, when you are in the Pick List Manager and click the SalesLogix tab on the left you will see a pick list called
'Address Description (Account)'
What I am looking for is the table where the pick list name is stored. The pick list name is not stored in the picklist table.
|
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 11:16 AM
|
Hi John,
Sankar is right, it is the picklist table. It stores both the picklist names & definitions as well as the picklist items. The picklist names all have a picklistid of "PICKLISTLIST".
-Ryan |
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 11:25 AM
|
...just to be clear, if you wanted a list of all picklist names in the system, you'd run the following query:
select * from picklist where picklistid = 'PICKLISTLIST'
The shorttext field contains a code which represents the options for the picklist. |
|
|
|
Re: Picklist Table
Posted: 06 Feb 08 12:33 PM
|
Very interesting. I guess thats what was throwing me off. I was expecting the picklistid to be in another table like how all the other tabless are designed. Sorry for the confusion.
Thanks all!
John G. |
|
|
|