Thursday, May 20, 2010

Where to find values for Picklist Items

When I finally get to reporting, I will need this more, but I also need this for some other data import work I am doing.

Just discovered how to get the actual picklist int value when you know the name.  You have to look in the StringMap table and link it to the MetadataSchema.Entity table (which I still can't find in the SSMS object browser, but it must be somewhere) on the ObjectTypeCode in each one.

SELECT s.*, ' ', e.*
FROM StringMap s
INNER JOIN MetadataSchema.Entity e ON s.ObjectTypeCode = e.ObjectTypeCode

Found it on this blog:

No comments:

Post a Comment