nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Derek Rone

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?

Accepted answers

Mikael Sandberg

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.

All comments

Mikael Sandberg

Derek Rone

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

Here is what my where clause looks like:

WHERE
P."Name" = {customfield_11950}

Mikael Sandberg

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira

database