# Dataverse ODBC Driver - How to select dynamic fields **URL:** \ **Category:** CData Drivers\ **Tags:** dataverse, odbc-driver, sql, question\ **Created:** [November 5, 2024, 10:54pm UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934 "2024-11-05T22:54:26Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![DaveJones4](https://avatars.discourse-cdn.com/v4/letter/d/3bc359/32.png) [@DaveJones4](https://community.cdata.com/u/DaveJones4)\ **Post date:** [November 5, 2024, 10:54pm UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934/1 "2024-11-05T22:54:57Z")
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? ---
**Author:** ![PratikV](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/pratikv/32/1301_2.png) [@PratikV](https://community.cdata.com/u/PratikV)\ **Post date:** [November 6, 2024, 8:14am UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934/2 "2024-11-06T08:14:40Z")
@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. ---
**Author:** ![DaveJones4](https://avatars.discourse-cdn.com/v4/letter/d/3bc359/32.png) [@DaveJones4](https://community.cdata.com/u/DaveJones4)\ **Post date:** [November 6, 2024, 12:28pm UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934/3 "2024-11-06T12:28:17Z")
Thanks for the reply, hope we see a fix soon! ---
**Author:** ![PratikV](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/pratikv/32/1301_2.png) [@PratikV](https://community.cdata.com/u/PratikV)\ **Post date:** [November 7, 2024, 12:39pm UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934/4 "2024-11-07T12:39:40Z")
@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. ---
**Author:** ![PratikV](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/pratikv/32/1301_2.png) [@PratikV](https://community.cdata.com/u/PratikV)\ **Post date:** [November 11, 2024, 6:11am UTC](https://community.cdata.com/t/dataverse-odbc-driver-how-to-select-dynamic-fields/934/5 "2024-11-11T06:11:38Z")
@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 [support@cdata.com](mailto: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