Using Database custom field as input into another non-child Database custom field on the same page Edited

First time poster so be gentle please.  

I have a requirement for a user to select a value in a drop down that is loaded from a DB.  That part is done, easy peasy with a Database Custom field.  That value needs to be input to SQL for another DB Customer Field.  (Child doesn't work due to it being in a completely different DB.  I am trying to just use the one but the original is the authoritative source).  Is this possible?  


1 answer

1 accepted

1 vote
Accepted answer
Mikael Sandberg Community Champion Nov 16, 2017

I can answer the first part of your question. Yes, you can have the second field to be dependent on what value is picked in the first one without using a child. That is how I am using it. I have two fields, product and product version, and use the value in product as part of my SQL for product version.

Thank you Mikael.  Any direction you have would be greatly appreciated.  I have a DBCF with SQL that populated a drop down.  The selection on that dropdown needs to be part of a where clause on another DBCF.  How do I reference it?  I tried "where x = {customerfield_ID}" and that didn't work.  Thank you.

Mikael Sandberg Community Champion Nov 16, 2017

Here is what my where clause looks like:

P."Name" = {customfield_11950}

Mikael Sandberg Community Champion Nov 16, 2017

Btw, the "" around Name has to do with PostgreSQL, we migrated from mySQL and PostgreSQL does recognize my tables and columns without the "".

Much appreciated Mikael!  Now I wish I would have split out my questions on here so not everyone bypasses it thinking it was all solved.  Thanks again sir!  Cheers

I went ahead and changed the title so people wouldn't be confused - thanks again

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,105 views 4 9
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