Skip to:

Live SQL Custom Fields

works with Jira Server 7.0.0 - 9.6.0 and more

OVERALL RATINGS

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.

Explore migration program

Key highlights of the appImprove 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.

Supporting media

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.

Resources

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

Security program

This app is not part of the Marketplace Bug Bounty program.

Version information

We no longer offer sales and support for server apps. You can still explore the earlier versions but these may not offer the necessary support.

Explore all server versions

Learn and explore

  • What’s Marketplace
  • App installation
  • About Atlassian
  • Atlassian resources
  • Search and ranking
  • Atlassian events
  • Atlassian foundation

Follow