Skip to content

Latest commit

 

History

History
339 lines (271 loc) · 18.2 KB

CHANGELOG.md

File metadata and controls

339 lines (271 loc) · 18.2 KB

Dynatrace Query Language support plugin

Unreleased

Features

  • Updated DQL functions & commands database
  • DQL query execution can now be started from the editor with a shortcut ctrl + enter. If the user selected a part of the query or the cursor is inside a subquery (for example, append command), IDE will as the user to decide which part of the query they want to execute. The shortcut works for DQL fragments injected into other languages as long as the cursor is inside the DQL fragment.
  • DQL queries injected into other languages now support query selection contexts. Previously, for injected fragments, always the whole query was used, ignoring the cursor context. The same principle was applied to gutter icons.
  • Chart tooltips now display the X-axis value as a bold title above the series data row inside tooltips.
  • The DQL results table now shows a right-click context menu on cells.
  • Filtering the DQL table results now supports specifying multiple filters at the same time. Added support for exclude filters.
  • The DQL execution error panel now includes a "Show Executed Query" button that reveals the DQL query that was used for the failed execution.
  • Small UI updates:
    • Changing used icons in multiple places to better match the action they represent

Bug fixes

  • #163: The DQL query selection (when executing the query) will now fully respect the user selection. Previously, it was rounding the selection to the nearest DQL token, which caused issues in some border cases.

  • Fixing an issue with the pie chart throwing an error when the user selects the - value on the list of available values.

  • Fixing an incorrect array accessor inspection for negative values, for example:

    splitString(file_path, "/")[-1]

1.6.0 - 2026-03-09

Features

  • DQL query execution results can now be displayed as visualization. Supported types of graphs: timeseries, lines (XY graph), categories (bar graph), and pies. Visualizations can be opened as another type of view for the DQL execution results panel.
  • The new DQL file creator now automatically lists all supported extensions and adds the selected option automatically to the file name. It also validates whether the provided file name is correct.
  • DQL results shown in the table will now be paged to avoid performance issues in IDE. By default, the table will be showing 1000 records, the user can change that to show up to 5000 records. If the number of records is higher than the selected page size, buttons to change the current page will be displayed.
  • DQL results shown in the table can now be filtered in the whole table, regardless the current page.

Bug fixes

  • #145: Restarting the IDE will no longer automatically open the Services view with the Dynatrace service being selected.

  • DQL Query Console now acts as a fully fledged DQL editor handled natively by IDE. This fixes all issues related to missing features like ctrl + Z or grammar checks in the console.

  • DQL style fix: the plugin will now enforce exactly one space after DQL command keyword (like fetch, filter, etc.).

  • The autocompletion of the DQL data record parameter will now automatically insert the function and will properly insert the comma if needed.

  • Hover documentation for very long string will now be shortened to 2048 characters to avoid issues with IDE hanging

  • DQL enum validations will now be reported only for primitive values, as the plugin is not able to calculate complex expressions without calling Dynatrace REST API. Example:

    // Dynamically calculating the duration from string - the `field` may contain values like "10h"
duration(
  toLong(parse(field, "DIGIT+:amount")),
  parse(field, "DIGIT+ BLANK? DATA:type")
)

1.5.0 - 2026-02-14

