Power Database Fields retriving data from PostgreSQL for a project but not for another

Hello to all.
I installed the Power Database Fields plugin it works well on a custom filed on a project. The problem is that data is not loaded for the same field that is inserted in another project. Does anyone know why it happens?
Thank you all in advance!

2 answers

2 accepted

1 vote
Accepted answer

Have you configured the customfield for all the relevant projects or it can be accessed globally by all the issues? 
Confirm that by going in the customfields area, and find your database customfield? See if the scope is not restricted to specific projects? 

Yes I do.

Customfield Available Context(s): Issue type(s):Global (all issues)

-----

The field in question has a query where the value of another customfield is used with this syntax
select ...... where field_name = {customfield_10104}
The point is that everything works well for another project. I'm going crazy!!!! 

Have you checked if the customfield_10104 is in the context of that project? 

Global context. Apply to all issues in JIRA. 

thank you for your support Tayyab
do you have any other suggestion?

Hi,
It just seems weird for why aren't you able to get the data on another project if you have enabled it for all the projects and the customfield is present on all the relevant screens as well.

Can you try pulling some other field instead of the customfield for testing purposes and see if works? 

For e.g. I am using the same field in various projects and it works fine for me.

Could you check in custom field usage as well if everything is fine.
CF Usage.PNG

ok I do this test
thanks for the support. But first I wanted to ask you where you got that printscreen?

keyboard shortcut: g+g --> Custom field usage

Then type the customfield associated with power database.
It will return something like in above screen.

0 votes
Accepted answer

I solved. Under Tayyab's point I investigated better on the field in question and found that the field was out of the screen. All very strange. The important thing is to solve the problem. Now everything works well.
Thanks to everyone in particular to Tayyab

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Marketplace Apps

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,412 views 0 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you