Servoy 2020 Documentation
Child pages
  • JSValueList

Versions Compared

Old Version 9

changes.mady.by.user Servoy Docs

Saved on

compared with

New Version 10

changes.mady.by.user Servoy Docs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\ 

{table:id=|class=servoy sSummery}{colgroup}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants SummarySummery{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#CUSTOM_VALUES]
Constant to set the valueListType of a JSValueList.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#DATABASE_VALUES]
Constant to set the valueListType of a JSValueList.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#EMPTY_VALUE_ALWAYS]
Constant to set/get the addEmptyValue property of a JSValueList.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#EMPTY_VALUE_NEVER]
Constant to set/get the addEmptyValue property of a JSValueList.{td}{tr}{tbody}{table}\\ 

{table:id=|class=servoy sSummery}{colgroup}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property SummarySummery{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#addEmptyValue]
Property that tells if an empty value must be shown next to the items in the value list.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#customValues]
A string with the elements in the valuelist.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#dataSource]
Compact representation of the names of the server and table that 
are used for loading the data from the database.{td}{tr}{tbody}{tbody}{tr}{td}[JSMethod]{td}{td}[#globalMethod]
A global method that provides the data for the valuelist.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#name]
The name of the value list.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#relationName]
The name of the relation that is used for loading data from the database.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#separator]
A String representing the separator that should be used when multiple
display dataproviders are set, when the value list has the type set to
database values.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#serverName]
The name of the database server that is used for loading the values when 
the value list has the type set to database values.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#sortOptions]
Sort options that are applied when the valuelist loads its data
from the database.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#tableName]
The name of the database table that is used for loading the values when 
the value list has the type set to database values.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#useTableFilter]
Flag that tells if the name of the valuelist should be applied as a filter on the
'valuelist\_name' column when retrieving the data from the database.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#valueListType]
The type of the valuelist.{td}{tr}{tbody}{table}\\ 

{table:id=|class=servoy sSummery}{colgroup}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method SummarySummery{th}{tr}{tbody}{tr}{td}[Object]\[]{td}{td}[#getDisplayDataProviderIds]\()
Returns an array of the dataproviders that will be used to display the valuelist value.{td}{tr}{tbody}{tbody}{tr}{td}[Object]\[]{td}{td}[#getReturnDataProviderIds]\()
Returns an array of the dataproviders that will be used to define the valuelist value that is saved.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#setDisplayDataProviderIds]\(dataprovider1, \[dataprovider2], \[dataprovider3])
Set the display dataproviders.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#setReturnDataProviderIds]\(dataprovider1, \[dataprovider2], \[dataprovider3])
Set the return dataprovers.{td}{tr}{tbody}{table}\\ 

{table:id=constant|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=03397850-1B5C-4FEB-B9FA-7DDB268445C1=CUSTOM_VALUES|class=node}{tr:id=name}{td}h6.CUSTOM_VALUES{td}{tr}{tr:id=des}{td}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1CUSTOM_VALUES_des|text=|trigger=button}{sub-section}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1CUSTOM_VALUES_des|trigger=none|class=sIndent}Constant to set the valueListType of a JSValueList.
Sets the value list to use a custom list of values.
Also used in solutionModel.newValueList(...) to create new valuelists{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_prsCUSTOM_VALUES_snc|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_prsCUSTOM_VALUES_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{divtd}{tdtr}{trbuilder-show}{builder-show:permission=edit}{tr:id=retprs}{td}*ReturnsParameters*\\{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_retCUSTOM_VALUES_prs|text=|trigger=button}{sub-section}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_retCUSTOM_VALUES_prs|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=seeret}{td}*Also seeReturns*\\{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_seeCUSTOM_VALUES_ret|text=|trigger=button}{sub-section}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_seeCUSTOM_VALUES_ret|trigger=none|class=sIndent|trigger=none}}[Number]{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksee}{td}*ExternalAlso linkssee*\\{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1CUSTOM_VALUES_see|text=|trigger=button}{sub-section}{subdiv:class=sIndent}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_link|class=sIndentCUSTOM_VALUES_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CUSTOM_VALUES_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CUSTOM_VALUES_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1CUSTOM_VALUES_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:03397850-1B5C-4FEB-B9FA-7DDB268445C1_sam|class=sIndentCUSTOM_VALUES_sam|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.valueListType = JSValueList.CUSTOM_VALUES; // Change the type to custom values.
vlist.customValues = "one\ntwo\nthree\nfour";
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F9113E07-E0AB-4FEE-8162-5D7F02D6FF98=DATABASE_VALUES|class=node}{tr:id=name}{td}h6.DATABASE_VALUES{td}{tr}{tr:id=des}{td}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_des|text=|trigger=button}{sub-section}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_des|trigger=none|class=sIndent}Constant to set the valueListType of a JSValueList.
Sets the value list to use values loaded from a database.
Also used in solutionModel.newValueList(...) to create new valuelists{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98_prsDATABASE_VALUES_snc|text=|trigger=button}{sub-section}{div:sub-section:DATABASE_VALUES_snc|trigger=none|class=sIndent} Replace with version info{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DATABASE_VALUES_prs|text=|trigger=button}{sub-section}{sub-section:DATABASE_VALUES_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_ret|text=|trigger=button}{sub-section}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98_see|class=sIndentDATABASE_VALUES_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98_seeDATABASE_VALUES_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98DATABASE_VALUES_sam|text=|trigger=button}{sub-section}{sub-section:F9113E07-E0AB-4FEE-8162-5D7F02D6FF98_sam|class=sIndentdiv:class=sIndent}{sub-section:DATABASE_VALUES_sam|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS|class=node}{tr:id=name}{td}h6.EMPTY_VALUE_ALWAYS{td}{tr}{tr:id=des}{td}{sub-section:EMPTY_VALUE_ALWAYS_des|text=|trigger=button}{sub-section}{sub-section:EMPTY_VALUE_ALWAYS_des|trigger=none|class=sIndent}Constant to set/get the addEmptyValue property of a JSValueList.{sub-section}{td}h6.EMPTY_VALUE_ALWAYS{td}{tr{tr}{builder-show:permission=edit}{tr:id=dessnc}{td}*Since*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_desEMPTY_VALUE_ALWAYS_snc|text=|trigger=button}{sub-section}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_desEMPTY_VALUE_ALWAYS_snc|trigger=none|class=sIndent}Constant toReplace set/getwith the addEmptyValue property of a JSValueList.version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_ret|text=|trigger=button}{sub-section}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_see|class=sIndentEMPTY_VALUE_ALWAYS_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_seeEMPTY_VALUE_ALWAYS_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_link|class=sIndentEMPTY_VALUE_ALWAYS_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9FEMPTY_VALUE_ALWAYS_sam|text=|trigger=button}{sub-section}{sub-section:61BAAFDE-D144-4E8B-BD4B-2BF8B066CC9F_sam|class=sIndentdiv:class=sIndent}{sub-section:EMPTY_VALUE_ALWAYS_sam|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.customValues = "one\ntwo\nthree\nfour";
vlist.addEmptyValue = JSValueList.EMPTY_VALUE_ALWAYS;
var cmb = form.newComboBox('my_table_text', 10, 10, 100, 20);
cmb.valuelist = vlist;
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER|class=node}{tr:id=name}{td}h6.EMPTY_VALUE_NEVER{td}{tr}{tr:id=des}{td}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39C_desEMPTY_VALUE_NEVER_des|text=|trigger=button}{sub-section}{sub-section:EMPTY_VALUE_NEVER_des|trigger=none|class=sIndent}Constant to set/get the addEmptyValue property of a JSValueList.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:EMPTY_VALUE_NEVER_snc|text=|trigger=button}{sub-section}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39C_desEMPTY_VALUE_NEVER_snc|trigger=none|class=sIndent}Constant toReplace set/getwith the addEmptyValue property of a JSValueList.version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_ret|text=|trigger=button}{sub-section}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39Csub-section:EMPTY_VALUE_NEVER_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39C_seeEMPTY_VALUE_NEVER_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39CEMPTY_VALUE_NEVER_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0477FDFE-05C0-47CF-90FB-7D11CC50D39C_sam|class=sIndentEMPTY_VALUE_NEVER_sam|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.customValues = "one\ntwo\nthree\nfour";
vlist.addEmptyValue = JSValueList.EMPTY_VALUE_NEVER;
var cmb = form.newComboBox('my_table_text', 10, 10, 100, 20);
cmb.valuelist = vlist;
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue|class=node}{tr:id=name}{td}h6.addEmptyValue{td}{tr}{tr:id=des}{td}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_des|text=|trigger=button}{sub-section}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_des|trigger=none|class=sIndent}Property that tells if an empty value must be shown next to the items in the value list.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CC_prsaddEmptyValue_snc|text=|trigger=button}{sub-section}{div:sub-section:addEmptyValue_snc|trigger=none|class=sIndent} Replace with version info{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CC}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:addEmptyValue_prs|text=|trigger=button}{sub-section}{sub-section:addEmptyValue_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_ret|text=|trigger=button}{sub-section}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CC_seeaddEmptyValue_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A7A1476F-9E35-4895-90C5-27408D2132CCaddEmptyValue_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.customValues = "one\ntwo\nthree\nfour";
vlist.addEmptyValue = JSValueList.EMPTY_VALUE_NEVER;
var cmb = form.newComboBox('my_table_text', 10, 10, 100, 20);
cmb.valuelist = vlist;
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues|class=node}{tr:id=name}{td}h6.customValues{td}{tr}{tr:id=des}{td}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_des|text=|trigger=button}{sub-section}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_des|trigger=none|class=sIndent}A string with the elements in the valuelist. The elements 
can be separated by linefeeds (custom1
custom2), optional with realvalues ((custom1|1
custom2|2)).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850_prscustomValues_snc|text=|trigger=button}{sub-section}{div:sub-section:customValues_snc|trigger=none|class=sIndent} Replace with version info{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:customValues_prs|text=|trigger=button}{sub-section}{sub-section:customValues_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_ret|text=|trigger=button}{sub-section}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850_seecustomValues_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1658E51D-8625-48B4-8BC1-7BAEA4BC4850customValues_sam|class=sIndent|trigger=none}{code:language=javascript}
var vl1 = solutionModel.newValueList("customtext",JSValueList.CUSTOM_VALUES);
vl1.customValues = "customvalue1\ncustomvalue2";
var vl2 = solutionModel.newValueList("customid",JSValueList.CUSTOM_VALUES);
vl2.customValues = "customvalue1|1\ncustomvalue2|2";
var form = solutionModel.newForm("customvaluelistform",controller.getDataSource(),null,true,300,300);
var combo1 = form.newComboBox("globals.text",10,10,120,20);
combo1.valuelist = vl1;
var combo2 = form.newComboBox("globals.id",10,60,120,20);
combo2.valuelist = vl2;
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource|class=node}{tr:id=name}{td}h6.dataSource{td}{tr}{tr:id=des}{td}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_des|text=|trigger=button}{sub-section}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_des|trigger=none|class=sIndent}Compact representation of the names of the server and table that 
are used for loading the data from the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11_prsdataSource_snc|text=|trigger=button}{sub-section}{div:sub-section:dataSource_snc|trigger=none|class=sIndent} Replace with version info{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:dataSource_prs|text=|trigger=button}{sub-section}{sub-section:dataSource_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_ret|text=|trigger=button}{sub-section}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11_seedataSource_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1C82FAD3-D207-4818-B5B4-E8D013C6AB11dataSource_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod|class=node}{tr:id=name}{td}h6.globalMethod{td}{tr}{tr:id=des}{td}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_des|text=|trigger=button}{sub-section}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_des|trigger=none|class=sIndent}A global method that provides the data for the valuelist. The global method must provided the data 
as a JSDataSet.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5_prsglobalMethod_snc|text=|trigger=button}{sub-section}{div:sub-section:globalMethod_snc|trigger=none|class=sIndent} Replace with version info{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:globalMethod_prs|text=|trigger=button}{sub-section}{sub-section:globalMethod_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_ret|text=|trigger=button}{sub-section}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_ret|trigger=none|class=sIndent}[JSMethod]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5_seeglobalMethod_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:04E5FE41-FA05-40A2-ACA7-0D0DD8979EA5globalMethod_sam|class=sIndent|trigger=none}{code:language=javascript}
var listProvider = solutionModel.newGlobalMethod('function myValueListProvider(displayValue, realValue, record, valueListName) {' +
		'	var result = databaseManager.createEmptyDataSet(0, 1);' +
		'	result.addRow(["one"]);' +
		'	result.addRow(["three"]);' +
		'	result.addRow(["five"]);' +
		'	return result;' +
		'}');
