Tuesday, December 29, 2009

MSCRM: Using SQL to Find an Entity Description

A client asked: How do I access the description of an entity? Where is it stored?

Due to multilingual support in Microsoft CRM, there is a localized label table used to store the entity description value (and entity label) that you must query. The sql statement to access the description of an entity is below. 1033 represents the English label value.

Substitute the entity name for which you need the description at the end of the last line. The example below uses account:

Select Label from MetadataSchema.Localizedlabel
where LanguageId = '1033'
and ObjectColumnName = 'Description'
AND ObjectId = (select entityid from MetadataSchema.Entity where Name = 'account')

Run the query above in SQL Management Studio against your CRM database.


Anonymous said...

Hey David

Is it possible to access the entity name through a filtered view?


Kimberly McNeeley said...

State funded school examines in the later past have gone under reactions that essaythinker research paper writing service the folks and educators are not ready to adhere to an educational program that will be of profit to the understudies.

Harry smith said...
This comment has been removed by the author.
Harry smith said...

You have done really well work. Please update some more great post because your post too good. Buy new Gym Mats and Gymnastics Mat from http://gymnasticmatsuk.co.uk/

xumeiqing said...

omega seamaster
skechers shoes
adidas shoes uk
adidas stan smith
nike free runs
coach outlet online
oakley sunglasses
coach outlet
levis jeans
true religion jeans
rolex replica watches
nike air force white
louis vuitton outlet
nike huarache white
nike blazer
ghd hair straighteners
louis vuitton outlet
ray ban outlet
lacoste shoes
toms shoes
fitflops clearance
holliste sale
canada goose
michael kors outlet online
lacoste outlet
rolex watches
canada goose outlet
polo outlet
north face jackets
nike free flyknit 4.0
michael kors outlet online
ray-ban sunglasses
ray ban outlet
burberry handbags

Zheng junxai5 said...

true religion sale
discount jordans
adidas running shoes
christian louboutin outlet
jordan 11
coach factory outlet
asics running shoes
hollister kids
true religion jeans
louis vuitton outlet online
jordan 6s
ralph lauren
adidas wings
ray ban sunglasses uk
nike roshe run
kate spade outlet
air max 95
true religion outlet
nfl jerseys
michael kors handbags
nike air max 90
ray bans
ray ban outlet
michael kors handbags
louis vuitton bags
lebron 12
louis vuitton
nike store
nike store uk
adidas originals
christian louboutin sale
ray ban sunglasses outlet
adidas superstar shoes
michael kors handbags
oakley outlet
michael kors outlet
michael kors outlet
coach factory outlet online

Fangyaya said...

designer handbags
air jordan shoes
coach outlet
kate spade handbags
fitflops sale
toms outlet
cheap oakley sunglasses
michael kors handbags
mont blanc pens outlet
michael kors outlet online
coach outlet
ugg boots on sale
hollister jeans
ray ban sonnenbrille
oakley sunglasses wholesale
kobe shoes 11
ghd hair straighteners
ugg outlet
concord 11
ralph lauren outlet
celine outlet
michael kors outlet clearance
supra footwear
golden state warriors jerseys
christian louboutin shoes
giuseppe zanotti sneakers
rolex submariner price
retro 11
christian louboutin sale
washington wizards jerseys
michael kors handbags
michael kors bags
nike store
michael kors outlet
nike tn pas cher
adidas yeezy
toms wedges
louis vuitton outlet
michael kors handbags
uggs for cheap

Thomas pedro said...

Be that as it may, hold up. There might be an answer. You might have the capacity to get a house, which meets your needs, needs, and goals. You might have the capacity to have a house that is inside your financial plan. You might have the capacity to beat the issues, which were made by these careless mortgage holders. Payday Loans Chicago

Thomas pedro said...

For sure, you might have the capacity to meet your targets and in the meantime really buy one of these homes, which have recently abandoned you disillusioned and needing for additional. Payday Loans Chicago

chenlina said...

louis vuitton outlet
nike air max
the north face jackets
louis vuitton handbags
red bottom shoes
oakley sunglasses
ray ban sunglasses
michael kors
louis vuitton outlet stores
cheap mlb jerseys

marko said...

Actually, developing by the uptrend in the advantage based loaning, it is relied upon to become much more later on. The general volume of independent venture advances has been sliding down as indicated by FDIC. Payday Loans Corona