MarkMpn / Sql4Cds

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

Virtual entity errors #503

Closed MarkMpn closed 1 month ago

MarkMpn commented 1 month ago
select *
from msdyn_componentlayer
where msdyn_solutioncomponentname = 'Entity'
and msdyn_componentid = '70816501-edb9-4740-a16c-6a5efbc05d84'

(see #152)

select *
from msdyn_solutioncomponentsummary

(see https://www.linkedin.com/posts/gasenko-valentin_powerplatform-microsoft-dataverse-activity-7213947987113193473-7Lbh)

fail due to values being returned that don't match the metadata, e.g. different types, too-long string values or attributes have different casing than the metadata logical names.

Some query operators that get folded into FetchXML aren't respected, e.g. order, top, distinct