What are the ways to store value (variables) persistently in groovy?

Question

I know about

import com.onresolve.scriptrunner.runner.util.OSPropertyPersister

def pluginSettings = OSPropertyPersister.getPluginSettings()

def key = "key"
def value = "my-value"

// save value against key
pluginSettings.put(key, value)

// retrieve value for key
def savedValue = pluginSettings.get(key)

But is there any other way to store data for later use in scripts? For example suppose I have a counter which is incremented for a specific kind of issue and I want to read it later...

Jeroen Poismans · Answer

Hi,

Just creating tables in the Jira DB is strongly discouraged, since Jira will probably ignore these tables during upgrades etc ...
https://community.atlassian.com/t5/Jira-Core-questions/How-to-insert-a-custom-table-to-JIRA-DB/qaq-p/424568

A few options:

* In your DB engine create a new DB dedicated to your own data you wish to store. That way you don't mess with the Jira DB tables. Then access that data with the Groovy script in my previous reply.
* Another, and probably the best way to go about this from the top of my head is to let Active Objects create a table for you. This would require writing a small plugin that deploys the table for you (this will be in the Jira DB). Here are some Atlassian resources to get you started on that:

https://developer.atlassian.com/server/framework/atlassian-sdk/best-practices-for-developing-with-active-objects/

https://developer.atlassian.com/server/framework/atlassian-sdk/developing-your-plugin-with-active-objects/

Regards,

Jeroen

Siavosh Kasravi · Answer

This is exactly what I am looking for. Is there a suggested way or guideline to add tables tot Jira database?

Jeroen Poismans · Answer

Hi there,

I presume this data you wish to store is not in context of An issue or A project, but rather for the whole instance?

In that case, have you considered adding a table tot the Jira (or other accessible) database?

From groovy you could then access this data, this KB article should help you on your way:
https://scriptrunner.adaptavist.com/4.3.4/jira/recipes/misc/connecting-to-databases.html

Let me know if this helps!

Regards,

Jeroen