Skip to content

@rappen rappen released this Dec 15, 2020

Improvements

• Integration to Bulk Data Updater to easily update/delete records
• Show proper message for OData and filtered nested link-entity nodes (yes, that’s an edge case!) (1)
• Option to only show images on toolbar buttons
• Various improvements to C# QueryExpression code generation #292 (1)
• Dataverse allovertheplace

Fixes

• Updating settings reverted query to original #435
• Fixed utm params incorrectly added to OData queries #437

Contributions

(1) Thanks to @MarkMpn for contributions!

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

This list of changes was auto generated.

Assets 4

@rappen rappen released this Dec 14, 2020

Improvements

• Integration to Bulk Data Updater to easily update/delete records
• Show proper message for OData and filtered nested link-entity nodes (yes, that’s an edge case!) (1)
• Option to only show images on toolbar buttons
• Various improvements to C# QueryExpression code generation #292 (1)
• Dataverse allovertheplace

Fixes

• Updating settings reverted query to original #435

Contributions

(1) Thanks to @MarkMpn for contributions!

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

See More
  • 932f027 Adding integration to Bulk Data Updater 🚀
  • 7cf2c34 Adding option to minimize tool strip buttons to image only
  • 985bde9 URL params handling refactored
  • 51e27ce ADded utm-params to urls and changed url parsing
  • 12d76b4 Added a test project - after more than 6️⃣ years!! 😱
  • 945ec3e Display error when trying to filter on nested link-entities in WebAPI
  • 2948a4b ALways adding Docs&Learn creator id for MS urls.
  • d97f7f9 Updated packages

This list of changes was auto generated.

Assets 4

@rappen rappen released this Nov 13, 2020

Improvements

• Allow joining on non-existing relationships #394
• Support eq-userlanguage condition operator #404
• Help links for some FetchXML oddities #406
• Automatically add Condition to new Filter #405
• Inner join support for OData and Power Automate queries! (1)
• Added Late Materialize flag for performance #389
• Added Quick Find search item limit flag #390

Fixes

• Copy results with headers bug #358 (2)
• M:M-relationship attribute bug #403
• Tool crashed on comment nodes #408

Contributions

(1) Thanks to @MarkMpn for contributions!
(2) Thanks to @joshcampbell191 for contributions!

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

This list of changes was auto generated.

Assets 4

@rappen rappen released this Nov 11, 2020

Improvements

• Allow joining on non-existing relationships #394
• Support eq-userlanguage condition operator #404
• Help links for some FetchXML oddities #406
• Automatically add Condition to new Filter #405
• Inner join support for OData and Power Automate queries! (1)
• Added Late Materialize flag for performance #389
• Added Quick Find search item limit flag #390

Fixes

• Copy results with headers bug #358 (2)
• M:M-relationship attribute bug #403

Contributions

(1) Thanks to @MarkMpn for contributions!
(2) Thanks to @joshcampbell191 for contributions!

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

See More

This list of changes was auto generated.

Assets 4

@rappen rappen released this Sep 21, 2020

Improvements

• Friendly names of ValueOf attributes #344 (1)
• Like and Contains condition operators for OData #348 (1)
• Only show Column Comparison feature where available #351
• Like condition operator edge case improvements #362 (1)
• Nested expand joins for OData #359 (2)
• Inner expand joins for OData #359 (2)
• Filter N:N relationships for OData #359 (2)

Fixes

• Primary key filter bug #345, #347, #350, #352, #353, #366, #373, #374, #377 (1)
• Handle multiple parallel filters in OData #361 (1)

Oopsie

• Removing all “Microsoft D******x” references 🤦

Contributions

(1) Thanks to @MarkMpn for contributions!
(2) Thanks to @LinnZawWin for contributions!

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

  • e6bbb78 Release notes for 1.2020.9.x added
  • 7cc9a06 A few fixes for Column Comparison behavior
  • aec996e Fix for #344 Friendly names for ValueOf control
  • 4b03bfd 🧹 Fixed old urls
  • 9515c0e Fixing #351 Checking CDS version to see if ValueOf is supported
  • c270e4f 🙄 No more Dataflex...
  • be80e9d Updating SDK packages
  • 31b8d86 Merge pull request #359 from LinnZawWin/master
  • 29623e2 Merge branch 'master' into master
  • b3d4f97 Merge pull request #363 from MarkMpn/like
