2,041
Customers have installed this app in at least 2,041 active instances.
    by cPrimeAtlassian Verified
    cPrime is an Atlassian Verified vendor. Verified vendors demonstrate Atlassian standards for app quality, reliability, and support.

    Learn more

    for Jira Server 7.0.0 - 7.5.3 and more versions
    Versions available for Jira Server 4.3 - 5.2.11
    Jira Server 6.0-m06.1 - 6.4.14
    Supported
    cPrime supports this app.

    Get support

    Data Center
    This app is compatible with the clustering and high-availability capabilities of our products.
    Get it nowFree app

    Free data extractor

    Free data extractor

    Configuration is just easy

    Tables can be scripted

    Our database fields are indexed in Jira

    Configuration means that you need to provide the SQL offering the data, the datasource and optional additional fields (related, child fields). Apart from the datasource, you do not need to edit files.

    Sometimes, showing some data from a database it's not enough. If you need to process it first, here's how.

    You can run reports on them, even if the information is extracted from the database. We provide support for your reporting gadgets.

    More details

    Power Database Fields (formerly Database Custom Field) is a free plugin providing a Database custom field for extracting information at editing time.

    It enables you to import a field value from an external database into a database custom field (simple fields, auto-complete fields, or even tables).

    The value is selected by the user from the set of results (as a select list or autocomplete box) retrieved by executing a query on the database.

    The add-on provides an Administration page where the queries can be associated to these fields.

    Data tables can be scripted with Simple Issue Language (SIL).

    Note: Huge select fields can be addressed by PCF-PRO.

    Reviews for cloud

    (39)
    Sign in to write a review
    by sivabalan N on 2017-08-29
    Plugin is awesome. I saw the limitation like sql query will work only less 10K records. Whether if table contains 10K or fetching the records upto 10K records. Can you please confirm. Thanks Sivabalan N.
    Was this review helpful?YesNo
    cPrime

    Hi Sivabalan,

    Thank you for the review!

    The 10K could be considered a soft limitation as we do not say it won't work, it's that we only guarantee the 10K but it's up to you to try with more records.

    Regarding Groovy, our plugins use Simple Issue Language, so to configure DBCF you'll need either SIL or SQL, not Groovy.

    Feel free to contact our support if you have more questions.

    Cheers!

    by Muhamed Buzaljko on 2017-06-30
    Very useful plugin. Any news about the support for v7.4? Thanks!
    Was this review helpful?YesNo
    cPrime

    Hi Muhamed,

    Thank you for a kind review. Regarding compatibility, we're already working on it, so stay tuned for a new plugin version soon.

    Update: and it's here! :)

    Cheers!

    by IS4IT Atlassian on 2017-04-03
    A good plugin with nice features. But one critical bug for the customers: If I have a set of database fields on a create screen and I move one of the fields to an another tab, the data in the field does not load. When moved back, the field loads the data. Please have a look at that. Thanks! Radim
    Was this review helpful?YesNo
    cPrime

    Hi Radim,

    Thank you for taking time to write a review. We have tested the plugin and noticed that dependency still works even if the parent field is on another tab (at least in the 4.0.0 version). We would like to reproduce your issue and help you, and would appreciate if you give us more details on it here:

    https://jira.cprime.io/servicedesk/customer/portal/2

    by rTrack Support on 2016-12-20
    Hi Team , we have recently tried to use this plugin .we have tried in test server .its working fine .But when i tried to install it in my production server its not working .Please help me on this . it throws the error as Database JNDI is not defined . Possible database misconfiguration ? could not execute sql query Please help me to resolve this .
    Was this review helpful?YesNo
    by Jean-Francois Allot on 2016-11-23
    When using this plugin to access tables already available in the Jira database, I am worried to be forced to duplicate the database parameters in context.xml while there are already declared in dbconfig.xml: can't the plugIn use the "defaultDS" already defined in Jira? (the documentation at https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration doesn't explain if the defaultDS can be used) Thanx
    Was this review helpful?YesNo

    Reviews for server

    (39)
    Sign in to write a review
    by sudhakar reddy on 2017-10-03
    Can you please explain how SQL queries execute. We configure Parameters for the Database Custom Field in that SQL query also one, now the hard part is we need to give custom field as hard coded like rel.textvalue = {customfield_10135}. Now if we want to move from dev to production these custom field IDs will get changes so please advice best way to use IT. Also please let me know where SQL queries will store in JIRA Database once we configure.
    Was this review helpful?YesNo
    cPrime

    Hi there and thank you so much for your kind feedback.

    Regarding your request, you can check out the Power Database Fields documentation or reach out to us via our support portal and our Products Team will help you with it.

    Cheers!

    by sivabalan N on 2017-08-29
    Plugin is awesome. I saw the limitation like sql query will work only less 10K records. Whether if table contains 10K or fetching the records upto 10K records. Can you please confirm. Thanks Sivabalan N.
    Was this review helpful?YesNo
    cPrime

    Hi Sivabalan,

    Thank you for the review!

    The 10K could be considered a soft limitation as we do not say it won't work, it's that we only guarantee the 10K but it's up to you to try with more records.

    Regarding Groovy, our plugins use Simple Issue Language, so to configure DBCF you'll need either SIL or SQL, not Groovy.

    Feel free to contact our support if you have more questions.

    Cheers!

    by Muhamed Buzaljko on 2017-06-30
    Very useful plugin. Any news about the support for v7.4? Thanks!
    Was this review helpful?YesNo
    cPrime

    Hi Muhamed,

    Thank you for a kind review. Regarding compatibility, we're already working on it, so stay tuned for a new plugin version soon.

    Update: and it's here! :)

    Cheers!

    by IS4IT Atlassian on 2017-04-03
    A good plugin with nice features. But one critical bug for the customers: If I have a set of database fields on a create screen and I move one of the fields to an another tab, the data in the field does not load. When moved back, the field loads the data. Please have a look at that. Thanks! Radim
    Was this review helpful?YesNo
    cPrime

    Hi Radim,

    Thank you for taking time to write a review. We have tested the plugin and noticed that dependency still works even if the parent field is on another tab (at least in the 4.0.0 version). We would like to reproduce your issue and help you, and would appreciate if you give us more details on it here:

    https://jira.cprime.io/servicedesk/customer/portal/2

    Pricing

    cPrime provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Version 4.0.6 Jira Server 7.0.0 - 7.5.3 Released 2017-10-02

    Summary

    Bug fix release

    Details

    • Fixed - currentuser for dynamic query failed
    • Fixed an error in passing screen parameters (some values were passed as null)

    Installation

    1. Log into your Jira instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new add-ons from the left-hand side of the page.
    4. Locate Power Database Fields via search. Results include app versions compatible with your Jira instance.
    5. Click Install to download and install your app.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older Power Database Fields versions compatible with your instance, you can look through our version history page.

    Similar apps