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

Question

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.

Kian Stack Mumo Systems · Answer

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

Alex Kiselev _Itransition_ · Answer

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 _Itransition_ · Answer

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.