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

[Alex Kiselev _Itransition_]

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]

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.

[Alex Kiselev _Itransition_]

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.

[Alex Kiselev _Itransition_]

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'

[Kian Stack Mumo Systems]

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