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?
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.
Hi Everyone! My name is Mina and I am on Atlassian’s Ecosystems Marketing team. Our team is focused on our technology partnerships and marketplace apps. One of Atlassian’s partners is Slack, who ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events