Features

  • Small UI improvements:
    • DQL fragment selected during the query execution will now have a green border instead of a selection background
    • Adding data toolbar for DQL execution results opened as a new editor tab
    • Adding an option to change the DQL execution results column order and visibility
    • Adding predefined timeframes to the DQL execution toolbar (user can still define a custom one)
    • The DQL execution result will show an empty cell for a boolean column that had a null value (instead of the unchecked checkbox). This change helps to differentiate between false and null values.
    • All executed DQL queries will be grouped in the Services tab. The root group allows the user to easily access the most common settings related to DQL execution. All queries will be additionally grouped by the tenant they were executed with, allowing the user to easily find the query they are looking for in case of using multiple connected tenants.
    • Double-clicking the executed DQL query in the Services tab will now either open the related file (if possible), or open a new DQL query console with the execution context.
    • Switched to a new Inlay provider. The user can now change inlay settings in Settings > Editor > Inlay hints > Other > DQL.
    • Added an option to toggle validating the DQL query on Dynatrace tenant after each change to the file. Previously only available globally in the plugin's settings, now the option will appear on the DQL Execution Toolbar and allows the user to easily toggle the validation for each file separately.
  • The "Show DQL query" option when executing DQL will now try to show the parsed query instead of the raw one, if possible.
  • Adding support for "Expression DQL" file (with .dqlexpr extension), which allows to define a DQL expression without the command context. Such expression are commonly used in as-a-code DQL queries or in OpenPipeline configurations.
    • An example file file.dqlexpr: matchesValue(field, "value") and not matchesValue(field, "otherValue").
    • All code style & highlighting settings will be inherited from the DQL language.
    • All suitable DQL inspections will be applied to the expression, allowing the user to validate them.
    • Code completion and hover documentation are also supported.
  • Adding support for the "Partial DQL" file type (with .dqlpart extension). This language works similar to the previous .partial.dql files, but allows for an easier separation from the normal DQL file.
    • Added a quick fix to migrate from the old .partial.dql suffix to the new .dqlpart extension.
    • Works exactly like a normal DQL file, but allows to use non-starting commands like filter or sort as the first statement in the query, without causing an error.
    • An example file.dqlpart file: filter field > 10 | sort field desc
    • Support for .partial.dql files will be removed in the future, so it's recommended to migrate to the new extension as soon as possible.
  • Breaking: Changing the approach to the default Dynatrace tenant used for connections - it will be the first tenant specified in the list (previously the user needed to specifically select the default one). Please update the tenants order if you wish to change the default tenant.
  • Created Wiki pages with documentation for the plugin features
  • DQL now supports complex sorting expressions (for example, sort abs(field) > 10 desc)
  • DQL now supports /* language=X */ comments in strings
  • Added missing quick fixes for inspections:
    • Dropping DQL commands and functions for unknown & experimental expressions
    • Renaming the DQL file to .dqlpart when an invalid command context is detected (only for .dql files)
    • Renaming the DQL file to .dqlexpr when the DQL file contains an expression without the command context
  • Adding a Dynatrace Query Console view that allows the user to execute DQL queries without opening a DQL file. You can open the console via the Tools -> Services -> Dynatrace Query Console menu or by clicking the dedicated button in the Services tab.
  • Updated DQL functions & commands database

Bug fixes

  • Creating an empty DQL variable using the $type: dql syntax will now create a multiline comment instead of causing an error.
  • When modifying or deleting a Dynatrace tenant that was already used, files using it will require the user to select a new tenant.
  • Using periods (-1y for years, -1q for quarters, or -1w for weeks) in relative timeframes will now work properly.

1.4.0 - 2026-01-28

