DataGrip 2020.3 Help

Search in DataGrip

Search and navigation tips

When working with a software tool, searching tends to be a very popular and frequently-used feature that is crucial to a good user experience. In DataGrip, you can look for things like:

  • Database objects: tables, views, procedures, columns, and other objects.

  • Data: full-text search and row filters.

  • Code: code usages in consoles, attached files, views, and routines.

  • Other things: files, settings, IDE actions, and other things.

Database objects

Any tree, list, or popup in DataGrip supports a speed search. For example, when you start typing in a tool window, a matching database object is highlighted.

Speed search supports abbreviations. For instance, ac is enough to find additional_country.

  1. Select a tool window, a tree, a list, or a popup.

  2. Start typing the item name, for example, the name of a file, class, or field. As you type, the Search for field appears over the tool window showing the entered characters, and the selection moves to the first item that matches the specified string. The matching part of the string is highlighted.

    Speed search in a tool window
  3. If several items match the pattern, use the Up and Down keys to move between them. Press Enter to open the selected item. Press Escape to hide the Search for field.

Database objects in Search everywhere

To navigate to a table, a view, a procedure, or any other database object, press Shift twice to open the Search Everywhere window.

Search everywhere

  1. From the main menu, select 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 non-project related items.

    search everywhere popup

  2. Start typing your query. 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.

    Click the Pin icon to list the search results in the Find tool window.

    Press Tab to switch the scope of your search to tables, files, symbols, or actions.

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

    • Ctrl+N: finds a table 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 icon Filter 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.

Exclude file types from search

To see the results of your search in the Find tool window, click the Open in Find tool window icon the Open in Find tool window icon on the window toolbar. This icon is disabled when you search in the Actions scope.

In the Search Everywhere window, if you select a table or a view and press Enter, you will see the table editor. If you select functions or procedures, you will see their source code.

Navigate to any database object

If you want DataGrip to open the DDL view for tables and views, turn off the Prefer data editor over DDL editor option. To find this option, open settings by pressing Ctrl+Alt+S and navigate to Database | General.

If you want to see an object in the database tree, select the Autoscroll from Editor option. This option takes priority over the settings that you have chosen previously.

Enable autoscrol from editor

In case you want to search for columns in a result set or table, invoke the File Structure action Ctrl+F12 and start typing. Speed search filters columns automatically. Press Enter to navigate to the column that you need.

Search for columns in any result-set or table

Data

You can search for text data in your database and filter rows without writing a query.

Search for data in databases, schemes, and separate tables

  1. In the Database tool window (View | Tool Windows | Database ), select objects in which you want to perform your search. You can select a database or a group of databases, a scheme or schemes, or even separate tables.

  2. Right-click the selection and select Full-text search. Alternatively, press Ctrl+Alt+Shift+F.

  3. In the search field of the Full-text Search dialog, type your search request and press Search.

  4. In the Find tool window, review search results. To open a database object, double-click it. To return to the Find tool window (View | Tool Windows | Find ), press Alt+3.

    Search for data in databases

For more information about the full-text search, see Full-text search in databases.

To quickly find data inside a table without writing a statement, call up a text search with the Find action Ctrl+F. It is especially helpful if you do not know what column contains the data that you are looking for. Select the Filter rows checkbox to see only rows with found matches.

Quickly find data inside a table without writing a statement

The Find action works only within the current page of the result set. To configure the page size of the result set, open settings by pressing Ctrl+Alt+S and navigate to Database | Data Views, and clear the Limit page size to checkbox.

Configure the result page size

Using the Row filter

You can enter a filtering SQL condition (like in the WHERE clause) in the <Filter criteria> field.

Using filters

Using the Filter by action

To filter a table according to a cell value, click this cell and select Filter by from the context menu.

Automatically populate a field from the context menu

Code

Using the Find action

To search through the code, use the Find action Ctrl+F.

You can tune a search scope and, for example, exclude comments and string literals from the search.

Exclude comments and literals

You can select a part of code and search through this part only.

Find in selection

You can search for a text string inside the multi-line selection.

  1. Select a multi-line fragment and press Ctrl+F.

  2. Click the In Selection button and type your search string. DataGrip will search for the target inside the selected fragment first.

    If you release the In Selection button, DataGrip will switch the search process back to the whole file.

    If you want to search for the multi-line fragment itself, select it and press Ctrl+F.

    Find in selection

Using the Find in Files action

Find in Path Ctrl+Shift+F looks for code in other consoles, attached files and even in the source code of views and routines.

In our example, if you select Directory, DataGrip looks for sakila only in the postgres-sakila-db folder that is attached to the project. But if you select Scope with the All Places option, DataGrip will also look in other folders (finds the search string in Oracle).

Managing scopes

Using the Find usages action

Find usages Alt+F7 will show you where an object is used. It can be scripts or source codes of other projects. In our example, the actor table is found in dump files, database consoles with different queries and several objects: one rule and three views.

The Find Usages action

Other stuff

To navigate to a file, press Ctrl+Shift+N.

The find file dialog

Speed search works in settings (Ctrl+Alt+S) as well. Earlier in this tutorial, we described the way to set the page size, follow the same steps to locate this setting (see the Using the Find action section ).

Activate a speed search in settings

Find action

Find action Ctrl+Shift+A helps you to find this or that action. It also searches in settings, so Limit page size to setting can be found here as well.

For instance, if you forget how to open a new query console, press Ctrl+Shift+A, type new query and press Enter.

Find a shortcut for an action

Search Everywhere

Search everywhere is another useful feature that looks for any item in databases, files, actions, elements of the user interface, settings, and so on. In the following animation, when you type actor, you see not only database objects, but also available actions (for example, Rename Shift+F6 ). The refactoring can be performed from the list with your search results.

Using the Search everywhere action

Define the scope of Search Everywhere with the filter icon.

Defining the scope of Everywhere

Productivity tips

If you search for a table, you can also use the following actions:

Open the table DDL

Ctrl+B

Open the table data

F4

Open the Modify Table dialog

Ctrl+F6

Open the Select in popup

Alt+F1

Open the Quick documentation popup

Ctrl+Q

Open the SQL generator

Ctrl+Alt+G

Last modified: 25 January 2021