var vlist = solutionModel.newValueList('vlist', JSValueList.CUSTOM_VALUES);
vlist.globalMethod = listProvider;
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname|class=node}{tr:id=name}{td}h6.name{td}{tr}{tr:id=des}{td}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_des|text=|trigger=button}{sub-section}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_des|trigger=none|class=sIndent}The name of the value list.

It is relevant when the "useTableFilter" property is set.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00B_prsname_snc|text=|trigger=button}{sub-section}{div:sub-section:name_snc|trigger=none|class=sIndent} Replace with version info{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00B}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:name_prs|text=|trigger=button}{sub-section}{sub-section:name_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_ret|text=|trigger=button}{sub-section}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00B_seename_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C5F8A90F-CA5D-48D5-9B36-E2D2DCCCB00Bname_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.serverName = 'example_data';
vlist.tableName = 'valuelists';
vlist.setDisplayDataProviderIds('valuelist_data');
vlist.setReturnDataProviderIds('valuelist_data');
vlist.useTableFilter = true;
vlist.name = 'two';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName|class=node}{tr:id=name}{td}h6.relationName{td}{tr}{tr:id=des}{td}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_des|text=|trigger=button}{sub-section}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_des|trigger=none|class=sIndent}The name of the relation that is used for loading data from the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCE_prsrelationName_snc|text=|trigger=button}{sub-section}{div:sub-section:relationName_snc|trigger=none|class=sIndent} Replace with version info{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCE}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:relationName_prs|text=|trigger=button}{sub-section}{sub-section:relationName_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_ret|text=|trigger=button}{sub-section}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCE_seerelationName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D8E6D05B-4FBE-4ED4-9F04-496AFBF5CCCErelationName_sam|class=sIndent|trigger=none}{code:language=javascript}
var rel = solutionModel.newRelation('parent_to_child', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
rel.newRelationItem('parent_table_id', '=', 'child_table_parent_id');

var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.relationName = 'parent_to_child';
vlist.setDisplayDataProviderIds('child_table_text');
vlist.setReturnDataProviderIds('child_table_text');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator|class=node}{tr:id=name}{td}h6.separator{td}{tr}{tr:id=des}{td}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_des|text=|trigger=button}{sub-section}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_des|trigger=none|class=sIndent}A String representing the separator that should be used when multiple
display dataproviders are set, when the value list has the type set to
database values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFF_prsseparator_snc|text=|trigger=button}{sub-section}{div:sub-section:separator_snc|trigger=none|class=sIndent} Replace with version info{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFF}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:separator_prs|text=|trigger=button}{sub-section}{sub-section:separator_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_ret|text=|trigger=button}{sub-section}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFF_seeseparator_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3DC49047-FF69-4F8F-B41A-9EFC513DBFFFseparator_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName|class=node}{tr:id=name}{td}h6.serverName{td}{tr}{tr:id=des}{td}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_des|text=|trigger=button}{sub-section}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_des|trigger=none|class=sIndent}The name of the database server that is used for loading the values when 
the value list has the type set to database values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346_prsserverName_snc|text=|trigger=button}{sub-section}{div:sub-section:serverName_snc|trigger=none|class=sIndent} Replace with version info{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:serverName_prs|text=|trigger=button}{sub-section}{sub-section:serverName_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_ret|text=|trigger=button}{sub-section}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346_seeserverName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:55FDB305-CF82-42B2-A0B8-20F34F7BE346serverName_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=406E097F-5B49-4932-8783-B46434B54F29sortOptions|class=node}{tr:id=name}{td}h6.sortOptions{td}{tr}{tr:id=des}{td}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_des|text=|trigger=button}{sub-section}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_des|trigger=none|class=sIndent}Sort options that are applied when the valuelist loads its data
from the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:406E097F-5B49-4932-8783-B46434B54F29_prssortOptions_snc|text=|trigger=button}{sub-section}{div:sub-section:sortOptions_snc|trigger=none|class=sIndent} Replace with version info{sub-section:406E097F-5B49-4932-8783-B46434B54F29}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:sortOptions_prs|text=|trigger=button}{sub-section}{sub-section:sortOptions_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_ret|text=|trigger=button}{sub-section}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:406E097F-5B49-4932-8783-B46434B54F29_seesortOptions_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:406E097F-5B49-4932-8783-B46434B54F29sortOptions_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName|class=node}{tr:id=name}{td}h6.tableName{td}{tr}{tr:id=des}{td}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_des|text=|trigger=button}{sub-section}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_des|trigger=none|class=sIndent}The name of the database table that is used for loading the values when 
the value list has the type set to database values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FE_prstableName_snc|text=|trigger=button}{sub-section}{div:sub-section:tableName_snc|trigger=none|class=sIndent} Replace with version info{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FE}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:tableName_prs|text=|trigger=button}{sub-section}{sub-section:tableName_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_ret|text=|trigger=button}{sub-section}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FE_seetableName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DBCC21A0-497D-47B9-AFCD-134E7D1309FEtableName_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter|class=node}{tr:id=name}{td}h6.useTableFilter{td}{tr}{tr:id=des}{td}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_des|text=|trigger=button}{sub-section}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_des|trigger=none|class=sIndent}Flag that tells if the name of the valuelist should be applied as a filter on the
'valuelist\_name' column when retrieving the data from the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_snc|text=|trigger=button}{sub-section}{sub-section:useTableFilter_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:useTableFilter_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_ret|text=|trigger=button}{sub-section}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BC_seeuseTableFilter_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F3EB1179-AFA5-40AD-BC54-5AB94EBCB9BCuseTableFilter_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.serverName = 'example_data';
vlist.tableName = 'valuelists';
vlist.setDisplayDataProviderIds('valuelist_data');
vlist.setReturnDataProviderIds('valuelist_data');
vlist.useTableFilter = true;
vlist.name = 'two';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType|class=node}{tr:id=name}{td}h6.valueListType{td}{tr}{tr:id=des}{td}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_des|text=|trigger=button}{sub-section}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_des|trigger=none|class=sIndent}The type of the valuelist. Can be either custom values or database values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_snc|text=|trigger=button}{sub-section}{sub-section:valueListType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:valueListType_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_ret|text=|trigger=button}{sub-section}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0_seevalueListType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_sam|text=|trigger=button}{sub-section-section}{div:class=sIndent}{sub-section:D0D01555-1508-4DBB-9B3C-9C7184D92EC0valueListType_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=4A16CF42-E1C5-445A-89DE-594C58C17C99=getDisplayDataProviderIds|class=node}{tr:id=name}{td}h6.getDisplayDataProviderIds{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getDisplayDataProviderIds{span}{span:id=iets|style=float: left;}\(){span{span}{td}{tr}{tr:id=des}{td}{sub-section:getDisplayDataProviderIds_des|text=|trigger=button}{sub-section}{sub-section:getDisplayDataProviderIds_des|trigger=none|class=sIndent}Returns an array of the dataproviders that will be used to display the valuelist value.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=dessnc}{td}*Since*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99_desgetDisplayDataProviderIds_snc|text=|trigger=button}{sub-section}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99_desgetDisplayDataProviderIds_snc|trigger=none|class=sIndent}Returns anReplace arraywith of the dataproviders that will be used to display the valuelist value.version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_ret|text=|trigger=button}{sub-section}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_ret|trigger=none|class=sIndent}[Object]\[] -- An array of Strings representing the names of the display dataproviders.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99_seegetDisplayDataProviderIds_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4A16CF42-E1C5-445A-89DE-594C58C17C99getDisplayDataProviderIds_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text', 'parent_table_id');
vlist.setReturnDataProviderIds('parent_table_text');
var dispDP = vlist.getDisplayDataProviderIds();
for (var i=0; i<dispDP.length; i++)
	application.output(dispDP[i]);
