project_issue_status_counts

Gets or lists a project_issue_status_counts resource.

Overview

Name	project_issue_status_counts
Type	Resource
Id	gitlab.issues.project_issue_status_counts

Fields

The following fields are returned by SELECT queries:

get

GraphQL response envelope

Name	Datatype	Description
all_	integer	Number of issues with status ALL for the project
closed	integer	Number of issues with status CLOSED for the project
opened	integer	Number of issues with status OPENED for the project

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	full_path, host	assignee_id, assignee_wildcard_id, author_username, closed_after, closed_before, confidential, created_after, created_before, crm_contact_id, crm_organization_id, due_after, due_before, epic_id, epic_wildcard_id, health_status_filter, iid, include_subepics, iteration_title, iteration_wildcard_id, milestone_wildcard_id, my_reaction_emoji, release_tag_wildcard_id, search, subscribed, updated_after, updated_before, weight, weight_wildcard_id	Counts of issues by status for the project. Generated from the GitLab GraphQL schema field Project.issueStatusCounts (IssueStatusCountsType).

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
full_path	string	Full path of the project, for example gitlab-org/gitlab
host	string	GitLab host, with an optional port (default gitlab.com). Resolved from the GITLAB_HOST environment variable when it is set (x-stackQL-envVar); a WHERE host value always takes precedence. Self-managed instances: the provider is generated from the gitlab.com schema, so older instances may reject fields they do not serve. (default: gitlab.com, x-stackQL-envVar: GITLAB_HOST)
assignee_id	string	ID of a user assigned to the issues. Wildcard values "NONE" and "ANY" are supported.
assignee_wildcard_id	string	Filter by assignee wildcard. Incompatible with assigneeUsername and assigneeUsernames.
author_username	string	Username of the author of the issue.
closed_after	string	Issues closed after the date.
closed_before	string	Issues closed before the date.
confidential	boolean	Filter for confidential issues. If "false", excludes confidential issues. If "true", returns only confidential issues.
created_after	string	Issues created after the date.
created_before	string	Issues created before the date.
crm_contact_id	string	ID of a contact assigned to the issues.
crm_organization_id	string	ID of an organization assigned to the issues.
due_after	string	Return issues due on or after the given time.
due_before	string	Return issues due on or before the given time.
epic_id	string	ID of an epic associated with the issues, "none" and "any" values are supported.
epic_wildcard_id	string	Filter by epic ID wildcard. Incompatible with epicId.
health_status_filter	string	Health status of the issue, "none" and "any" values are supported.
iid	string	IID of the issue. For example, "1".
include_subepics	boolean	Whether to include subepics when filtering issues by epicId.
iteration_title	string	Filter by iteration title.
iteration_wildcard_id	string	Filter by iteration ID wildcard.
milestone_wildcard_id	string	Filter issues by milestone ID wildcard.
my_reaction_emoji	string	Filter by reaction emoji applied by the current user. Wildcard values "NONE" and "ANY" are supported.
release_tag_wildcard_id	string	Filter issues by release tag ID wildcard.
search	string	Search query for title or description.
subscribed	string	Issues the current user is subscribed to.
updated_after	string	Issues updated after the date.
updated_before	string	Issues updated before the date.
weight	string	Weight applied to the issue, "none" and "any" values are supported.
weight_wildcard_id	string	Filter by weight ID wildcard. Incompatible with weight.

SELECT examples

get

Counts of issues by status for the project. Generated from the GitLab GraphQL schema field Project.issueStatusCounts (IssueStatusCountsType).

SELECT
all_,
closed,
opened
FROM gitlab.issues.project_issue_status_counts
WHERE full_path = '{{ full_path }}' -- required
AND host = '{{ host }}' -- required (defaults to gitlab.com; or set GITLAB_HOST)
AND assignee_id = '{{ assignee_id }}'
AND assignee_wildcard_id = '{{ assignee_wildcard_id }}'
AND author_username = '{{ author_username }}'
AND closed_after = '{{ closed_after }}'
AND closed_before = '{{ closed_before }}'
AND confidential = '{{ confidential }}'
AND created_after = '{{ created_after }}'
AND created_before = '{{ created_before }}'
AND crm_contact_id = '{{ crm_contact_id }}'
AND crm_organization_id = '{{ crm_organization_id }}'
AND due_after = '{{ due_after }}'
AND due_before = '{{ due_before }}'
AND epic_id = '{{ epic_id }}'
AND epic_wildcard_id = '{{ epic_wildcard_id }}'
AND health_status_filter = '{{ health_status_filter }}'
AND iid = '{{ iid }}'
AND include_subepics = '{{ include_subepics }}'
AND iteration_title = '{{ iteration_title }}'
AND iteration_wildcard_id = '{{ iteration_wildcard_id }}'
AND milestone_wildcard_id = '{{ milestone_wildcard_id }}'
AND my_reaction_emoji = '{{ my_reaction_emoji }}'
AND release_tag_wildcard_id = '{{ release_tag_wildcard_id }}'
AND search = '{{ search }}'
AND subscribed = '{{ subscribed }}'
AND updated_after = '{{ updated_after }}'
AND updated_before = '{{ updated_before }}'
AND weight = '{{ weight }}'
AND weight_wildcard_id = '{{ weight_wildcard_id }}'
;