DataGrip 2022.3 Help

Intention actions

As you work in the editor, DataGrip analyzes your code, searches for ways to optimize it, and detects potential and actual problems.

As soon as the IDE finds a way to alter your code, it displays a yellow bulb icon yellow bulb icon in the editor next to the current line. By clicking this icon, you can view intention actions available in the current context. Intention actions cover a wide range of situations from warnings to optimization suggestions. You can view the full list of intentions and customize them in the Settings/Preferences dialog Ctrl+Alt+S.

A red bulb with an exclamation mark the Quick-fix icon indicates that DataGrip has detected a problem, and prompts you to select an associated fix — a quick-fix. Quick-fixes and intention actions together are called context actions.

Apply intention actions

  1. Click the bulb icon or press Alt+Enter to open the list of suggestions and select an action from the list.

    Intention preview opens automatically. If an intention is complex, and the preview cannot be generated, you will see the intention description. Hover the mouse pointer over available intentions on the suggestion list to preview them.

  2. Press Enter or click an intention on the list to apply it.

    Inject a language with the intention action

You can toggle the preview off and on by pressing Ctrl+Q (View | Quick Documentation) or by enabling Show preview for intention actions when available in Settings/Preferences (Ctrl+Alt+S) Editor | Appearance.

Assign a shortcut to an intention

If you want to apply intention actions quicker, you can assign shortcuts to them. Currently, you cannot assign shortcuts to intentions that belong to code inspections.

  1. In the editor, place the caret at the code that triggers the intention action for which you want to assign a shortcut, and click the bulb icon or press Alt+Enter.

    A list of available suggestions opens.

  2. In the list, click App actions arrow expand next to the necessary intention and from the menu that opens, select Assign shortcut….

    Assigning keyboard shortcut to intention action
  3. In the dialog that opens, specify the shortcut that you want to use for this action and click OK.

After that you won't need to open the list of suggestions to apply this intention action in the editor; you will be able to do it right away by pressing the configured shortcut.

View all intention actions

You can view the full list of available intention actions, and disable actions that you don't need at the moment. To open the list of intention actions:

  1. Press Ctrl+Alt+S to open the IDE settings and select Editor | Intentions.

  2. For each intention action, you can see a description and an example. To disable an intention, clear the checkbox next to it.

  3. Apply the changes and close the dialog.

    Available intention actions

Disable intention actions on the fly

  1. Click the light bulb icon (or press Alt+Enter) to open the list of suggestions.

  2. Select the action you want to disable, click the right arrow next to it, and then click Disable <intention action name>.

    Disable intention action

Disable the intention action bulb icon

You can disable the intention action icon Intention action icon and the quick-fix icon the quick-fix icon in the editor.

  1. Press Ctrl+Alt+S to open the IDE settings and select Editor | General | Appearance.

  2. Disable the Show intention bulb option, apply the changes, and close the dialog.

Examples of intention actions

Introduce a table alias

  1. Place a caret after the table name for which you want to create an alias.

  2. Press Alt+Enter.

  3. Select Introduce table alias.

  4. Type the alias name.

Introduce a table alias

Apply a quick-fix by hovering a cursor

  • if DataGrip knows how to fix the problem, you will know about it by just hovering the mouse over the warning. To fix the problem just click the link at the lower left corner of the tooltip. Alternatively, press Alt+Enter and apply a corresponding action.

    Apply a quick-fix by hovering a cursor

Replace GROUP BY with DISTINCT

  • You can convert GROUP BY to DISTINCT if all the columns of the SELECT clause are presented in the GROUP BY clause. To convert the GROUP BY statement, place the caret at GROUP BY, press Alt+Enter, and select Replace GROUP BY with DISTINCT.

    Convert GROUP BY to DISTINCT
Last modified: 05 December 2022