How to select a OptionSet on ms sqlserver database for Microsoft Dynamics CRM

OptionSet:

Select * from StringMap

 

Global OptionSet:

select  os.Name, l.Label from AttributePicklistValueAsIfPublishedLogicalView av

join OptionSetAsIfPublishedLogicalView   os

on av.OptionSetId = os.optionsetid

join LocalizedLabelAsIfPublishedLogicalView   l

on l.ObjectId = av.AttributePicklistValueId

where os.IsGlobal = 1 and os.IsCustomOptionSet =   1

and os.Name = 'new_xxx'

 

posted @ 2014-12-04 17:03  iDEAAM  阅读(352)  评论(0编辑  收藏  举报