customfield_10000

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. 

3 answers

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';

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

| ID    | CUSTOMFIELD | CUSTOMFIELDCONFIG | PARENTOPTIONID | SEQUENCE | customvalue | optiontype | disabled |

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

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

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

 

 

0 vote

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

0 vote

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

  1. Go to the custom fields page
  2. Select one custom field
  3. Click the 'cog icon' and hover your pointer over one of the options
  4. Check the URL that appears on the bottom, it will say the custom field's ID
  5. If the ID matcher one of those, that is the customer field
  6. 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

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,187 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot