What is MySQL query to Resolution IDs and Values?

[Deleted user]

I'm using MySQL 5.6.  Could someone give me the query to look up all the values, descriptions and ID's of the Resolution field?

Thanks

[Joshua Sneed Contegix · Accepted solution]

Hi Steve,

I am not a DBA and i'm writing this from memory, soooo ... be careful, mucking about in the DB can be very bad.

select * from resolution;

 There is a better option though, https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/resolution . Cheers!

[Deleted user]

Thanks Joshua.  I swear I looked and didn't see the resolution table.  I'm more comfortable with SQL than I am with the REST api, and I have a read only account for the DB. 

[Joshua Sneed Contegix]

Welcome Steve! Glad to know you're being safe about it.

It is also possible to log into the app and place any GET API requests into the address bar. The browser will use your cookie for auth and produce JSON results. Find a pleasant JSON formatting browser extension and something about uncle bob. Cheers!

[Matt Doar]

mysql> desc resolution;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| ID | varchar(60) | NO | PRI | NULL | |
| SEQUENCE | decimal(18,0) | YES | | NULL | |
| pname | varchar(60) | YES | | NULL | |
| DESCRIPTION | text | YES | | NULL | |
| ICONURL | varchar(255) | YES | | NULL | |
+-------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)