Custom queries in the VS Code extension - Gitlabhq

The GitLab for VS Code extension adds a sidebar to VS Code. This sidebar displays default search queries for each of your projects:

Issues assigned to me
Issues created by me
Merge requests assigned to me
Merge requests created by me
Merge requests I'm reviewing

In addition to the default queries, you can create custom queries.

View search query results in VS Code

Prerequisites:

You're a member of a GitLab project.
You've installed the extension.
You've signed in to your GitLab instance, as described in Setup.

To see search results from your project:

On the left vertical menu bar, select GitLab ({{< icon name="tanuki" >}}) to display the extension sidebar.
In the sidebar, expand Issues and merge requests.
Select a project to view its queries, then select the query you want to run.
Below the query title, select the search result you want to see.
If your search result is a merge request, select what you want to view in VS Code:
- Overview: the description, status, and any comments on this merge request.
- The filenames of all files changed in this merge request. Select a file to view a diff of its changes.
If your search result is an issue, select it to view its description, history, and comments in VS Code.

Create a custom query

Any custom queries you define override the default queries shown in the VS Code sidebar, under Issues and Merge requests.

To override the extension's default queries and replace them with your own:

In VS Code, open the Settings editor:
- For macOS, press <kbd>Command</kbd>+<kbd>,</kbd>.
- For Windows or Linux, press <kbd>Control</kbd>+<kbd>,</kbd>.
In the upper-right corner, select Open Settings (JSON) to edit your settings.json file.

In the file, define gitlab.customQueries, like in this example. Each query should be an entry in the gitlab.customQueries JSON array:

json

{
  "gitlab.customQueries": [
    {
      "name": "Issues assigned to me",
      "type": "issues",
      "scope": "assigned_to_me",
      "noItemText": "No issues assigned to you.",
      "state": "opened"
    }
  ]
}

Optional. When you customize gitlab.customQueries, your definition overrides all default queries. To restore any of the default queries, copy them from the default array in the extension's desktop.package.json file.
Save your changes.

Supported parameters for all queries

Not all item types support all parameters. These parameters apply to all query types:

Parameter	Required	Default	Definition
`name`	{{< yes >}}	not applicable	The label to show in the GitLab panel.
`noItemText`	{{< no >}}	`No items found.`	The text to show if the query returns no items.
`type`	{{< no >}}	`merge_requests`	Which item types to return. Possible values: `issues`, `merge_requests`, `epics`, `snippets`, `vulnerabilities`. Snippets don't support any other filters. Epics are available only on GitLab Premium and Ultimate.

Supported parameters for issue, epic, and merge request queries

All of these parameters are optional.

Parameter	Default	Definition
`assignee`	not applicable	Return items assigned to the given username. `None` returns unassigned GitLab items. `Any` returns GitLab items with an assignee. Not available for epics and vulnerabilities.
`author`	not applicable	Return items created by the given username.
`confidential`	not applicable	Filter confidential or public issues. Available only for issues.
`createdAfter`	not applicable	Return items created after the given date.
`createdBefore`	not applicable	Return items created before the given date.
`draft`	`no`	Filter merge requests against their draft status: `yes` returns only merge requests in draft status, `no` returns only merge requests not in draft status. Available only for merge requests.
`excludeAssignee`	not applicable	Return items not assigned to the given username. Available only for issues. For the current user, set to `<current_user>`.
`excludeAuthor`	not applicable	Return items not created by the given username. Available only for issues. For the current user, set to `<current_user>`.
`excludeLabels`	`[]`	Array of label names. Available only for issues. Items returned have none of the labels in the array. Predefined names are case-insensitive.
`excludeMilestone`	not applicable	The milestone title to exclude. Available only for issues.
`excludeSearch`	not applicable	Search GitLab items that doesn't have the search key in their title or description. Works only with issues.
`labels`	`[]`	Array of label names. Items returned have all labels in the array. `None` returns items with no labels. `Any` returns items with at least one label. Predefined names are case-insensitive.
`maxResults`	20	The number of results to show.
`milestone`	not applicable	The milestone title. `None` lists all items with no milestone. `Any` lists all items with an assigned milestone. Not available for epics and vulnerabilities.
`orderBy`	`created_at`	Return entities ordered by the selected value. Possible values: `created_at`, `updated_at`, `priority`, `due_date`, `relative_position`, `label_priority`, `milestone_due`, `popularity`, `weight`. Some values are specific to issues, and some to merge requests. For more information, see List merge requests.
`reviewer`	not applicable	Return merge requests assigned for review to this username. For the current user, set to `<current_user>`. `None` returns items without a reviewer. `Any` returns items with a reviewer.
`scope`	`all`	Return GitLab items for the given scope. Not applicable for epics. Possible values: `assigned_to_me`, `created_by_me`, `all`.
`search`	not applicable	Search GitLab items against their title and description.
`searchIn`	`all`	Change the scope of the `excludeSearch` search attribute. Possible values: `all`, `title`, `description`. Works only with issues.
`sort`	`desc`	Return issues sorted in ascending or descending order. Possible values: `asc`, `desc`.
`state`	`opened`	Return all issues, or only those matching a particular state. Possible values: `all`, `opened`, `closed`.
`updatedAfter`	not applicable	Return items updated after the given date.
`updatedBefore`	not applicable	Return items updated before the given date.

Supported parameters for vulnerability report queries

Vulnerability reports don't share any common query parameters with other entry types. Each parameter listed in this table works with vulnerability reports only, and all parameters are optional:

Parameter	Default	Definition
`confidenceLevels`	`all`	Returns vulnerabilities belonging to specified confidence levels. Possible values: `undefined`, `ignore`, `unknown`, `experimental`, `low`, `medium`, `high`, `confirmed`.
`reportTypes`	Not applicable	Returns vulnerabilities belonging to specified report types. Possible values: `sast`, `dast`, `dependency_scanning`, `container_scanning`.
`scope`	`dismissed`	Returns vulnerability findings for the given scope. Possible values: `all`, `dismissed`. For more information, see the Vulnerability findings API.
`severityLevels`	`all`	Returns vulnerabilities belonging to specified severity levels. Possible values: `undefined`, `info`, `unknown`, `low`, `medium`, `high`, `critical`.