Use the below select query to get the Global OptionSet values in SQL,
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>'
Discover more from Arun Potti's Power Platform blog
Subscribe to get the latest posts to your email.
Howdy siblings simply love your awesome website and pls don’t stop!
Thank you so much! This is a very good web-site!.
This post isrReally helpful Arun.