var retDP = vlist.getReturnDataProviderIds();
for (var i=0; i<retDP.length; i++)
	application.output(retDP[i]);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds|class=node}{tr:id=name}{td}h6.getReturnDataProviderIds{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getReturnDataProviderIds{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932D-section:getReturnDataProviderIds_des|text=|trigger=button}{sub-section}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_des|trigger=none|class=sIndent}Returns an array of the dataproviders that will be used to define the valuelist value that is saved.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932D_prsgetReturnDataProviderIds_snc|text=|trigger=button}{sub-section}{div:sub-section:getReturnDataProviderIds_snc|trigger=none|class=sIndent} Replace with version info{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932D}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getReturnDataProviderIds_prs|text=|trigger=button}{sub-section}{sub-section:getReturnDataProviderIds_prs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_ret|text=|trigger=button}{sub-section}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_ret|trigger=none|class=sIndent}[Object]\[] -- An array of Strings representing the names of the return dataprovider.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932D_seegetReturnDataProviderIds_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A3395DC5-36FF-4C9D-A519-1BD2FF3C932DgetReturnDataProviderIds_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text', 'parent_table_id');
vlist.setReturnDataProviderIds('parent_table_text');
var dispDP = vlist.getDisplayDataProviderIds();
for (var i=0; i<dispDP.length; i++)
	application.output(dispDP[i]);
