If you want to use sorting on the client side (which means DataGrip will not rerun the query, but will sort the data within the current page instead), uncheck Sort via ORDER BY.If you would prefer to use stacked sorting, click a column name while holding the Alt key. If you click on the name of a column you want to use to sort data, the sorting based on other columns will be cleared. The sorting is not ‘stacked’ by default.A new ORDER BY field works similar to the WHERE field (which was called Filter before): enter a working clause to have it applied to the query of the grid.Better sorting - Improved data sorting:.This can be done either from the context menu of the field or in the value editor. Added the ability to change the type of a field from the UI.

A statement preview is now also available.

Edit data in MongoDB - Added a crucial feature for working with MongoDB: starting with this version, you can edit data in MongoDB collections.You can also add your own templates or edit the existing ones.You can open the Live Templates settings page and locate the template you need.General Live Templates cover many cases where you need to write a simple query quickly. Context Live Templates - A new solution for anyone wanting to generate simple statements straight from the database explorer.The Modify user window, which you can invoke on a user in the database explorer with Cmd/Ctrl+F6, now has a UI for adding grants to objects.Added a UI for editing grants when modifying objects.UI for grants are available for PostgreSQL, Redshift, Greenplum, MySQL, MariaDB, DB2, Microsoft SQL Server and Sybase.

Datagrip athena