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: [0x80060888] 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?
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.
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.
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 support@cdata.com , 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
This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media.
Review section III of our Privacy Policy for more information on cookies.
To opt out of “sale” or “sharing” of non-cookie data, visit our Privacy Rights Request Form.