Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,699
Community Members
 
Community Events
168
Community Groups

What table holds the field settings (Required, Hidded) from the 'Field Configuration' object

Hi community,

 

Please help me to find the table where Jira Server holds the Field Configuration settings (field Required, Hidden).

 

Thank you!

 

Best regards,

Alex.

1 answer

I believe it's in the fieldconfiguration table.

 

That being said, one should only update via the database as a last resort due to the potential to corrupt items within.

Hi

 

Thank you for the reply.

 

But it looks like the table 'fieldconfiguration' is for some other information.

The table design is not for storing Required or Hidden information.

Table:fieldconfiguration

Columns are
ID decimal(18,0) PK
configname varchar(255)
DESCRIPTION text
FIELDID varchar(60)
CUSTOMFIELD decimal(18,0)

 

 

For example, the task I would like to resolve by SQL is:

What are the field configurations where custom field X is required?

 

Best regards,

Alex.

I have found the table - its fieldlayoutitem & fieldlayout

select fc.* from fieldlayoutitem fl
inner join fieldlayout fc on (fc.id = fl.fieldlayout)
where fl.fieldidentifier = 'customfield_10011' and ISREQUIRED = 'true'

@Alex Kiselev, sorry! I saw your response and meant to follow up but I forgot! I'm glad you found it!

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events