customfield_10000

Question

I am using JIRA rest api with the below url with proper username and password

https://my-jira-domain/rest/api/2/issue/11817

and in the response i see some fields like

customfield_10000,

customfield_10001,

customfield_10002,...

customfield_10031

wanted to know what are these fields and what can be the possible values for these.

Jonas Andersson · Answer

Best way is using mysql (if thats what you backend your JIRA with).

To see a list of customfields:

select ID, cfname from customfield;

To search for a custom field you know the name of:

select ID, cfname from customfield where cfname like '%location%';

To see the options of a specific customfield:

select * from customfieldoption where CUSTOMFIELD='id goes here';

So as an example:

mysql> select ID, cfname from customfield where cfname like '%locat%';

+-------+--------------------+

| ID    | cfname             |

+-------+--------------------+

| 10305 | Location           |

+-------+--------------------+

1 rows in set (0.00 sec)

mysql> select * from customfieldoption where CUSTOMFIELD='10305';

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

| 10100 |       10305 |             10501 |           NULL |        1 | Amsterdam   | NULL       | N        |

| 10101 |       10305 |             10501 |           NULL |        4 | Hong Kong   | NULL       | N        |

| 10102 |       10305 |             10501 |           NULL |        3 | Stockholm   | NULL       | N        |

| 10103 |       10305 |             10501 |           NULL |        2 | Wasa       | NULL       | Y        |

| 10104 |       10305 |             10501 |           NULL |        5 | Las Vegas        | NULL       | N        |

| 10200 |       10305 |             10501 |           NULL |        0 | Global      | NULL       | N        |

+-------+-------------+-------------------+----------------+----------+-------------+------------+----------+

Jaime S · Answer

If want to know which custom fields these are and if you have access to JIRA, you can:

* Go to the custom fields page
* Select one custom field
* Click the 'cog icon' and hover your pointer over one of the options
* Check the URL that appears on the bottom, it will say the custom field's ID
* If the ID matcher one of those, that is the customer field
* Otherwise, test a different custom field

If you have access to the database, you can check it there too.

Kind regards,
Jaime Kirch da Silveira
Atlassian Cloud Support

Nic Brough -Adaptavist- · Answer

They are custom fields that you have added to your system.  (Note some add-ons like Agile can create them too)

See https://confluence.atlassian.com/jira/adding-a-custom-field-185729521.html