zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

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

DatabaseSQLServerOn for to CRM How SELECT
2023-09-11 14:21:33 时间

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'