Content
What should I do if I installed an incompatible version?
Power Database Fields 4.0 is compatible with Jira 7.x.
If you have installed DBCF 3.0.x on JIRA 7.x or DBCF 3.1.x / DBCF 4.0.x on JIRA 6.x, perform the following steps:
- Uninstall katl-commons.
- Uninstall Power Database Fields.
- Install the version of Power Database Fields that is compatible with your Jira.
katl-commons should get updated automatically and should now have the correct version as well.
After you uninstall katl-commons, some plugins may remain disabled, so you might need to re-enable them manually.
I have a large DB with about 30K records and I experience performance issues
Power Database Fields plugin was not designed for dealing with large amount of data. Sometimes, our users reported issues when more than ~10k records were retrieved by the sql queries. this doesn't mean that the app will not work with more than 10K records, it's just that you might experience issues with performance and data retrieval.
We plan to re-write the plugin at some point in time to overcome this limitation.
Database custom fields don't work on Jira 7.X
After updating to Jira 7, some user experimented this error (Error rendering 'databaseinput') when using SQL Server databases or the custom fields simply don't work when using PostgreSQL databases.
I experience difficulties using special characters
When Power Database Fields users use another language than English and it contains special characters, some translation may happen at the JDBC driver level. To avoid this, ensure that the translation between char codes doesn't happen.
How can I use a CF value in the SQL query?
Most of Power Database Fields users are usually using some custom fields in their queries to filter the data returned from database. We're assuming that you have already created a database custom field already at this point.