Skip to main content

Hi, I’m confused on how to select the dynamic fields. When I look in the driver ui, I can see the dynamic fields like “createdbyname” which are populated based on the values in “createdby” - but if I try to query using `select createdbyname from account` I get an error: “Query failed: e0x80060888] Could not find a property named ‘createdbyname’ on type ‘Microsoft.Dynamics.CRM.account’”

 

Is there something special I need to do to be able to do this? In TSQL with ssms I can select these fields without issue. Reading through the docs, I don’t see a driver setting that seems like it would enable this feature. Can anyone tell me what I’m missing? 

@DaveJones4 , Thanks for reaching out to us.

As per your query, I ran a similar query on my end and encountered the same error. This suggests there may be an issue within the driver. I’ll conduct additional tests to confirm and keep you updated as soon as possible. Ideally, the query you wrote should retrieve the records without any issues.


Thanks for the reply, hope we see a fix soon!


@DaveJones4 ,

In order to fix the issue, I have opened up the thread with our engineering team on this and will keep you posted as soon as possible
I appreciate your patience on this.


@DaveJones4 ,

The team has fixed the issue and now the driver seems to working fine as expected.
In order to provide you with an updated build, could you please send mail to [email protected] , so we can share you the updated build of Dataverse ODBC Driver.
Please add the community URL link of this topic in the mail chain for ease