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
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:

WHERE
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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,335 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot