How Are the Label:Value Pairs Determined for KCF Fields?

Right now we have a variety of KCF Fields pulling in data from a SIL Datasource using the sql() function to query our database. When trying to use those field values in other SIL Scripts, I noticed that the label:value pairs for every one of our KCF Fields are always the same (Meaning the label and value are exactly the same string). I'm wondering how the label:value pairs are determined when a KCF Field is populated by the sql function - are those pairs determined from the database (Meaning that the labels and values are pulled directly from the database) or is there a way to set the SIL Script to assign one sql statement to populate the labels and one sql statement to populate the values?

1 answer

1 accepted

0 votes
Accepted answer

Have you seen this page before ?

Notice the Important note:

If you want to use 2 columns at the select statement, the first column will be considered the label, and the second will be the value. If you have only one column at the select statement, this will be interpreted as label and value at the same time.

Perfect! Must have missed that in the documentation. Thanks Silviu!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Agile

Try the new Jira Cloud add-on for Google Sheets

Hi Atlassian community, I work on the product integration team at Atlassian and I am very excited to announce the early access program for the Jira Cloud add-on for Google Sheets. This add-on giv...

165 views 1 7
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