Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira Software
Questions
List the PR number and associated Issue/Ticket

List the PR number and associated Issue/Ticket

Need to List all the PRs with associated Issue/Ticket on JQL. Are there any options?

1 answer

0 votes

Start from here, just select the columns you want

If you want everybody, just remove the "AND assignee in section"

status not in (Resolved, Archived, Canceled, Closed, Done) AND assignee in ("A.n.Anybody") ORDER BY assignee, key, status ASC, updatedDate ASC

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

HI Connolly,

Thanks for the replay. I am new here. when I just look for "status not in (Resolved, Archived, Canceled, Closed, Done)", I got following error. Any help is appreciated.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

I was able to get fix the above query. But Not able to list the PR ID. Can you let me know if there is anyway we can do that?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Ah, Ok, looks like resolved is standard the others are local to our implementation!

PR ID, is it not available from the columns pull-down?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

No, I was not able to see.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase