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.)

[Joseph Chung Yin · Accepted solution]

@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.

[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

[Wolfgang Dumke]

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

[Daniel Silverman]

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.

[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

[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"