See More
  • 7bb9895 Merge branch 'master' into like
  • 490d63d Merge pull request #349 from MarkMpn/idcondition
  • 10653b5 Fixed typo in ContainValues OData filter method
  • 25ba65b Disable mnemonics in Power Automate parameter links so & in values is shown correctly
  • c034e65 Added support for notbeingwith and notendwith
  • 068fa71 Fix OData URL generation for queries containing multiple nodes or URL special characters
  • 08669fc Reverted more LIKE changes
  • 5408f6b Translate between like, contains, ends-with and begins-with conditions
  • e019ec9 Reverted changes to LIKE handling
  • f8dc7c6 Updated csproj file with package versions not updated by dependabot
  • 414bc55 Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly in /FetchXmlBuilder (#357)
  • 993a58e Bump Microsoft.CrmSdk.XrmTooling.WpfControls in /FetchXmlBuilder (#356)
  • bcb701d Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly from 9.1.0.49 to 9.1.0.51 (#355)
  • c339f87 Merge pull request #354 from MarkMpn/entityname
  • fe1474b Fixed logo url
  • 4d84ef9 Added support for complex query types
  • 645cabb Revert "Revert "Merge remote-tracking branch 'upstream/master'""
  • d8aee71 Revert "Merge remote-tracking branch 'upstream/master'"
  • 14eb433 Merge remote-tracking branch 'upstream/master'
  • 1a96e93 Initial commit for OData4 changes
  • 24dad9f Ensure picklist conditions are shown correctly on first attempt
  • e99d978 Handle conditions on EntityName attributes
  • 82d1e47 Update LICENSE
  • 4fd9b32 like-contains-startswith-endswith translations
  • 231db9f Do not validate value if value-of is specified
  • e9c0060 Show friendly name of existing value-of attribute when selecting condition
  • 9d6585e Apply friendly name setting for value-of attribute
  • e85b804 Merge pull request #346 from MarkMpn/idcondition
  • 63cb548 Handle null AttributeTypeName on primary key attributes [ #345 ]

This list of changes was auto generated.

Assets 4

@rappen rappen released this Jul 22, 2020

New features

Improvements

  • Lookup conditions can now select from personal views
  • Simplified result output options
  • Replacing all previous URLs with https://fetchxmlbuilder.com
  • Following Microsoft by replacing CDS with Dataflex

Fixes

  • Fix for very special Customer Address lookup conditions
  • Flow Select formula hint fixed

Thanks to @MarkMpn for contributions! *

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://fetchxmlbuilder.com/

Manual installation

See instruction https://fetchxmlbuilder.com/manual-installation/

Changes:

See More
  • 686c76d 🧹 Using property on OperatorItem to check if column comparison is supported
  • 5fc0a65 Adding property if operator supports column comparison
  • 837cb43 Hide valueof option when adding a condition to a different entity.
  • 8b7f748 Expose attribute
  • 5e08106 Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly from 9.1.0.46 to 9.1.0.49
  • ef41e85 Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly in /FetchXmlBuilder
  • b023cd5 Expose picklist values as dropdowns in entity
  • ce731f8 Expose contain-values & does-not-contain-values conditions
  • ac2c8bd Update README.md
  • 32aa965 Update README.md
  • 70f03f7 Update README.md
  • e681995 Fixing sponsor link
  • 1314824 Removed paypal link
  • 7673aa6 Merge
  • 688dfaf Removing docs (fxb.xrmtoolbox.com) folder
  • 72693bf Update CNAME
  • 522c03f Update FUNDING.yml
  • 84b58fe Update README.md
  • a8ac598 Bump Microsoft.CrmSdk.XrmTooling.WpfControls in /FetchXmlBuilder
  • 69c1046 Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly from 9.1.0.44 to 9.1.0.46
  • 1516402 Bump Microsoft.IdentityModel.Clients.ActiveDirectory in /FetchXmlBuilder
  • 8ff1207 Bump Microsoft.IdentityModel.Clients.ActiveDirectory from 5.2.7 to 5.2.8
  • 763a2ca Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly in /FetchXmlBuilder
  • 6177bf2 Merge branch 'master' of https://github.com/rappen/FetchXMLBuilder
  • e3c133e Minor rebranding, focusing on website https://fetchxmlbuilder.com
  • f688fe5 Special handling to support lookups to customeraddress entity
  • 79ae4ae Including personal views in lookup dialog for condition control
  • 20047b3 Update index.html
  • 6c92736 Update CNAME
  • 122633c Update README.md
  • b5dad90 Create FUNDING.yml
  • 87389d1 Update CNAME
  • b977949 Merge pull request #324 from rappen/dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.XrmTooling.WpfControls-9.1.0.44
  • f8cf3dd Bump Microsoft.Web.Xdt from 3.0.0 to 3.1.0 in /FetchXmlBuilder
  • 22e4f66 Merge branch 'master' into dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.XrmTooling.WpfControls-9.1.0.44
  • 0c34589 Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly in /FetchXmlBuilder
  • bf5bf6d Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly from 9.1.0.43 to 9.1.0.44
  • b3ddaea Merge pull request #321 from rappen/dependabot/nuget/Microsoft.Web.Xdt-3.1.0
  • b281220 Bump Microsoft.CrmSdk.XrmTooling.WpfControls in /FetchXmlBuilder
  • c3accb3 Bump Microsoft.Web.Xdt from 3.0.0 to 3.1.0
  • 5aeda48 Merge pull request #317 from rappen/dependabot/nuget/Microsoft.CrmSdk.Workflow-9.0.2.26
  • 4cbb5b7 Bump Microsoft.CrmSdk.CoreAssemblies from 9.0.2.25 to 9.0.2.26
  • a1c361a Merge branch 'master' into dependabot/nuget/Microsoft.CrmSdk.Workflow-9.0.2.26
  • 1e0b0fb Bump Microsoft.CrmSdk.Deployment from 9.0.2.25 to 9.0.2.26
  • 348a85f Bump Microsoft.CrmSdk.Deployment in /FetchXmlBuilder
  • 5f5795a Bump Microsoft.CrmSdk.Workflow from 9.0.2.25 to 9.0.2.26
  • 052e6c4 Bump Microsoft.CrmSdk.CoreAssemblies in /FetchXmlBuilder
  • f8ee7b6 Bump Microsoft.CrmSdk.Workflow in /FetchXmlBuilder
  • 247f030 Updated hint for Flow Select formula

This list of changes was auto generated.

Assets 4

@rappen rappen released this Jun 7, 2020

New features

🔍 Quick filter results grid! #89
New button can open to new tab, new connection this tab!
Clone query to new tab or new connection!
Added Select formula for Power Automate List Records helper

Improvements

👀 Lookup Dialog now possible for primary key conditions
🔁 Easily switch between lookup and guid conditions
🚀 Performance improvements rendering condition property pane

Fixes

• Fixed bug with queries aggregating on primary key attribute #294
• Undo history was a bit too granular, now reverted
• Fixed issue where FXB was disabled when properties didn’t validate
• Show lookup name instead of guid in treeview when possible

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://jonasr.app/FXB

Manual installation

See wiki page Manual installation

Changes:

  • 086f447 Update FetchXmlBuilder.sln
  • ad70745 Delete FetchXMLBuilder.csproj
  • 1dfe45d Updated release notes
  • b0eb173 Added release notes
  • 2d107fe Show lookup name instead of guid, when possible
  • 6f44896 Disable "Use lookup" if targets not available
  • a89a9a9 Merge pull request #310 from MarkMpn/issue308
  • 4a6426e Merge pull request #311 from MarkMpn/issue309
  • d8b1223 Do not prevent leaving editor control when there are validation errors
  • 5330a00 Only add one history entry when selecting a relationship
See More
  • bfc37f5 Merged Initializing field with ISupportInitializeNotification
  • 3cbb2f7 Merged from master
  • fda03b0 Separate out changes on keypress vs other changes for undo history
  • ed99666 🍾 Added select part of flow list records helper. Closed #306
  • f9fb6d4 🚀 Fixed #295 switch easily between using lookup and entering guid
  • 5da6234 🚀 Added New - New tab - New connection - Clone - Clone new connection features! Closing #234
  • a582e14 Fixed package reference
  • b5383f7 Updated packages/dependencies
  • 64cff68 Update README.md
  • 6c19c1f Merge pull request #304 from rappen/dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.Deployment-9.0.2.25
  • 463cd2e Merge branch 'master' into dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.Deployment-9.0.2.25
  • 4d19f31 Bump Microsoft.CrmSdk.Deployment in /FetchXmlBuilder
  • dadf50d Merge pull request #303 from rappen/dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.Workflow-9.0.2.25
  • cdbcd0e Bump Microsoft.CrmSdk.Workflow in /FetchXmlBuilder
  • 6d8f14d Merge pull request #302 from rappen/dependabot/nuget/FetchXmlBuilder/XrmToolBoxPackage-1.2020.6.40
  • 56114a5 Merge pull request #301 from rappen/dependabot/nuget/FetchXmlBuilder/Microsoft.CrmSdk.XrmTooling.WpfControls-9.1.0.43
  • efad767 Bump XrmToolBoxPackage in /FetchXmlBuilder
  • 6d84a22 Bump Microsoft.CrmSdk.XrmTooling.WpfControls in /FetchXmlBuilder
  • 1c4a97c Merge pull request #297 from rappen/dependabot/nuget/Microsoft.CrmSdk.Deployment-9.0.2.25
  • b2c563f Merge branch 'master' into dependabot/nuget/Microsoft.CrmSdk.Deployment-9.0.2.25
  • c9f6c3f Merge pull request #298 from rappen/dependabot/nuget/Microsoft.CrmSdk.XrmTooling.CoreAssembly-9.1.0.43
  • f7c41fd Merge pull request #296 from rappen/dependabot/nuget/Microsoft.CrmSdk.CoreAssemblies-9.0.2.25
  • e05edf3 Bump Microsoft.CrmSdk.Deployment from 9.0.2.24 to 9.0.2.25
  • a51266d Bump Microsoft.CrmSdk.CoreAssemblies from 9.0.2.24 to 9.0.2.25
  • ae0f7ce Bump Microsoft.CrmSdk.XrmTooling.CoreAssembly from 9.1.0.42 to 9.1.0.43
  • 34f43bc Merge pull request #299 from rappen/dependabot/nuget/Microsoft.CrmSdk.Workflow-9.0.2.25
  • bbeb0fb Bump Microsoft.CrmSdk.Workflow from 9.0.2.24 to 9.0.2.25
  • dad13b5 Preparing for #MscrmTools/XrmToolBox/issues/954
  • 0cc5a8f Using latest XrmToolBox.Controls package
  • 54128d9 🤷‍♂️ Fixing another ResultGrid designer issue that snuck into previous commit
  • 1c6dbd3 🤷‍♂️ Fixing some ResultGrid designer issues that snuck into previous commit
  • 5c3cc96 🔍 Added Quick Filter to result grid! Closing #89
  • 70cff89 🏃‍♂️ Improving performance on initialization of contition control
  • e3eb457 💡 Introducting Initializing flag to go easy on all the events firing as the property control form is initializing.
  • 00b6589 Fixed #293 enable lookup for primary keys and show guid value field when target entity not determined
  • c6b78ce 🧹 Moved EntityNode class to separate file
  • 0943889 Minor nuspec update
  • e5ebe3b Adopting the fix in CRMGridView to solve #294

This list of changes was auto generated.

Assets 4

@rappen rappen released this May 23, 2020

New features

• Select value using Lookup Dialog for lookup attribute conditions
• Added options to show columns with no data
• Added options to hide columns added by the system
• Property validation and continuous saving *
• Escape undoes property changes *
• Button to abort long-duration multi-page retrievals
• Continuous progress reporting for multi-page retrievals
• Value validation of fetch node properties

Improvements

• Informational icons instead of blocking popup messages *
• Scrollbar when all properties do not fit
• Improved relationship presentation *
• Improved performance when rendering results

Fixes

• Restored support for "in" condition operator *
• Return FetchXML button was sometimes hidden
• Another link-entity issue with reversed attributes *

Items marked with * indicate improvements/fixes provided by Mark Carrington.

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://jonasr.app/FXB

Manual installation

See wiki page Manual installation

Changes:

  • 6a78d59 🐛 Fixing bug when retrieving all pages introduced in 1.2020.5.6.
  • 3d2e1dc Release Notes updated
  • ec5bda9 🔍 Using CDSLookupDialog for looup conditions
  • a6fd2d5 Latest packages of XTB and XTB.Controls
  • 11a0174 🚀 Making ControlUtils handle panels with controls
  • bf8a1b5 Adding Lookup control to settings class
  • 56f5f49 Adding setting for Lookup control
  • ea05949 👍 Adding "Show Welcome screen" to About dialog
  • 1d1335b Making GetEntityUrl an extension of ConnectionDetail
  • 80797a9 🧹 Simplification
See More
  • 65d3074 Polishing of the nuspec file
  • 94c6788 🤔 Trying $buildnumber$ parameter for releasenotes link
  • 9fe7838 🤔 Trying to add generic versionized link to GitHub release for full release notes
  • fce9b53 Updated to latest XTB Controls
  • 240a720 🚀 Improved performance by switching off AutoRefresh in result grid.
  • d4183e1 Merge pull request #291 from MarkMpn/columnorder
  • 0325794 Use ColumnOrder property
  • 17d6a1d Merge remote-tracking branch 'upstream/master' into columnorder
  • 36b2119 Merge remote-tracking branch 'upstream/master' into columnorder
  • 895512b Preparing for jamesnovak/xrmtb.XrmToolBox.Controls#8 when that is stable enough
  • 10f8961 🐛 Release notes corrected
  • 0bf0e92 📃 Updated nuspec and added release notes
  • 9eda810 Fixed handling of aliased columns
  • b0bf068 Force column order
  • 206133a Adding informational instructions
  • 6fa1e57 Added errorlevel Info for informational advice
  • 5bda983 Generalizing namespace for temp AppInsights solution before next XTB release
  • 3dfb647 Fixed logging issue by using XTB AppInsights since #4398c99
  • d5fa1c5 Merge branch 'master' of https://github.com/rappen/FetchXMLBuilder
  • 2352a17 🧹 Tiny refactoring post #290
  • 36fa4c1 🧹 Tiny refactoring
  • d1c98aa Merge pull request #290 from MarkMpn/relationships
  • 4836059 Extended relationship lookups to handle self-referential relationships
  • 61d13d4 Fixed #282 Adding scrollbar to properties panel if not all properties are visible.
  • c474ea5 Improved progress reporting when retrieving multiple pages
  • b77baf0 Closed #287 possibility to abort retrieval of multiple pages
  • d5e4bb7 Added validation to fetchControl
  • 2b5f998 🧹 Fixed ugly control name
  • 5b67228 Suspend validation when loading metadata
  • 35eb67a Refactored property validation
  • f1dd4fd 🧹 Refactored a bit
  • 4032712 🧹 Refactoring for my eyes
  • 6ecab4b Using new ColumnOrder property on CRMGridView
  • da81c49 🔃 Updated to latest packages
  • 17655f2 🧹 Fix to prevent (hidden) exceptions during load.
  • 25f5930 Don't blink error/warning, it reminds me of a 1992 webpage...
  • 57edb66 Bugfix, fxb was null when checking Service
  • bd4a0da Merge pull request #284 from MarkMpn/sql4cds-return
  • 8836a9f Ignore callback message from SQL4CDS
  • 63c0ab3 Updated SQL 4 CDS info message
  • 3fe4320 Fixed #280, reverting part of #b5e561f8
  • 4398c99 Removing XTBAppInsights, relying on the same exposed by XTB Plugins Store assembly
  • 9161271 Updated all packages to latest
  • 93c397d Merge pull request #283 from rappen/MarkMpn-live-changes
  • 70dd26a Only warn about invalid entity/Attribute when metadata is available
  • 7138c0d Check for matching metadata by text value rather than index for when text is autocompleted
  • ea4b12c Moved validation UI into base class
  • 6504c5d Merge pull request #1 from rappen/MarkMpn-live-changes
  • e0f8e4f Validation bugfix
  • eed30c5 Unifying control validation
  • 480d2dc Stripped unnecessary usings
  • 72da9cd Merge branch 'live-changes' of https://github.com/MarkMpn/FetchXMLBuilder into MarkMpn-live-changes
  • 8d61eb8 Show metadata mismatches as warnings instead of errors
  • a6e1f99 Coding standards!
  • e41c4ed Merge branch 'live-changes' of https://github.com/MarkMpn/FetchXMLBuilder into MarkMpn-live-changes
  • 97b005c Use Escape key to cancel changes and reset to original values
  • b846b64 Use ErrorProvider to show errors instead of MessageBox
  • a3e7f85 Refactored save & validation of editor controls
  • 6321812 Merge pull request #278 from MarkMpn/live-changes
  • e0b3df9 Extract comma-separated values from condition when finishing editing
  • aa168ff 16 px icons updated to 2019 style finally

This list of changes was auto generated.

Assets 4

@rappen rappen released this May 15, 2020 · 257 commits to master since this release

New features

• Integration with the SQL 4 CDS tool! Read more: https://markcarrington.dev/sql-4-cds/
• Updates to tree node properties are now immediately reflected in FetchXML and treeview

Both improvements above provided by Mark Carrington https://github.com/MarkMpn

Internal

• Flow now called Power Automate #267
• Improved performance for OData v4.0 and Flow – I mean Power Automate – generation
• Using latest and greatest SDKs from Microsoft

Usage

This tool is installed from the Tool Library in XrmToolBox
FetchXML Builder is published on NuGet.
Read more: https://jonasr.app/FXB

Assets 3