var retDP = vlist.getReturnDataProviderIds();
for (var i=0; i<retDP.length; i++)
	application.output(retDP[i]);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds|class=node}{tr:id=name}{td}h6.setDisplayDataProviderIds{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}setDisplayDataProviderIds{span}{span:id=iets|style=float: left;}\(dataprovider1, \[dataprovider2], \[dataprovider3]){span}{td}{tr}{tr:id=des}{td}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_des|text=|trigger=button}{sub-section}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_des|trigger=none|class=sIndent}Set the display dataproviders. There can be at most 3 of them, combined with the return dataproviders.
The values taken from these dataproviders, in order, separated by the separator, will be displayed
by the valuelist.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDF_prssetDisplayDataProviderIds_snc|text=|trigger=button}{sub-section}{div:sub-section:setDisplayDataProviderIds_snc|trigger=none|class=sIndent} Replace with version info{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDF}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:setDisplayDataProviderIds_prs|text=|trigger=button}{sub-section}{sub-section:setDisplayDataProviderIds_prs|trigger=none|class=sIndent}dataprovider1 -- The first display dataprovider.
\[dataprovider2\] -- The second display dataprovider.
\[dataprovider3\] -- The third display dataprovider.
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_ret|text=|trigger=button}{sub-section}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDF_seesetDisplayDataProviderIds_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:021D3808-99A5-45EA-89F3-51FFEAD82BDFsetDisplayDataProviderIds_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds|class=node}{tr:id=name}{td}h6.setReturnDataProviderIds{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}setReturnDataProviderIds{span}{span:id=iets|style=float: left;}\(dataprovider1, \[dataprovider2], \[dataprovider3]){span}{td}{tr}{tr:id=des}{td}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_des|text=|trigger=button}{sub-section}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_des|trigger=none|class=sIndent}Set the return dataprovers. There can be at most 3 of them, combined with the display dataproviders.
The values taken from these dataproviders, in order, separated by the separator, will be returned
by the valuelist.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78_prssetReturnDataProviderIds_snc|text=|trigger=button}{sub-section}{div:sub-section:setReturnDataProviderIds_snc|trigger=none|class=sIndent} Replace with version info{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:setReturnDataProviderIds_prs|text=|trigger=button}{sub-section}{sub-section:setReturnDataProviderIds_prs|trigger=none|class=sIndent}dataprovider1 -- The first return dataprovider.
\[dataprovider2\] -- The second return dataprovider.
\[dataprovider3\] -- The third return dataprovider.
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_ret|text=|trigger=button}{sub-section}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_see|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78_seesetReturnDataProviderIds_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_link|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:75D10B88-C055-4D90-9234-DD890FC41F78setReturnDataProviderIds_sam|class=sIndent|trigger=none}{code:language=javascript}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.serverName = 'example_data';
vlist.tableName = 'parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}