I want to search for which projects in JIRA are using the "Project Specific Plug-in", but as far as I know, you have to go to each individual Project and look for whether that project has any custom fields that were created with this plug-in. This can be a monstrously large task if you have a lot of Projects in your database. Is there an easier way to find any projects that are using this plug-in?
This can be easily achieved by running an SQL query against the JIRA database. Something like this:
select * from project where ID in ( select distinct jis.project from customfieldvalue cv join jiraissue jis on cv.issue=jis.id where customfield in (select id from customfield where customfieldtypekey='com.atlassian.jira.plugin.system.customfieldtypes:textfield') );
You have to replace the com.atlassian.jira.plugin.system.customfieldtypes:textfield with the typekey of the project specific custom field.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG