Dynamics 365 SQL - Global OptionSet Sorgulama

SQL Sorgu

SELECT OS.NAME, L.LABEL, AV.VALUE
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 L.OBJECTCOLUMNNAME = 'DISPLAYNAME'
AND OS.NAME ='<Provide Global OptionSet Schema Name>'