Where does Jira store the current "build number" of an app's PluginUpgradeTask?

Jira Development Jira Server
1

Hi,
I’m looking for the Jira database table where Jira stores the latest (highest) “build number” returned by an app’s upgrade tasks (PluginUpgradeTask objects). It’s the highest number returned by PluginUpgradeTask#getBuildNumber() for all your app’s upgrade tasks that have already been applied.

Thanks in advance,
David

1 Like
2

Hi,
Jira stores this value in propertystring table, below is query that returns last build number for given plugin key

select e.*, s.propertyvalue from propertyentry e inner join propertystring s on s.id = e.id
where e.PROPERTY_KEY = 'plugin.key:build';
3 Likes
3

Thanks @marcin.kosmala! Of course, they had to hide it in a property value… :smiley:
Fairly useful to force a replay of upgrade tasks during testing…

4

Thanks a lot Marcin!
Really hard to find things like this in Jira/Confluence.