issues that have code commit we can use the below JQL
development[commits].all > 0
How can I find the no of code commits, in each issue Like (JIR-100 - 3 commits, 1 pull request, and JIR-101 - 2 commits, 1 pull request)
For that you need SQL query like below
SELECT
project.name AS "PROJ_NAME",
project.project_key AS "PROJ_KEY",
repository.name AS "REPO_NAME",
repository.slug AS "REPO_SLUG",
sta_pull_request.id AS "PR_ID",
sta_pull_request.title AS "PR_TITLE",
cs_attribute.att_value AS "JIRA_KEY"
FROM
sta_pull_request
INNER JOIN repository ON (sta_pull_request.from_repository_id = repository.id) OR (sta_pull_request.to_repository_id = repository.id)
INNER JOIN project ON (repository.project_id = project.id)
INNER JOIN cs_attribute ON (sta_pull_request.from_hash = cs_attribute.cs_id) OR (sta_pull_request.to_hash = cs_attribute.cs_id)
WHERE cs_attribute.att_name = 'jira-key';
@Muhammad Ramzan(Atlassian Certified Master) Thank you, we are using cloud version, let me know how can I use SQL query in that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.