Jira SQL query that returns all required fields in Field Configuration schemas

[Helen Porter]

Hi,

I need to make a list of required fields in jira projects. How to compose sql query in jira database?

[Milan Chheda [INFOSYSTA]]

Fields can be marked as 'Mandatory' in the field configuration and also during 'Transitions'.

If you can looking for mandatory fields while creating an issue, then you should look at 'Field Configurations', provided create issue transition doesn't have any additional validations regarding the mandatory of any other field.

If you are looking for mandatory fields during status transitions then you need to check the workflow and respective validations during that transition.

[Helen Porter]

I know where to look at the required fields. But we have a lot of projects that use a lot of field configurations. I need to dump a list of required fields from Jira database and I don't know which sql query is needed.

[Nic Brough -Adaptavist-]

It's a very long and complicated query.  You'll find it a lot faster to simply look at creating each issue type.