DataGrip 2019.2 Help

Search for a target by name (Search everywhere)

DataGrip makes it possible to look for any item of the source code, databases, actions, elements of the user interface, and so on in a single action.

Learn about text search from Finding and replacing text in a project or Finding and replacing text in a file.

Find an object in the database tree view

You can search for any object in the Database tool window. Click any item in the Database tool window and start typing the object name.

Find an object in the database tree view
  1. 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 the results dividing them into sections where your query is found.Press Ctrl+Up or Ctrl+Down (⌘↑/⌘↓ on macOS) to jump between sections.

    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+Shift+Alt+N: finds a symbol.

    • 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 your search, click the Filter icon 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
  3. Type / to see the list of settings that you can quickly access. Select the one you need and pressEnter.

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

  4. You can search for abbreviations. Assign a short code for the action and use the All tab to search for such element and quickly access it. For example, assign an abbreviation for Color Picker.
    • In the Settings/Preferences dialog (Ctrl+Alt+S), go to Keymap. From the options on the right select Other | Show Color Picker.

    • From the context menu, select Add abbreviation.

      Color Picker Add Abbreviation

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

    Now, when you type cp in the search field, DataGrip will display the item to which you've assigned your abbreviation. Press Enter to access the Color Picker dialog.

    Search Results

Filter search results by a data source

In the Search Everywhere dialog, click the All Places list and select the data source that you want to use as a filter.

Filter search results by a data source

Productivity tips

For a quick navigation from the Search Everywhere dialog, consider using the following shortcuts:

Go to the table DDL

Select an object and press shortcut Ctrl+B.

Jump to source

Select an object and press shortcut F4.

Modify a table

Select a table and press shortcut Ctrl+F6.

Select an object in the preferred view

Select an object and press shortcut Alt+F1.

Open quick documentation

Select an object and press shortcut Ctrl+Q.

Open the SQL generator

Select an object and press shortcut Ctrl+Alt+G.

Last modified: 11 November 2019