查询选项集所有字段(说明)

select AttributePicklistValueid
,label
,OptionSetView.Name
,AttributePicklistValueView.Value
--,AttributePicklistValueView.ExternalValue
,ObjectColumnName
from LocalizedLabelView
join
AttributePicklistValueView
on AttributePicklistValueView.AttributePicklistValueid = LocalizedLabelView.objectid
join
OptionSetView
on
OptionSetView.OptionSetId = AttributePicklistValueView.OptionSetId
--where OptionSetView.IsGlobal =1 and LocalizedLabelView.label <> ''

where OptionSetView.Name like '%new_oppst%'

order by OptionSetView.Name