Search in DataGrip

Search everywhere

1. In the main menu, go to Navigate | Search Everywhere or press Shift twice to open the search window. By default, DataGrip displays the list of recent files.

   

   Pressing double Shift again or Alt+N for mnemonics will select the Include non-project items checkbox and the list of search results will extend to external items.

   If you switch to other tabs, select the All Places to extend the search results to non-project items.

2. Start typing your query. You can use synonyms in your search. For example, typing toggle presentation mode to search for the presentation mode action will display Enter Presentation Mode in results.

   

   DataGrip lists all of the found results where your query is found. Press Ctrl+Down to jump to the bottom of the list for more... items or Ctrl+Up to return to the top of the search results.

   Press Tab to switch the scope of your search to classes, files, symbols, actions, and so on.

   You can use the following shortcuts to open the search window with the needed scope right from the start:

   • Ctrl+N: finds a class by name.

   • Ctrl+Shift+N: finds any file or directory by name (supports CamelCase and snake_case).

   • Ctrl+Alt+Shift+N: finds a symbol.

     In this case, the search scope will include columns, indexes, and other objects.

   • Ctrl+Shift+A: finds an action by name. You can find any action even if it doesn't have a mapped shortcut or appear in the menu. For example, Emacs actions, such as kill rings, sticky selection, or hungry backspace.

To narrow down your search, click the Filter button () on the window toolbar and select the appropriate option.

For example, when you search for files, you can exclude some file types from your search. And if you are on the Database tab, you can select data sources that you want to include or exclude from the search.

To see the results of your search in the Find tool window, click the Open in Find Tool Window button () on the window toolbar. This button is disabled when you search in the Actions tab.

Search for settings and plugins

You can search for a list of settings, their options, and plugins that you can quickly access, enable, or disable.

1. Press Shift twice to open the search window and type /. DataGrip lists the available groups of settings.

2. Select the one you need and press Enter.

   

   As a result, DataGrip gives you quick access to the selected setting and its options.

   You can also search for plugins and enable or disable them. Type "/plugins" in the search field, in the list of the search results use ON/OFF control keys to enable or disable the needed plugin.

Search for abbreviations

You can assign a short code for the action and use it to search for such action and quickly access it. For example, assign an abbreviation for Color Picker.

1. In the Settings dialog (Ctrl+Alt+S) , go to Keymap. From the options on the right, select Other | Show Color Picker.

2. From the context menu, select Add abbreviation.

   

3. In the dialog that opens, specify the abbreviation you are going to use, for example, cp and click OK.

4. Press Shift twice to open the search window.

5. When you type cp in the search field, DataGrip will display the item to which you have assigned your abbreviation. Press Enter to access the Color Picker dialog.

   

Evaluate mathematical expressions

You can quickly type and evaluate simple mathematical expressions. DataGrip also supports HEX, binary, and octal expressions.

1. Press Shift twice to open the search window.

2. Enter an expression you want to evaluate, DataGrip will display the answer in the search results.

   

   You can use basic arithmetic operators — +, -, *, /, as well as ^ for power — and basic math functions: sqrt(), sin(), cos(), tan().

Manage text search in Search Everywhere

The text search is available by default within the Text tab. Within this tab, you can search for text queries, matching words, including case-sensitive scopes, and regex.

The text search results are also available on the All tab at the bottom of the list. They are displayed when there are few or no other search results available for a given query. You can disable the text search at any time through Advanced Settings.

1. Press Ctrl+Alt+S to open settings and then select Advanced Settings.

2. Scroll down to the Search Everywhere section and disable Show text search results in Search Everywhere.

3. Apply the changes and close the dialog.

Filter search results by a data source

1. In the Search Everywhere dialog, click the Database tab.

2. From the All Places list, select a scope that you want to use as a filter.

   

Filter search results by database object types

You can filter the search results by database object types. To do that, you can either use a tab filter, or the input field commands.

• Using a tab filter:

  1. Press Shift twice to open the search window and open the Database tab. Alternatively, press Ctrl+N.

  2. Click Filter in the upper-right corner of the popup.

  3. In the popup window that opens, select the database object type categories that you need in search results. Categories include the following objects:

     Databases & Schemas	Tables	Scripting	Types
     database external-database external-schema schema	table view materialized-view virtual table foreign-table and so on	function stored procedure aggregate package partition-function and so on	alias-type collection-type object-type table-type

  

• Using the input field commands:

  1. Press Shift twice to open the search window and open the Database tab. Alternatively, press Ctrl+N.

  2. To find all database object of the same type, enter /<database_object_type> (in plural form). For example, /tables.

     As a result, DataGrip gives you a list of all introspected database objects of the type you are looking for.

  3. To find a certain database object of the type, add the database object name as follows: /<database_object_type> <database_object_name>. For example, /tables film.

     Select the database object you need and press Enter.