Dynamics 365 SQL - Global Optionset Sorgu

SQL 'de Global OptionSet değerlerini almak için aşağıdaki sorguyu kullanın.

SELECT OS.NAME, L.LABEL, AV.VALUE
FROM AttributePicklistValueAsIfPublishedLogicalView as AV
JOIN OptionSetAsIfPublishedLogicalView  as OS ON AV.OptionSetId= OS.OptionSetId
JOIN LocalizedLabelAsIfPublishedLogicalView as L ON L.ObjectId = AV.AttributePicklistValueId
WHERE OS.ISGLOBAL = 1 AND OS.IsCustomOptionSet = 1
AND L.OBJECTCOLUMNNAME = 'DISPLAYNAME'
AND OS.NAME ='<Provide Global OptionSet Schema Name>'