Live SQL Custom Fields
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.
Fetch data from an external database by a custom SQL query that is settable for each custom field in your Jira instance.
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.
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