Is there a way to find out jira version directly from the database?

Question

Rahul

petry · Answer

Yes:
select * from propertystring where id = (select id from propertyentry where property_key = 'jira.version');

Nic Brough -Adaptavist- · Answer

Actually, no.  It's not stored as a direct number!

You might be able to work it out from the data in the "upgradehistory" table (if a system has ever been upgraded) but the database doesn't actually hold the installation version anywhere.

Chander Inguva · Answer

Hi Rahul,

Try this SQL query and let me know if it helps

select TARGETVERSION from upgradeversionhistory ORDER BY TIMEPERFORMED DESC

Regards

Chander Inguva