Sql4Cds
Sql4Cds copied to clipboard
MarkMpn
SQL 4 CDS core engine and XrmToolbox tool
Hi Mark, I still love this tool, allowing me to do more and do it quickly. You already helped me out by fixing an issue - thank you again. 🙏...
SQL4CDS is such a great tool for dealing with the many nuances of Dataverse without directly wrangling the WebAPI. Thank you. 1. I'd love to be able to execute a...
When connected via XTB to On-Premises instance via IFD URL, open record constructs invalid URL - it appends organization name but it should not. Looks like `ConnectionDetails` has [UseIfd](https://github.com/MscrmTools/MscrmTools.Xrm.Connection/blob/30e066b179c22332d83ab1b4ab09033daf0f6486/McTools.Xrm.Connection/ConnectionDetail.cs#L353) property...
Hoping support for [MergeRequest ](https://learn.microsoft.com/en-us/dotnet/api/microsoft.crm.sdk.messages.mergerequest?view=dataverse-sdk-latest) can be added, so the SQL4CDS tool can initiate bulk merges based on conditions. Syntax perhaps looking something like this: ```tsql DECLARE @contact AS EntityReference...
The tool asks to delete Microsoft.ApplicationInsights.dll  Doing this prevents XRMToolbox from starting (the file is most likely used by other tools and/or the toolbox itself). 
```sql SELECT w.name FROM workflow AS w INNER JOIN solutioncomponent AS sc ON w.workflowid = sc.objectid WHERE w.name = 'xxx' OR w.name = 'yyy'; ``` When I run the above...
```sql SELECT leadid, ROW_NUMBER() OVER (PARTITION BY parentaccountid ORDER BY createdon ASC) AS rownum FROM lead WHERE parentaccountid IS NOT NULL ```
Option to only set a field if the new value is different to the existing value, e.g. | accountid | name | telephone | |---|---|---| | 4d3365e6-62a9-4552-8277-92d7abfb6b47 | Data8 |...
I initially installed SSMS v.19.0 (Preview) then installed the MSI from this Github. I went to Tools/Options and found no section for "SQL 4 CDS". In other words, the plugin...
I have successfully downloaded SQL 4 CDS; I am able to use it to update Dataverse. I have also loaded the SSMS version. However, when running MarkMpn.Sql4Cds.SSMS.Setup the installation wizard...
