Error when querying for column msdyn_AgentType in System User table

[n0rthface]

Hi Mark,

I do not know if this issue only occurs with this specific column or if it is more general issue with SQL 4 CDS 7.4 and XRMToolBox 1.2023.6.65.

When using FetchXML queries being generated by SQL 4 CDS, I receive an error message for the following statement because the logical name casing deviates between attribute name and condition attribute element values. It is possible to query for the attribute without it being used as a condition attribute.
Please have a look if this needs a fix.

SQL
SELECT su.msdyn_agentType FROM systemuser su WHERE su.msdyn_agentType = 192350000;

FetchXML
<fetch xmlns:generator='MarkMpn.SQL4CDS'> <entity name='systemuser'> <attribute name='msdyn_agentType' /> <filter> <condition attribute='msdyn_agenttype' operator='eq' value='192350000' /> </filter> </entity> </fetch>

Error
'SystemUser' entity doesn't contain attribute with Name = 'msdyn_agenttype' and NameMapping = 'Logical'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False...

Thanks Hauke