which table Picklist integer value stored?

which table Picklist integer value stored?

Post by Kyaw » Tue, 13 Dec 2005 12:40:08


Hi there,

Which database table pick list interger values stored?

thanks
Kyaw
 
 
 

which table Picklist integer value stored?

Post by rakes » Tue, 13 Dec 2005 23:22:36

this query will list all the pick list integervalues and attribute
name

select AttributeName,AttributeValue,Value
from StringMap
// for account
WHERE (StringMap.ObjectTypeCode=1)
//for contact
WHERE (StringMap.ObjectTypeCode=2)


attributename will tell u about the name of the picklist
attribute value is the intigers
and values are what u can see on the form
i think this will help u