🧮 Summary of selected cells in Result Grid – like Excel!

Don’t you want to get a summary of the cells that you have selected? I do!
How many cells, how many that are empty, how many unique values, min/max/avg/sum where we can calculate it, etc, etc.

🔵 Not all tables retrieve 5000 records

For all tables that don’t use the default setting, och PageSize gave us a weird result during the retrieving and in the summary at the bottom in the Result View. Issue #1084

Now the tool will accept other default values, getting the page size from the returned records instead of just assuming it is 5000 records.

Now, we are not fooled by the progress panel or the summary.

🟡 Call Excel in a more advanced way

When opening Excel from FetchXML Builder, in some cases, the cells in Excel don’t appear as expected. Issue #1094 reported by @SanjayDFT

A common problem is when there are texts that include newlines. We have the same issue when trying it by manually copy-pasting from any other application. Most commonly, these texts will be split by new-line and are now in several cells.

To solve this issue, it is now possible to select the option “Advanced export to Excel”, which handles those issues better! However, this type takes more time to copy-paste each cell at a time.

Slower it is, but it works!

🔵 Select Result Format in Execute Options

Now it’s even more easier to select how the result shall be shown! Issue #1099

Instead of clicking on the Execute button in the menu, instead click on the tiny arrow in the butter (or like me, pressing the keyboard <SHIFT>+F5) to first open Execute Options to flavor the result how you want it to be.

🟡 Convert query to C# supports filter.AnyAllFilterLinkEntity

Since release 1.2024.4, we have supported a new feature from Microsoft, where we can add link-entities under a filter node. Solved in Issue #1108

Unfortunately, it was not supported when converting to C# in FetchXML Builder. Now it works!