Features

  • DQL now supports HEX representations (for example 0x1A3F) for numbers
  • Autocompleting aliases for commands in DPL (for example, both short notation INT and the long one INTEGER will be shown during the autocompletion). Added the missing alias BOOL for the BOOLEAN command.
  • DPL now supports line (//) and block (/* */) comments.
  • DPL now supports SI number (scientific notation, for example (1e23)) and HEX representations (for example, 0x1A3F).
  • DPL now supports "meta" expressions that allow converting the found value into a different type, for example: (('t' <true>:is_found) | ('f' <false>:is_found)) will convert t into true and f into false. Added code style & highlighting settings for such expressions.
  • When a part of DQL query is selected when executed, the selected fragment will be shown as the default option.
  • The DQL execution metadata now appears as a tab in the service panel instead of a separate tab.
  • Adding an option to open DQL results as a new tab after executing the query.
  • Improved the DQL execution errors panel. The plugin will now show more details about the reason for an unsuccessful execution.
  • Reworked hover documentation for both DQL and DPL. The documentation pop-up will now show more details about expression, their parameters & types or possible values. The UI for both languages docs has been unified.
  • Gutter icon for executing DQL queries now appears also on DQL subqueries. Replacing the plugin setting to toggle gutter icons visibility with a dedicated IntelliJ view to manage all gutter icons in the project (Editor -> General -> Gutter icons).
  • Gutter icon for injected DQL fragments will show the DQL execution management toolbar after clicking the action button, allowing the user to overwrite the query configuration for the fragment.

Bug fixes

  • [#87] Avoiding outdated document modifications during injected fragments reformat action
  • DPL configuration expression will now be properly indented on the left side of the expression

1.3.0 - 2026-01-11

Features

  • Major rework for the DQL execution

    • Executing DQLs no longer requires the user to create a Run Configuration - each file will have its own context stored in memory. The user can still create a run configuration to save settings inside IntelliJ project. If they do, the initial configuration for the file will be loaded from the correlated run configuration.
    • Adding a DQL toolbar at the top of each DQL file (similar to .sql files). The toolbar allows the user to set up the Dynatrace context used for the file (to run, verify & autocomplete the query). For injected DQL fragments, the gutter icon will be shown, allowing the user to execute the query. Both are optional and can be enabled/disabled in the plugin's settings.
    • The user can now show the executed DQL fragment and switch between the JSON and table mode to show the execution result.
    • Allowing the user to execute a smaller DQL fragment via text selection and nested DQL queries. In such cases a popup menu will be shown to the user allowing to select which part of the DQL file should be executed.

  • Autocompleting parameter values in all suitable places (for example, in nested expressions of different types)

  • Added autocompleting string quotes in suitable places

  • Adding support for scientific notation numbers in DQL (for example, 1.3e20)

  • Adding support for calculating the expressions data types for supported operators (if possible, for example: long + long)

  • Added support for fields named via the alias parameter. Added an intention to replace alias with assigned expression (=)

  • Replacing manual inspections with automatically generated based on the DQL JSON definition

  • Added support for known Dynatrace Dashboards variables ($variable) replacement for live Notebooks autocompletion and inspections

  • Adding support for replacing DQL variables with DQL query fragments (for example: now() - 4h). To limit the risk of code injections, the fragment must be explicitly set up using the object with the $type: dql property:

    {
  "variableName": {
    "$type": "dql",
    "dql": "now() - 4h"
  }
}

    If the dql property is not a string, the whole object will be parsed as DQL object.

  • When the plugin encounters any issues during the DQL query verification or autocompletion (connecting to the Dynatrace tenant), an error balloon notification will be shown to the user containing the error details. Previously it was just silently ignored by printing the error in IntelliJ logs.

1.2.0 - 2025-12-17

Features

  • Reworked DQL engine to support a better JSON format with the language definition
  • Added more inspections related to:
    • nested negations in conditions (not (not true) could be simplified to just true)
    • negated filtering conditions (filter not true could be replaced with filterOut true)
    • parameter value types (subqueries, fields identifier etc.)
    • disjointed variadic parameters definitions
    • migration from fetch metric.series into metrics command
  • DPL will now be injected within all supported DQL function strings
  • Added support for experimental DQL features (to be enabled in plugin's tool settings)
  • Added search operator ~ code style settings
  • Added intentions to DQL:
    • Splitting and joining consecutive filter and filterOut commands

Bug fixes

  • Field accessor (for example, field[0]) will now be properly indented

1.1.0 - 2025-12-03

Features

  • Added support for DQL comments style settings
  • Added support for Smartscape functions to DQL
  • Added support for other JetBrains tools (like WebStorm)
  • Added support for a bucket parameter inside DQL fetch and timeseries commands
  • Added support for Dynatrace Pattern Language files (.dpl)
    • The support is also automatically added to the DQL parse command
    • Customizable syntax highlighting
    • Local code inspections with quick fixes if possible
    • Customizable code style support — enforcing indents, line breaking and spaces around elements
    • Advanced code completion
    • Hover documentation
    • Useful intentions for managing DPL expressions

1.0.4 - 2025-10-28

Bug fixes

  • #11: Fixed the issue with an invalid expressions precedences

Other

  • #12: Adding support for the load command
  • Added support for the <> operator which is an alternative to !=

1.0.3 - 2025-09-04

Bug fixes

  • #7: Fixing the ClassCastException: PsiPlainTextFileImpl cannot be cast to class pl.thedeem.intellij.dql.DQLFile error that occurred when injecting DQL into other types of files like Markdown (DQL blocks) or Java (/* language=DQL */ injections).

Other

  • Improving error handling for Dynatrace REST API calls. The user will now see more details for errors like an invalid url or an unknown HTML response. Errors will now also be logged, which will be helpful when supporting users

1.0.2 - 2025-08-12

Bug fixes

  • #3: Fixing the Resolving the Legacy configurable id calculation mode from localizable name will be used for configurable class error that started appearing in IDEA 2025.2

Other

  • Rebranded the plugin from "unofficial" to "community-driven open-source" Dynatrace plugin

1.0.1 - 2025-08-11

Bug fixes

  • Fixing the Cannot invoke "java.util.Set.iterator()" because the return value of "pl.thedeem.intellij.dql.definition.DQLOperationTarget.getOperatorType()" is null error

1.0.0 - 2025-08-11

Added

  • Initial version of the plugin
  • Adding support for Dynatrace Query Language files (.dql):
    • Customizable syntax highlighting
    • Local code inspections with quick fixes if possible
    • Customizable code style support — enforcing indents, line breaking and spaces around elements
    • Advanced code completion
    • Hover documentation for commands, parameters, and functions
  • Added an option to connect to a Dynatrace tenant, which allows to:
    • perform live validations on all DQL files (meaning detecting the same issues as in Dynatrace Notebooks)
    • execute DQL queries and show results as a table directly in IntelliJ IDEA
    • autocomplete DQL fields
  • Partial files support NAME.partial.dql:
    • disables live validations and inspections related to query completeness (like missing the data source command or starting with the | symbol)
    • very helpful for projects containing a lot of dynamically joined DQL queries
  • Variables support for DQL queries:
    • special support for DQL queries stored for Dynatrace Dashboards which allows the user to define global variables that are automatically replaced within queries
    • the plugin adds support for dql-variables.json file that contains the static placeholder value that will replace the variable
    • the file is loaded in a hierarchical order: from the same directory, then to the parent one, etc.
    • the file supports specifying record (JSON object), array (JSON array), string, boolean, number, and null types.