Search templates

When you construct a template for a structural search you are basically writing a script. To simplify your scripting process, DataGrip offers you a list of predefined search templates that you can use as prototypes for your search template.

On how to access the list of the existing search and replace templates, see the structural search and replace section.

Each search or replace template consists of variables $variable_name$ to which you can add a condition (modifier) to narrow your search results. Modifiers depend on a variable in your search template.

Count modifier

The Count modifier specifies a number of occurrences.

If you do not set the Count modifier explicitly, the IDE looks for only one template match. In other words, when the Count modifier is not applied, the default values for the modifier are min = 1 and max = 1.

DataGrip adds [0,∞] to the variable and searches for the specified range of numbers.

Reference modifier

The Reference modifier lets you reference some other search template in the variable.

The reference will always contain the name of a preconfigured or saved template, and you can use auto-completion to fill out this field.

Type modifier

The Type modifier adds a type of the value or expression that is expected for the specified variable.

To find the type category, use the name of the category in square brackets (for example, [string] or [integer]).

To find a specific type, use the name of the type as a modifier value (for example, text, varchar(50), int). Also, you can use regular expression in filter values (for example, varchar$.*$). To enable regular expression, select the Regex checkbox in modifier settings.

UNKNOWN is used for expressions the type of which cannot be identified.
INTEGER is a numeric data type for a range from -2147483648 to 2147483647 (for example, column_1 int).
REAL is a numeric data type for floating precision number data from -3.40E + 38 to 3.40E + 38 (for example, column_1 real).
STRING is a string data type that includes all corresponding types like CHAR, VARCHAR, TEXT and others (for example, column_1 real)
BOOLEAN is a boolean type that can be true or false.
DATE_TIME is a combination of a date and time. Format: YYYY-MM-DD hh:mm:ss.
DATE is a type for dates. Format: YYYY-MM-DD.
TIME is a type for time. Format: hh:mm:ss.
TIMESTAMP is a date and time type that is stored as the number of seconds since the Unix epoch ('1970-01-01 00:00:00' UTC). Format: YYYY-MM-DD hh:mm:ss.
INTERVAL is a type that stores the quantity of time between two datetime values (for example, now() - INTERVAL '1 year 3 hours 20 minutes').
BYTES is a data type that allows whole numbers from 0 to 255.
ARRAY is a composite data type that consists of zero or more elements of a specified data type (for example, column_1 ARRAY[int]).
COLLECTION is an ordered group of elements, all of the same type.
TABLE is a data type that stores a result set for later processing.
RECORD is a data type that allows to create a new data type with the desired column structure.
SETOF is a return type to return a result set.

Text filter

The Text modifier checks the variable against regular expressions or plain text.

For example, the var\d value for the text modifier in the expression context will find all the variables that start with var and have one digit afterwards.

Script constraints

The Script modifier adds Groovy script constraints to the search template. Script constraints are used when you search for certain language constructs.

All variables used in a template can be accessed from script constraints. When you add a script constraint to your variable, DataGrip matches it against the PSI tree, this variable is in fact a node in the PSI tree.

Last modified: 21 September 2023