SQL code to get a list of Structure-enabled projects?

[Andrei [errno]]

does anyone ( ALMWorks folks?  ) have a SQL code to return a list of structure-enabled JIRA projects?
thanks in advance.

[Robert Leitch [ALM Works] · Accepted solution]

Hi Andrei,

SQL won't help there, you'll need to use the getCurentlyEnabledProjects() function in the Structure API.

And the documentation for accessing the Structure API from other plugins.

Edit: you can use Groovy Script Runner to access the Structure API:

import com.atlassian.jira.component.ComponentAccessor
def plugin = ComponentAccessor.getPluginAccessor().getPlugin('com.almworks.jira.structure')
def structureConfig = plugin.getModuleDescriptor(‘structure-configuration’)

 
structureConfig.getCurrentlyEnabledProjects()

Hope that helps!

Robert

[Pavel Zvyagin [ALM Works]]

You'll need .getModule() at the end of line 3: def structureConfig = plugin.getModuleDescriptor('structure-configuration').getModule()