Format Factory

What's new in this version:

New:
- Date Tags - Easily build find or aggregate queries that match for certain dates or date ranges
- Saving SQL Mappings - Save and load configurations of any SQL Migration task to or from a file

Improved:
- Table View - Improved custom column ordering and made it an option alongside alphabetic or natural ordering
- Connection Manager - Studio 3T now prevents deleting connections that are still open on the Connection Tree
- Auto Completion - Autocompletion will now offer proposals appropriate to the connected MongoDB server's capabilites
- Aggregation Editor - Added support for changing the order of stages via drag and drop directly on the Pipeline tab
- Auto Completion - Allow proposals to overwrite any matching code snippet after the cursor position
- IntelliShell - Script editors will now retain focus when a query is run, to allow to directly continue editing
- Migration to/from SQL - Improved performance of getting tables from particular Oracle instances
- Tasks - Parallel executions of the same task will now be prevented with an adequate error message

Fixed:
- General - Database and Collection names now update correctly for views and undocked aggregation tabs
- General - Fixed issues when editing global and connection specifc IntelliShell preferences for the "mongorc.js" file
- General - The "Change target collection" dialog will now reliably show the "Remove Database" button on Ubuntu
- Table View - The specified custom column order for a collection will now be passed reliably to subsequent result tabs
- Collection Tab - Fixed an issue that would prevent deleting or editing documents that have an "_id" with the value "null"
- Collection Tab - Fixed an issue that, after renaming a field, would still show a column with the original field name
- Collection Tab - The projection field now retains its value when toggling the show/hide option
- Collection Tab - Fixed an issue that where multiline content was not pasted correctly into the query field
- Bookmark Manager - The first line of the bookmark overview is now correctly aligned
- GridFS Tab - Fixed an issue that did not release a lock on a file being uploaded to a GridFS bucket
- Index Tab - Index creation errors and validation messages are displayed at the right time
- CSV Import - Fixed an issue with the data type detection not working for CSV fields
- CSV Export - Improved application robustness when opening the Aggregation Editor from the query of a CSV Export
- Copy/Paste Index - Fixed a crash that could occur when pasting an index to a server and then disconnecting it
- Copy/Paste Collections - Fixed a crash that could occur when copying and pasting multiple databases at once
- Reschema - Fixed an issue where a vertical scrollbar would not correctly appear on the Reschema Target table on Ubuntu
- Data Masking - Fixed an issue on Data Masking tabs that prompted users twice to save their unsaved changes
- Data Masking - Data Masking tabs now correctly reflect when the configuration has changed by appending one * to the title
- Data Masking - Fixed an issue that could lead to a crash when closing a connection that was previously used by Data Masking
- Data Masking - Fixed a crash that could occur when opening a Data Masking tab while having a selection of multiple collections
- Visual Query Builder - Fixed an issue on macOS where clicking the Plus button would create two field rules, not one
- Visual Query Builder - Fixed a rare crash that could occur with the Visual Query Builder's split view
- IntelliShell - Fixed a crash when running a query with an empty collection name through Query Assist
- IntelliShell - The shell no longer hangs when dealing with the result of a "getShardDistribution()" command
- IntelliShell - Fixed a crash that could occur when renaming undocked IntelliShell tabs
- IntelliShell - Removed incorrect formatting options from the context menu of the "Raw Shell Output" tab
- Atlas/AWS Authentication - Use of session tokens now works with a correctly formed auth request