Live SQL Custom Fields

for Jira Server 7.0.0 - 9.6.0 and more
26 installs
  • Jira Service Management
  • Jira Software

We no longer offer sales and support for server apps. You can stay connected by exploring the migration options to either the cloud or Data Center version of this app.

Improve and automate Jira by working with dynamic custom field data from your own datasources

ADD and configure your datasaources easily

Add or update datasources for you jdbc connection. The drop down list will show most common drivers and their availability in your Jira instance.

REUSE other elements in your SQL queries

Create dynamic custom field values by reusing other element's values like custom fields, reporters, assignees etc. directly into your SQL queries.

STORE the result in the specified custom field

Store data from different datasources in several custom fields, based on easy SQL queries and view the result in the corresponding issues.

More details

Data

Fetch data from an external database by a custom SQL query that is settable for each custom field in your Jira instance.

Connection

Add/update datasources for any jdbc connection (Oracle, Postgres, MySQL, Microsoft SQL Server or Other) in your Jira instance through a simple user interface.

Queries and synchronization

Define what you want to fetch and how often do you want it updated - real time or periodically. Set the frequency of the synchronization between your datasource and the Jira instance. Your data is always as up to date as you need it.

Specific

Reuse other elements directly into your SQL queries. Create dynamic custom field values by reusing other element's values like custom fields, reporters, assignees etc. directly into your SQL queries. Search for a customfield-id by its name.

Privacy and security

Privacy policy

Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

Partner privacy policy

Resources

Gallery