markmpn / sql4cds Goto Github PK
View Code? Open in Web Editor NEWSQL 4 CDS core engine and XrmToolbox tool
License: MIT License
SQL 4 CDS core engine and XrmToolbox tool
License: MIT License
TRIM, LTRIM, RTRIM, SUBSTRING, LEN, REPLACE would be helpful.
Examples:
--extra spaces in data
update contact set
firstname = TRIM(firstname)
where firstname like ' %' or firstname like '% '
--leading zeros in data
update contact set
new_id = SUBSTRING(new_id, 2, LEN(new_id) - 1)
where new_id like '0%'
--replace emails after domain change
update contact set
emailaddress1 = REPLACE(emailaddress1, '@oldcompany.com', '@newcompany.com')
where emailaddress1 like '%@oldcompany.com'
I tried to run a query like this in SQL-4-CDS (v2.3) :
select (list of columns)
from logtable
where logdate between '2020-09-25T00:00:00' and '2020-09-25T23:59:59'
but unfortunately, all I get is an error message:
Unhandled WHERE clause: logdate between '2020-09-25T00:00:00' and '2020-09-25T23:59:59'
I had to rewrite the query to
select (list of columns)
from logtable
where logdate >= '2020-09-25T00:00:00' and logdate <= '2020-09-25T23:59:59'
While this is not a super critical bug - it would still be nice if SQL-4-CDS would support the "BETWEEN" SQL keyword
In one of the table/entity, there were 5.4 Million records. We created a Bulk delete job which deleted more or less 5.3 Million records. After Bulk Delete Job Finished, we wrote a query:
SELECT count(*) FROM table/entity;
And, it is still giving us wrong row count as 5.4 Million records.
Thanks.
UPDATE
account
SET
ownerid = 'b11ecdf7-4c05-ea11-813f-005056bd67bf'
WHERE
accountid = '65a95fcf-e343-ea11-8150-005056bd7a8f'
Both Id's are valid/actual records. First is a the Id of a User. 2nd is the Id of the Account.
This doesn't work and gives an error message that reads: "Unsupport attribute type Owner for attribute ownerid"
I have successfully updated Two Option fields. This is my first time trying to update a different data type.
UPDATE/DELETE without WHERE protections ignore filters applied by expressions.
https://twitter.com/boydmoon/status/1285315075583049728?s=21
UPDATE a
SET primarycontactid = c.contactid
FROM account AS a
INNER JOIN
contact AS c
ON a.accountid = c.parentcustomerid;
Sometimes I run a query on one tab and switch to another tab and work with the SQL in that tab, but the UI seems to be blocking. Won't scroll on the new tab and generally seems stuck. Behavior clears up when the first tab finishes the query.
In the past I've also had a few instances as well that would throw an exception as a dialog box popup in the middle of running a query and XrmToolbox would close altogether (instead of just the one the tab being closed potentially).
Not sure if possible, but if the tabs were each "sandboxed" so as not to interfere with each other/the application (sort of like how the Chrome browser does it), that could be helpful.
The request channel timed out while waiting for a reply after 00:01:59.9989890. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.
I like to build a query on top of another query:
select sum(a.column from ( select invoice.totalamount from invoice where invoice.year = yyyy and invoice.period = mm) as a
Improve diagnostics for plugin to show exactly where's the issue (stack trace) + logs in xrmtool that we could share when creating issues.
Getting error:
Expression of type 'System.Nullable`1[System.DateTime]' cannot be used for return type 'System.Object'
update c set
po_lastactivitydate = ap.actualend
from contact c
join activitypointer ap on ap.regardingobjectid = c.contactid
and ap.actualend is not null
where (c.po_lastactivitydate is null or ap.actualend > c.po_lastactivitydate)
Fields are regular Date/Time fields
Ref: https://markcarrington.dev/2021/01/13/sql-4-cds-4-0-0-released/#comment-753
With the XrmToolBox tool I’ve been using it as a quick way to add users into a team, the following statement used to work
insert into teammembership (systemuserid, teamid)
values (
CREATELOOKUP('systemuser', 'e76a6bf5-655a-eb11-bb25-00224801c8ab'),
CREATELOOKUP('team', 'e9ae85aa-3eba-ea11-a812-00224801ce17')
)
but now I get the following error (I’ve tried it in version 4.0 and 3.1)
Column cannot be set on INSERT: systemuserid
Also, one to put on the wish list, I’m forever pressing the CTRL+E SSMS keyboard shortcut to execute a query and it just inserts an ENQ character.
As per https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query, you can connect to TDS endpoint on the standard port but the SSMS plugin is expecting port number 5558
klicking on any of the highlighted column headers returns the error in the screenshot.
... user can continue working by selecting "continue" ("weiter" in the screenshot).
Error Details:
Informationen über das Aufrufen von JIT-Debuggen
anstelle dieses Dialogfelds finden Sie am Ende dieser Meldung.
************** Ausnahmetext **************
System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei MarkMpn.Sql4Cds.SqlQueryControl.Grid_RecordClick(Object sender, CRMRecordEventArgs e)
bei xrmtb.XrmToolBox.Controls.CRMGridView.OnRecordEvent(CRMRecordEventArgs e, CRMRecordEventHandler RecordEventHandler)
bei System.Windows.Forms.DataGridView.OnCellClick(DataGridViewCellEventArgs e)
bei System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** JIT-Debuggen **************
Um das JIT-Debuggen (Just-In-Time) zu aktivieren, muss in der
Konfigurationsdatei der Anwendung oder des Computers
(machine.config) der jitDebugging-Wert im Abschnitt system.windows.forms festgelegt werden.
Die Anwendung muss mit aktiviertem Debuggen kompiliert werden.
Zum Beispiel:
Wenn das JIT-Debuggen aktiviert ist, werden alle nicht behandelten
Ausnahmen an den JIT-Debugger gesendet, der auf dem
Computer registriert ist, und nicht in diesem Dialogfeld behandelt.
Implement this to easier find docs for the tool.
Always getting this error, params seem to be correct.
An unexpected error occured: System.ArgumentNullException: Value cannot be null.
Parameter name: source
at System.Linq.Enumerable.OfType[TResult](IEnumerable source)
at MarkMpn.Sql4Cds.FetchXml2Sql.BuildJoins(AttributeMetadataCache metadata, TableReference dataSource, NamedTableReference parentTable, Object[] items, QuerySpecification query, IDictionary`2 aliasToLogicalName)
at MarkMpn.Sql4Cds.FetchXml2Sql.BuildJoins(AttributeMetadataCache metadata, TableReference dataSource, NamedTableReference parentTable, Object[] items, QuerySpecification query, IDictionary`2 aliasToLogicalName)
at MarkMpn.Sql4Cds.FetchXml2Sql.Convert(AttributeMetadataCache metadata, FetchType fetch)
at MarkMpn.Sql4Cds.PluginControl.OnIncomingMessage(MessageBusEventArgs message)
at XrmToolBox.New.PluginForm.SendIncomingBrokerMessage(MessageBusEventArgs message)
at XrmToolBox.New.NewForm.MainForm_MessageBroker(Object sender, MessageBusEventArgs message)
at Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.GetSQLQuery(Boolean& sql4cds)
at Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.UpdateLiveXML(Boolean preventxmlupdate)
at Cinteros.Xrm.FetchXmlBuilder.DockControls.XmlContentControl.XmlContentDisplayDialog_VisibleChanged(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e)
at System.Windows.Forms.Form.OnVisibleChanged(EventArgs e)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at WeifenLuo.WinFormsUI.Docking.DockContentHandler.SetVisible()
at WeifenLuo.WinFormsUI.Docking.DockPane.set_ActiveContent(IDockContent value)
at WeifenLuo.WinFormsUI.Docking.DockPane.ValidateActiveContent()
at WeifenLuo.WinFormsUI.Docking.DockContentHandler.SetDockState(Boolean isHidden, DockState visibleState, DockPane oldPane)
at WeifenLuo.WinFormsUI.Docking.DockContentHandler.set_DockState(DockState value)
at WeifenLuo.WinFormsUI.Docking.DockContentHandler.Show(DockPanel dockPanel, DockState dockState)
at Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.ShowContentControl(XmlContentControl& control, ContentType contenttype, SaveFormat save, DockState state)
at Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.tsmiShowSQL_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at XrmToolBox.Program.Main(String[] args)
I am trying to delete a bunch of records via the "SQL 4 CDS" tool. Unfortunately, every time I try to delete these records, I receive the following error after 2 minutes: "The request channel timed out while waiting for a reply after 00:01:59.9937153. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout."
I know it is possible to change the "Service Timeout" field when connecting to an environment via the "Connection Wizard", but this is not an option for me. I have to connect via the SDK Login Control due to multi-factor authentication.
How can I fix this so the request does not keep timing out?
Thanks!
Add documentation for usage of Sql4Cds.Engine with examples. Honestly I'm not sure if that is production-ready.
When using the CRM SDK or the REST API, I have the ability (if I have the necessary permission) to do e.g. bulk update operations "on behalf of" someone else - e.g. I can update thousands of entities and have some service account used for the "ModifiedBy" value of those entities.
Is there any chance SQL-4-CDS could support this feature? Right now, it's the best and easiest way to do bulk updates - but it carries the drawback of my own name showing up as the "Modified By" user for all the entities I've updated.
select count(*), systemuser.fullname from contact
inner join systemuser ON contact.ownerid = systemuser.systemuserid
group by systemuser.fullname
retrieves 50,000 contacts in the appropriate groups, but ignores additional contacts.
select count(*), ownerid from contact
inner join systemuser ON contact.ownerid = systemuser.systemuserid
group by ownerid
retrieves the expected results.
Running this query:
SELECT statecodename,
count(*)
FROM account
GROUP BY statecodename;
generates this FetchXML:
<fetch xmlns:generator="MarkMpn.SQL4CDS" aggregate="true">
<entity name="account">
<attribute name="statecodename" />
<attribute name="accountid" />
<attribute name="statecode" />
<order attribute="statecodename" />
</entity>
</fetch>
which throws this error:
An attribute can not be requested when an aggregate operation has been specified and its neither groupby nor aggregate. NodeXml : <attribute name="statecodename" />
when i select all output from execute query i get an exception popup window. when you press continue it is not an issue:
the details screen contains this and a long list of loaded assemblies
Zie het einde van dit bericht voor meer informatie over het aanroepen
van JIT-foutopsporing (Just In Time) in plaats van dit dialoogvenster.
************** Tekst van uitzondering **************
System.NullReferenceException: De objectverwijzing is niet op een exemplaar van een object ingesteld.
bij MarkMpn.Sql4Cds.SqlQueryControl.Grid_RecordClick(Object sender, CRMRecordEventArgs e)
bij xrmtb.XrmToolBox.Controls.CRMGridView.OnRecordEvent(CRMRecordEventArgs e, CRMRecordEventHandler RecordEventHandler)
bij System.Windows.Forms.DataGridView.OnCellClick(DataGridViewCellEventArgs e)
bij System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e)
bij System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bij System.Windows.Forms.Control.WndProc(Message& m)
bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Geladen assembly's **************
************** JIT-foutopsporing **************
Als u JIT-foutopsporing wilt inschakelen, moet in het configuratiebestand voor deze
toepassing of computer (machine.config) de waarde
jitDebugging in het gedeelte system.windows.forms zijn ingesteld.
De toepassing moet ook zijn gecompileerd terwijl foutopsporing
was ingeschakeld.
Bijvoorbeeld:
Wanneer JIT-foutopsporing is ingeschakeld, worden onverwerkte uitzonderingen
naar het JIT-foutopsporingsprogramma gestuurd dat op de computer is geregistreerd
en worden niet door dit dialoogvenster verwerkt.
i tried to execute this sql update statament but i recivied error message:
"object reference not set to an insance of an object"
probaly is not possible translate this sql commnad in fetch xml query ?
UPDATE res_comune
SET res_regioneid = r.res_regioneid
FROM res_comune AS c
INNER JOIN
res_regione AS r
ON c.res_regione = r.res_name;
SELECT wf.name,
count(*) AS count
FROM processsession AS ps
INNER JOIN
workflow AS wf
ON ps.processid = wf.workflowid
WHERE ps.startedon = lastxmonths(1)
AND wf.category = 1
GROUP BY wf.name
ORDER BY count DESC;
Replacing ORDER BY
clause with ORDER BY 2 DESC
works, but shows expression warning
Is it possible to set a default column width or expand all columns in the result pane without having to do it manually after each run? I often build a query and then refresh that query several times while making updates in CRM. Currently all columns are very tight and data is truncated so i have to drag/expand each column one by one every time I reload.
This wasn't happening until I updated the plug-in to the latest version 3.1.0.0.
When you are in the editor and typing a SQL query and the intellisense kicks in to find (filter) an entity or an attribute the exception is thrown. That happens on every character you are keying in. I uninstalled the plug-in and re-installed it but it didn't fix the issue. Is it me only ?
The exception details are as follows:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.InvalidOperationException: Sequence contains no matching element
at System.Linq.Enumerable.Single[TSource](IEnumerable1 source, Func
2 predicate)
at MarkMpn.Sql4Cds.Autocomplete.AttributeAutocompleteItem..ctor(AttributeMetadata attribute, IAttributeMetadataCache metadata, Int32 replaceLength)
at MarkMpn.Sql4Cds.Autocomplete.<>c__DisplayClass3_0.b__30(IGrouping2 g) at System.Linq.Enumerable.WhereSelectEnumerableIterator
2.MoveNext()
at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable
1 collection)
at MarkMpn.Sql4Cds.Autocomplete.GetSuggestions(String text, Int32 pos)
at MarkMpn.Sql4Cds.SqlQueryControl.<>c__DisplayClass47_0.b__3(Object s, DwellEventArgs e)
at ScintillaNET.Scintilla.OnDwellStart(DwellEventArgs e)
at ScintillaNET.Scintilla.WmReflectNotify(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Immediately after hitting the space bar this occurs:
Details:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at MarkMpn.Sql4Cds.Autocomplete.GetSuggestions(String text, Int32 pos, Int32& currentLength)
at MarkMpn.Sql4Cds.SqlQueryControl.ShowIntellisense(Boolean force)
at ScintillaNET.Scintilla.OnCharAdded(CharAddedEventArgs e)
at ScintillaNET.Scintilla.WmReflectNotify(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
XrmToolBox
Assembly Version: 1.2020.6.40
Win32 Version: 1.2020.6.40
CodeBase: file:///A:/XrmToolbox/XrmToolBox.exe
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
XrmToolBox.Extensibility
Assembly Version: 1.2020.6.40
Win32 Version: 1.2020.6.40
CodeBase: file:///A:/XrmToolbox/XrmToolBox.Extensibility.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.IdentityModel
Assembly Version: 3.5.0.0
Win32 Version: 6.1.7601.24479
CodeBase: file:///A:/XrmToolbox/Microsoft.IdentityModel.DLL
----------------------------------------
System.IO.Compression.FileSystem
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IO.Compression.FileSystem/v4.0_4.0.0.0__b77a5c561934e089/System.IO.Compression.FileSystem.dll
----------------------------------------
XrmToolBox.PluginsStore
Assembly Version: 1.2020.6.40
Win32 Version: 1.2020.6.40
CodeBase: file:///A:/XrmToolbox/XrmToolBox.PluginsStore.DLL
----------------------------------------
NuGet.Core
Assembly Version: 2.14.0.832
Win32 Version: 2.14.0.832
CodeBase: file:///A:/XrmToolbox/NuGet.Core.DLL
----------------------------------------
Newtonsoft.Json
Assembly Version: 12.0.0.0
Win32 Version: 12.0.3.23909
CodeBase: file:///A:/XrmToolbox/Newtonsoft.Json.DLL
----------------------------------------
McTools.Xrm.Connection
Assembly Version: 1.2020.5.33
Win32 Version: 1.2020.5.33
CodeBase: file:///A:/XrmToolbox/McTools.Xrm.Connection.DLL
----------------------------------------
McTools.Xrm.Connection.WinForms
Assembly Version: 1.2020.5.33
Win32 Version: 1.2020.5.33
CodeBase: file:///A:/XrmToolbox/McTools.Xrm.Connection.WinForms.DLL
----------------------------------------
Microsoft.Xrm.Sdk
Assembly Version: 9.0.0.0
Win32 Version: 9.0.45.329
CodeBase: file:///A:/XrmToolbox/Microsoft.Xrm.Sdk.DLL
----------------------------------------
Microsoft.Xrm.Sdk.Workflow
Assembly Version: 9.0.0.0
Win32 Version: 9.0.45.329
CodeBase: file:///A:/XrmToolbox/Microsoft.Xrm.Sdk.Workflow.DLL
----------------------------------------
Microsoft.Crm.Sdk.Proxy
Assembly Version: 9.0.0.0
Win32 Version: 9.0.45.329
CodeBase: file:///A:/XrmToolbox/Microsoft.Crm.Sdk.Proxy.DLL
----------------------------------------
Microsoft.Xrm.Tooling.Connector
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.51
CodeBase: file:///A:/XrmToolbox/Microsoft.Xrm.Tooling.Connector.DLL
----------------------------------------
Microsoft.Xrm.Tooling.Ui.Styles
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.51
CodeBase: file:///A:/XrmToolbox/Microsoft.Xrm.Tooling.Ui.Styles.DLL
----------------------------------------
Microsoft.Xrm.Tooling.CrmConnectControl
Assembly Version: 4.0.0.0
Win32 Version: 4.0.0.51
CodeBase: file:///A:/XrmToolbox/Microsoft.Xrm.Tooling.CrmConnectControl.DLL
----------------------------------------
Microsoft.IdentityModel.Clients.ActiveDirectory
Assembly Version: 5.2.7.0
Win32 Version: 5.2.7.0
CodeBase: file:///A:/XrmToolbox/Microsoft.IdentityModel.Clients.ActiveDirectory.DLL
----------------------------------------
WeifenLuo.WinFormsUI.Docking
Assembly Version: 3.0.6.0
Win32 Version: 3.0.6.0
CodeBase: file:///A:/XrmToolbox/WeifenLuo.WinFormsUI.Docking.DLL
----------------------------------------
WeifenLuo.WinFormsUI.Docking.ThemeVS2015
Assembly Version: 3.0.6.0
Win32 Version: 3.0.6.0
CodeBase: file:///A:/XrmToolbox/WeifenLuo.WinFormsUI.Docking.ThemeVS2015.DLL
----------------------------------------
ScintillaNET
Assembly Version: 3.6.3.0
Win32 Version: 3.6.3.0
CodeBase: file:///A:/XrmToolbox/ScintillaNET.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Net.Http
Assembly Version: 4.1.1.3
Win32 Version: 4.6.26907.01
CodeBase: file:///A:/XrmToolbox/System.Net.Http.DLL
----------------------------------------
System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
----------------------------------------
SMDiagnostics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
----------------------------------------
System.ServiceModel.Internals
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
McTools.StopAdvertisement
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///A:/XrmToolbox/McTools.StopAdvertisement.DLL
----------------------------------------
System.Xml.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.ComponentModel.Composition
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll
----------------------------------------
Cinteros.Xrm.CRMWinForm
Assembly Version: 2017.9.4.18
Win32 Version: 2017.9.04.18
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/CINTEROS.XRM.CRMWINFORM.DLL
----------------------------------------
Cinteros.Xrm.XmlEditorUtils
Assembly Version: 1.2017.10.4
Win32 Version: 1.2017.10.004
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/CINTEROS.XRM.XMLEDITORUTILS.DLL
----------------------------------------
DamSim.SolutionTransferTool
Assembly Version: 1.2020.6.13
Win32 Version: 1.2020.6.13
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/DAMSIM.SOLUTIONTRANSFERTOOL.DLL
----------------------------------------
DamSim.ViewTransferTool
Assembly Version: 1.2019.11.4
Win32 Version: 1.2019.11.4
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/DAMSIM.VIEWTRANSFERTOOL.DLL
----------------------------------------
EPPlus
Assembly Version: 5.1.0.0
Win32 Version: 5.1.0.0
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/EPPLUS.DLL
----------------------------------------
GapConsulting.PowerBIOptionSetAssistant
Assembly Version: 1.2018.6.3
Win32 Version: 1.2018.6.3
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/GAPCONSULTING.POWERBIOPTIONSETASSISTANT.DLL
----------------------------------------
Javista.AttributesFactory
Assembly Version: 1.2020.6.4
Win32 Version: 1.2020.6.4
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/JAVISTA.ATTRIBUTESFACTORY.DLL
----------------------------------------
Javista.XrmToolBox.ImportNN
Assembly Version: 1.2019.10.9
Win32 Version: 1.2019.10.9
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/JAVISTA.XRMTOOLBOX.IMPORTNN.DLL
----------------------------------------
MarkMpn.Sql4Cds
Assembly Version: 2.2.0.0
Win32 Version: 2.2.0.0
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MARKMPN.SQL4CDS.DLL
----------------------------------------
MessageExplorer
Assembly Version: 1.1.1.0
Win32 Version: 1.1.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MESSAGEEXPLORER.DLL
----------------------------------------
MsCrmTools.AccessChecker
Assembly Version: 1.2018.7.2
Win32 Version: 1.2018.7.2
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ACCESSCHECKER.DLL
----------------------------------------
MsCrmTools.AssemblyRecoveryTool
Assembly Version: 1.2019.11.3
Win32 Version: 1.2019.11.3
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ASSEMBLYRECOVERYTOOL.DLL
----------------------------------------
MsCrmTools.AttributeBulkUpdater
Assembly Version: 1.2019.5.3
Win32 Version: 1.2019.5.3
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ATTRIBUTEBULKUPDATER.DLL
----------------------------------------
MscrmTools.AttributeUsageInspector
Assembly Version: 1.2018.9.11
Win32 Version: 1.2018.9.11
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ATTRIBUTEUSAGEINSPECTOR.DLL
----------------------------------------
MsCrmTools.AuditCenter
Assembly Version: 1.2019.11.2
Win32 Version: 1.2019.11.2
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.AUDITCENTER.DLL
----------------------------------------
MsCrmTools.ChartManager
Assembly Version: 1.2017.3.1
Win32 Version: 1.2017.3.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.CHARTMANAGER.DLL
----------------------------------------
MscrmTools.CrmTraceReader
Assembly Version: 1.2018.4.1
Win32 Version: 1.2018.4.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.CRMTRACEREADER.DLL
----------------------------------------
MsCrmTools.DocumentTemplatesMover
Assembly Version: 1.2020.2.4
Win32 Version: 1.2020.2.4
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.DOCUMENTTEMPLATESMOVER.DLL
----------------------------------------
MscrmTools.EmailAnonymizer
Assembly Version: 1.2019.12.1
Win32 Version: 1.2019.12.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.EMAILANONYMIZER.DLL
----------------------------------------
MsCrmTools.FetchXmlTester
Assembly Version: 1.2016.8.23
Win32 Version: 1.2016.8.23
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.FETCHXMLTESTER.DLL
----------------------------------------
MsCrmTools.FlsBulkUpdater
Assembly Version: 1.2016.12.1
Win32 Version: 1.2016.12.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.FLSBULKUPDATER.DLL
----------------------------------------
MsCrmTools.FormRelated
Assembly Version: 1.2017.12.3
Win32 Version: 1.2017.12.3
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.FORMRELATED.DLL
----------------------------------------
MsCrmTools.Iconator
Assembly Version: 1.2018.7.9
Win32 Version: 1.2018.7.9
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.ICONATOR.DLL
----------------------------------------
MscrmTools.ManagedSolutionDeletionTool
Assembly Version: 1.2016.11.1
Win32 Version: 1.2016.11.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.MANAGEDSOLUTIONDELETIONTOOL.DLL
----------------------------------------
MsCrmTools.MetadataBrowser
Assembly Version: 1.2020.4.13
Win32 Version: 1.2020.4.13
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.METADATABROWSER.DLL
----------------------------------------
MsCrmTools.MetadataDocumentGenerator
Assembly Version: 1.2019.5.1
Win32 Version: 1.2019.5.1
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.METADATADOCUMENTGENERATOR.DLL
----------------------------------------
MscrmTools.PortalCodeEditor
Assembly Version: 1.2020.5.14
Win32 Version: 1.2020.5.14
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.PORTALCODEEDITOR.DLL
----------------------------------------
MscrmTools.PortalRecordsMover
Assembly Version: 1.2020.6.20
Win32 Version: 1.2020.6.20
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.PORTALRECORDSMOVER.DLL
----------------------------------------
MsCrmTools.SampleTool
Assembly Version: 1.2018.6.23
Win32 Version: 1.2018.6.23
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SAMPLETOOL.DLL
----------------------------------------
MsCrmTools.ScriptsFinder
Assembly Version: 1.2020.2.12
Win32 Version: 1.2020.2.12
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SCRIPTSFINDER.DLL
----------------------------------------
MsCrmTools.SecurityRelated
Assembly Version: 1.2018.9.3
Win32 Version: 1.2018.9.3
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SECURITYRELATED.DLL
----------------------------------------
MsCrmTools.SiteMapEditor
Assembly Version: 1.2019.5.12
Win32 Version: 1.2019.5.12
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SITEMAPEDITOR.DLL
----------------------------------------
MsCrmTools.SolutionComponentsMover
Assembly Version: 1.2020.5.5
Win32 Version: 1.2020.5.5
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SOLUTIONCOMPONENTSMOVER.DLL
----------------------------------------
MsCrmTools.SolutionImport
Assembly Version: 1.2016.8.23
Win32 Version: 1.2016.8.23
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SOLUTIONIMPORT.DLL
----------------------------------------
MscrmTools.SyncFilterManager
Assembly Version: 1.2020.4.2
Win32 Version: 1.2020.4.2
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SYNCFILTERMANAGER.DLL
----------------------------------------
MsCrmTools.SynchronousEventOrderEditor
Assembly Version: 1.2016.8.23
Win32 Version: 1.2016.8.23
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.SYNCHRONOUSEVENTORDEREDITOR.DLL
----------------------------------------
MsCrmTools.Translator
Assembly Version: 1.2020.7.13
Win32 Version: 1.2020.7.13
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.TRANSLATOR.DLL
----------------------------------------
MsCrmTools.UserSettingsUtility
Assembly Version: 1.2020.4.13
Win32 Version: 1.2020.4.13
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.USERSETTINGSUTILITY.DLL
----------------------------------------
MsCrmTools.ViewLayoutReplicator
Assembly Version: 1.2020.7.5
Win32 Version: 1.2020.7.5
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.VIEWLAYOUTREPLICATOR.DLL
----------------------------------------
MscrmTools.WebresourcesManager
Assembly Version: 2.2020.5.12
Win32 Version: 2.2020.5.12
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/MSCRMTOOLS.WEBRESOURCESMANAGER.DLL
----------------------------------------
Rappen.XTB.FXB
Assembly Version: 1.2020.7.3
Win32 Version: 1.2020.07.003
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/RAPPEN.XTB.FXB.DLL
----------------------------------------
Rappen.XTB.PTV
Assembly Version: 1.2019.12.1
Win32 Version: 1.2019.12.001
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/RAPPEN.XTB.PTV.DLL
----------------------------------------
Ryr.ExcelExport
Assembly Version: 2.6.0.0
Win32 Version: 2.6.0
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/RYR.EXCELEXPORT.DLL
----------------------------------------
WeifenLuo.WinFormsUI.Docking
Assembly Version: 3.0.1.0
Win32 Version: 3.0.1.0
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/WEIFENLUO.WINFORMSUI.DOCKING.DLL
----------------------------------------
WeifenLuo.WinFormsUI.Docking.ThemeVS2015
Assembly Version: 3.0.1.0
Win32 Version: 3.0.1.0
CodeBase: file:///C:/USERS/JIM/APPDATA/ROAMING/MSCRMTOOLS/XRMTOOLBOX/PLUGINS/WEIFENLUO.WINFORMSUI.DOCKING.THEMEVS2015.DLL
----------------------------------------
System.Net.Http
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
----------------------------------------
WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4210.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
MetadataViewProxies_20c6fa7e-7537-4e2b-a586-18cbe1fbd8dc
Assembly Version: 0.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Xaml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
----------------------------------------
System.Data.Services.Client
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Services.Client/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Services.Client.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
PresentationFramework
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
PresentationCore
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
PresentationFramework.Aero2
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework.Aero2/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.Aero2.dll
----------------------------------------
PresentationFramework-SystemXml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXml/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXml.dll
----------------------------------------
UIAutomationTypes
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll
----------------------------------------
UIAutomationProvider
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll
----------------------------------------
PresentationFramework-SystemXmlLinq
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemXmlLinq/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemXmlLinq.dll
----------------------------------------
PresentationFramework-SystemCore
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework-SystemCore/v4.0_4.0.0.0__b77a5c561934e089/PresentationFramework-SystemCore.dll
----------------------------------------
System.ServiceModel
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
----------------------------------------
System.Web.Services
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Deployment
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Security
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
Microsoft.Rest.ClientRuntime
Assembly Version: 2.0.0.0
Win32 Version: 2.3.20.0
CodeBase: file:///A:/XrmToolbox/Microsoft.Rest.ClientRuntime.DLL
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Runtime.Caching
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Caching/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Caching.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.IdentityModel
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4200.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll
----------------------------------------
Microsoft.VisualStudio.Diagnostics.ServiceModelSink
Assembly Version: 4.0.0.0
Win32 Version: 16.0.102.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Diagnostics.ServiceModelSink/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Diagnostics.ServiceModelSink.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Example:
select count(*) from phonecall where sortdate is null
Gives this error:
Invalid column name 'activityid_count'.
RequestId: TDS;5d0ef58c-4ab6-4195-8019-76da14b20334;3
Time: 2020-09-14T15:25:29.3166290Z
Issue in newest version (2.3.0)
Add project with potential features to do for contributors if they want to add features.
Is it shared on MIT license?
Ref: https://markcarrington.dev/2021/01/28/sql-4-cds-4-0-1-released/#comment-773
When I fetch a generated field with postfix name like in this statement:
select accountnumber, statuscode, statuscodename from account
Field statuscodename is fetched for the first 5000 records only, but it’s empty on the following records. Are these fields not supported on the following pages?
I was running an insert statement that I've used quite a bit in the past to recreate a certain test scenario (I'll include it at the bottom of this message), and I get the following error:
"Unsupport attribute type Virtual for attribute new_productofinterest"
The data type for that new_productofinterest column is "Option set multiple".
Cheers,
Rich
insert into opportunity (currentsituation, customerid,description, name, new_issue, new_pipelinephasenew, new_productofinterest, parentcontactid, pricelevelid, sshared_city, sshared_oppbpf, sshared_opportunitystage,
sshared_opportunitytype, sshared_showname, sshared_stateprovince, sshared_street1, sshared_street2, sshared_street3, sshared_zippostalcode)
select currentsituation, customerid,description, name, new_issue, new_pipelinephasenew, new_productofinterest, parentcontactid, pricelevelid, sshared_city, sshared_oppbpf, sshared_opportunitystage,
sshared_opportunitytype, sshared_showname, sshared_stateprovince, sshared_street1, sshared_street2, sshared_street3, sshared_zippostalcode
from opportunity
where opportunityid = '9661cf8e-78f3-ea11-a815-000d3ad5c21f'
************** Exception Text **************
System.ArgumentNullException: Value cannot be null.
Parameter name: String
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
at MarkMpn.Sql4Cds.Engine.FetchXml2Sql.GetCondition(IOrganizationService org, IAttributeMetadataCache metadata, condition condition, String prefix, IDictionary`2 aliasToLogicalName, FetchXml2SqlOptions options, IDictionary`2 ctes, IDictionary`2 parameters, Boolean& requiresTimeZone, Boolean& usesToday)
at MarkMpn.Sql4Cds.Engine.FetchXml2Sql.GetFilter(IOrganizationService org, IAttributeMetadataCache metadata, filter filter, String prefix, IDictionary`2 aliasToLogicalName, FetchXml2SqlOptions options, IDictionary`2 ctes, IDictionary`2 parameters, Boolean& requiresTimeZone, Boolean& usesToday)
at MarkMpn.Sql4Cds.Engine.FetchXml2Sql.GetFilter(IOrganizationService org, IAttributeMetadataCache metadata, Object[] items, String prefix, IDictionary`2 aliasToLogicalName, FetchXml2SqlOptions options, IDictionary`2 ctes, IDictionary`2 parameters, Boolean& requiresTimeZone, Boolean& usesToday)
at MarkMpn.Sql4Cds.Engine.FetchXml2Sql.BuildJoins(IOrganizationService org, IAttributeMetadataCache metadata, TableReference dataSource, NamedTableReference parentTable, Object[] items, QuerySpecification query, IDictionary`2 aliasToLogicalName, Boolean nolock, FetchXml2SqlOptions options, IDictionary`2 ctes, IDictionary`2 parameters, Boolean& requiresTimeZone, Boolean& usesToday)
at MarkMpn.Sql4Cds.Engine.FetchXml2Sql.Convert(IOrganizationService org, IAttributeMetadataCache metadata, FetchType fetch, FetchXml2SqlOptions options, IDictionary`2& parameterValues)
at MarkMpn.Sql4Cds.PluginControl.OnIncomingMessage(MessageBusEventArgs message)
at XrmToolBox.New.PluginForm.SendIncomingBrokerMessage(MessageBusEventArgs message)
at XrmToolBox.New.NewForm.MainForm_MessageBroker(Object sender, MessageBusEventArgs message)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4341.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
XrmToolBox
Assembly Version: 1.2021.2.45
Win32 Version: 1.2021.2.45
CodeBase: file:///C:/Program%20Files%20(x86)/XRM%20Toolbox/XrmToolBox.exe
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4341.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4300.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
It was during parsing from fetchxmlbuilder
to sql4cds
.
query:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" >
<entity name="policy" >
<attribute name="id" />
...otherattributes...
<order attribute="status" descending="false" />
<order attribute="createdon" descending="true" />
<filter type="and" >
<condition attribute="startdate" operator="not-null" />
...other not-null checks...
<condition attribute="status" operator="eq" value="1" />
<filter type="or" >
<condition attribute="something" operator="null" />
<condition attribute="something" operator="eq" value="0" />
</filter>
</filter>
<link-entity name="many-to-many-relationship-table" from="id" to="id" intersect="true" link-type="outer" >
<link-entity name="external-table" from="ext-id" to="ext-id" link-type="outer" alias="au" />
</link-entity>
<link-entity name="contact" from="contactid" to="contact" link-type="inner" alias="contact" >
<filter type="and" >
<condition attribute="contact-type" operator="eq" value="1" />
</filter>
<link-entity name="other-name" from="contact" to="contactid" link-type="inner" alias="ad" />
</link-entity>
<link-entity name="concept" from="conceptid" to="concept" link-type="inner" alias="concept" >
<attribute name="price" />
<filter type="and" >
<condition attribute="legalentity" operator="not-null" />
...other not-null conditions
</filter>
</link-entity>
<filter type="and" >
<condition entityname="au" attribute="ext-id" operator="null" />
</filter>
</entity>
</fetch>
I would find it helpful if the tabs worked similar to the way Notepad++ does, keeping the SQL on the tabs between sessions, even if they were not explicitly saved / re-saved. Would help me not worry about computer restarts or app updates / restarts, etc.
Add article in readme how we can contribute features.
Example:
update new_entity set new_money1 = new_money1 / 2.00 where new_name = 'test'
The binary operator Divide is not defined for the types 'System.Nullable`1[System.Decimal]' and 'System.Decimal'.
Similar error when using ints as well
Informationen über das Aufrufen von JIT-Debuggen
anstelle dieses Dialogfelds finden Sie am Ende dieser Meldung.
************** Ausnahmetext **************
System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei MarkMpn.Sql4Cds.SqlQueryControl.Grid_RecordClick(Object sender, CRMRecordEventArgs e)
bei xrmtb.XrmToolBox.Controls.CRMGridView.OnRecordEvent(CRMRecordEventArgs e, CRMRecordEventHandler RecordEventHandler)
bei System.Windows.Forms.DataGridView.OnCellClick(DataGridViewCellEventArgs e)
bei System.Windows.Forms.DataGridView.OnMouseClick(MouseEventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Any chance that SQL-4-CDS might eventually support reading (and possibly updating) global option sets, and the translations for those? That would really be a great feature !
Implement this to make it easier to submit feedback.
I was trying to get the log entries for a particular date from SQL-4-CDS and tried like this:
select (list of columns)
from logtable
where cast(logdate as date) = '20200925'
which would work just fine in SQL Server (Mgmt Studio) - but in SQL-4-CDS, I only get an error message:
Unsupported expression: cast(ambcust_logdate as date)
Any hope that this expression "cast(... as date)" will be supported in an upcoming version of SQL-4-CDS ?
SELECT TOP 10 *
FROM appointment
ORDER BY createdon DESC;
I liked to turn on the SQL TDS option for queries because it made it easier to get display values for lookup and option set fields in a query like this:
select
fullname
,parentcustomeridname
,new_someoptionsetfieldname
from contact
where new_someoptionsetfieldname in ('Item 1', 'Item 2')
instead of having to do joins for the lookups and hardcoding the option set values.
Since the SQL TDS endpoints are now disabled for everyone, if the behavior could be the same here it would be helpful. Right now you are able to select the name fields in the query without getting an error, but the results are just blank for those fields.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.