How to get the list of Jira Projects from Custom Field Options?

[Development Tools]

Let us assume the name of the Custom Field is A and it is a drop down which is having Options B, C and D. And this Custom Field A is tagged/linked with Projects: X, Y and Z.

The name of the Custom Field (here A) is unknown to us, but we have the list of Custom Field Options (B, C and D) with us. How can we get the list of the Projects (X, Y and Z) from the Custom Field Options (B, C and D)?

[Grigory Salnikov]

Hi, @Development Tools!

I think the best way to accomplish this is the following:

1. With the help of Home Directory and DB Browser for Jira you can query all the drop-down options:

SELECT * FROM "customfieldoption"

What you need is to find the customfield id (it would be the 2nd column) according to the required custom values (6th column).

2. Now that you know the customfield id you can find out its name:

SELECT * FROM "customfield"

It would be the 1st column and the name we're looking for - the 6th.

3. The final step - you go to the "Custom fields", find the needed one and check its "Available Context(s)" > "Projects"

Hope it helps.