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

This widget could not be displayed.
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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

578 views 25 15
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