nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get a list of statuses that show the associated status id?

Jeremy Guralnick

I am uploading a csv file where the status field needs the status id to accept each issue without error. Is there a simple way to get a list of the built-in statuses with their assigned status ids?

In advance search I have entered various queries (e.g. status = 1, status =3, etc.) to get some of the status names, but can't find status ids for all statuses in the workflow (e.g. PENDING, CANCELLED, etc.)

Accepted answers

Joseph Chung Yin

@Jeremy Guralnick -

Welcome to the community.

You can obtain the WF status internal IDs in two ways -

1) Assuming you have Jira Admin rights, then you can access Jira Administration > Issues > Statuses. You can then hover the "Edit" option under the ACTION column to see each status's ID (The link should show up at the bottom left of your screen).

2) Issue the following REST API call via a webbrower tab - https://<based Jira URL address>/rest/api/2/status. It will give you a listing of all WF statuses in your system with its ID.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

All comments

Joseph Chung Yin

@Jeremy Guralnick -

Welcome to the community.

You can obtain the WF status internal IDs in two ways -

2) Issue the following REST API call via a webbrower tab - https://<based Jira URL address>/rest/api/2/status. It will give you a listing of all WF statuses in your system with its ID.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Jeremy Guralnick

Very helpful. Was able to get the Status IDs from your '1' above.

Thanks much,

Jeremy

Joseph Chung Yin

@Jeremy Guralnick

Excellent. Please click on "Accept Answer" button when you have a chance.

Best, Joseph

Daniel Silverman_o0z91y

A third option is to pull an XML file from JIRA that will show you the IDs for each of the steps.

Admin>Issues>Workflows, then find the workflow you need, click "View" for that workflow. Then click export to XML.

Victor Toulouse

None of the above worked for me. I'm not an admin and the API address didn't work.
I found another way:
Open a view that has native filters, filter on status, and get the status ID from the URL.
For example, on the instance I'm working on, it looks something like this:

jira/software/c/projects/<project_name>/issues/?jql=status %3D "To Do"

Wolfgang Dumke

As I am not a Jira admin, 2) worked for me. Thank you @Joseph Chung Yin

Florin Bicher

This one helped, thank you.

A bit of advice for future people - look for the <steps> section at the bottom of the XML file.

nick.jurascheck

Thank you to the OP and for your 'bit of advice' :-)

Lou-Guardia

Another option is to go to the table that stores all of the status numbers and names.

SELECT [ID]
,[SEQUENCE]
,[pname]
,[DESCRIPTION]
,[ICONURL]
,[STATUSCATEGORY]
FROM [prod_jiradb].[dbo].[issuestatus] order by SEQUENCE

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

atl-orange

jira-service-management-cloud

jira-service-management