Where current plugin build number is stored?

[Andrzej Warycha]

Hi,

I'm developing PluginUpgradeTask and I'm wondering how to check programmatically or where in database this information is stored.

Thanks in advance.

Andrzej

[Andrzej Warycha · Accepted solution]

Ok I've found it. This information is stored as jira.properties

To get list of current plugin build numbers You have to perform following SQL query

SELECT pe.id,pe.entity_name, pe.property_key,pv.propertyvalue as build_number
  FROM propertyentry as pe left join propertystring as pv on pe.id=pv.id
  where property_key ilike '%:build%' order by 1; 

[Volodymyr Krupach]

I see it's stored :-). Thank you for sharing the result!

[Volodymyr Krupach]

I guess that plugin build number is a value set during publishing your addon to the marketpace and there is no such info in JIRA db.

image2015-8-28 15:52:17.png