Mark Carrington
Mark Carrington
I have seen this happen occasionally, but I've been trying to reproduce it for a few days to diagnose it further and haven't been able to trigger it again. If...
Thanks, I’ve been able to reproduce the issue with this query, I should have a fix in the next update
Can you make sure you're on the latest version of the connection controls (check in Configuration > Settings > Connection controls, should be 1.2025.7.61) and that you're using the OAuth/MFA...
This would involve re-implementing a lot of the UI that is currently included in Azure Data Studio - the connection dialog, object explorer, results grid, execution plan view etc. I...
I don't have anything built in, but there is [this PowerShell command](https://github.com/rnwood/Rnwood.Dataverse.Data.PowerShell/blob/main/Rnwood.Dataverse.Data.PowerShell/docs/Invoke-DataverseSql.md) which might give you what you need.
I can't reproduce this issue at the moment, but please let me know if you have any more details that might help identify the source.
v9.6.1 includes a fix for #647, please reopen this if you can still reproduce it
Agree this would be useful, I often refer to https://github.com/MarkMpn/Sql4Cds/wiki/Query%20Hints for the syntax.
It seems to require the quotes if the value contains a space, so `createdon gt 2024-08-28` or `createdon gt 2024-08-28T12:00:00Z` work without a quote, but `createdon gt '2024-08-28 12:00:00Z'` requires...
I've just been looking into this some more. There is already logic in the conversion to remove the spaces, so it should always produce a filter in the format `modifiedon...