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

[Kenneth Breslow]

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?

[Silviu Burcea · Accepted solution]

Have you seen this page before ? https://confluence.kepler-rominfo.com/display/KCFPRO/SQL+Data+Source

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.

[Kenneth Breslow]

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