The Resources feature allows you to add connections to databases for use in scripts, and other places. For example:
Workflow Validator: Use to check that a particular item exists in your contracts database.
Post-Function: Use to update a sales database with a link to the current ticket.
ScriptRunner manages a connection pool, allowing database connections to be reused when future requests are required. A connection pool eliminates the need to close a connection after each use or specify connection details, such as passwords, in scripts. Instead of entering specific connection information, you can refer to the pool name entered when configuring the connection.
The Resources page lists all previously configured database connections.
After selecting Create Resources, you can use the Search ScriptRunner Functionality search bar to search the available resources.
For example, if you’re looking for a resource that works with local databases, you could type "Local" and press Enter. Then, the list of resources is narrowed down to only those containing the word "local" in their title or description.