nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to see all connected issue types to custom field?

Inbar Levi

At the custom fields screen (Jira admin), we can see the Type , Available Context(s) and Screens. Is there a way to see all connected issue types to custom field as well?

I want to make order at the fields and connect each one of them to the right project and issue type via Context(s) options.

Accepted answers

Tom Lister_fo1j4e

Hi @Inbar Levi

If you have access to you database try:

select 
p.pkey as project,
concat(p.pkey, '-',ji.issuenum) as issue,
it.pname as issuetype,
cf.cfname as customfield,
stringvalue, datevalue, numbervalue, textvalue
 from jiraissue ji, project p, customfield cf, customfieldvalue cfv, issuetype it
where ji.project = p.id
and cfv.issue = ji.id
and cfv.customfield = cf.id
and ji.issuetype = it.id

All comments

Sreenivasaraju P

@Inbar Levi,

Yes. You can see the configured issue types under custom field.

Under available context(s), you can see the icons of the configured issue types

But the admin need to make sure they configure the issue types in their context or it will show as Issue type(s):Global (all issues)

custom fields.PNG

Inbar Levi

@Sreenivasaraju P Thanks but that is not what I need , I need to go over all custom fields and find what is the connected issue type/project and then insert it to the context(s) by myself . is there a way to find it easily?

Tom Lister_fo1j4e

Hi @Inbar Levi

If you have access to you database try:

select 
p.pkey as project,
concat(p.pkey, '-',ji.issuenum) as issue,
it.pname as issuetype,
cf.cfname as customfield,
stringvalue, datevalue, numbervalue, textvalue
 from jiraissue ji, project p, customfield cf, customfieldvalue cfv, issuetype it
where ji.project = p.id
and cfv.issue = ji.id
and cfv.customfield = cf.id
and ji.issuetype = it.id