Global Field Configurations SQL Reporting

unknown

Hello!

I've got a Jira Software Server setup that has quite a few custom fields that have global contexts. I'm working on getting them all cleaned up and associated to projects and issue types.

After I get them cleaned, I would like to have automated reports notify me of any changes. I already have some daily reporting setup to which I would like to add this functionality. I am struggling with figuring out the SQL that would return custom fields with Global contexts.

Has anyone already figured out how to do this?

Daniel Ebers

Hi Ben,

in case you really want to do it using SQL I'd probably look into the Developer resources:
https://developer.atlassian.com/server/jira/platform/database-custom-fields/

Especially this topic here should refer exactly to what you want:
https://developer.atlassian.com/server/jira/platform/database-custom-fields/#custom-field-configuration-schemes

Although not part of an automation as such probably a specialized App with that feature set could be an option. I am thinking of Botronsoft Power Admin as well as several other Apps - but actually it is up to you if you want to query the database or induct an App on getting the requirement sorted out.

Cheers,
Daniel