MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

The 'RetrieveMultiple' method does not support entities of type 'optionset' #436

Closed sybaris closed 3 months ago

sybaris commented 6 months ago

Hi,

The following SQL "select top 10 * from optionset" returns an error "The 'RetrieveMultiple' method does not support entities of type 'optionset'. MessageProcessorCache returned MessageProcessor.Empty."

image

Regards Sybaris

MarkMpn commented 3 months ago

Correct, this table appears to be impossible to retrieve any values from. Global optionsets are available through the metadata schema` though if that helps.