It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Answer accepted

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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published yesterday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

47 views 0 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