Child pages
  • JSValueList

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Divcache
Div
iddescription
HTML Table
id
classservoy sSummary
Colgroup Tag
Col
width80px
Col
Table Head (thead)
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Constants Summary
Table Row (tr)
Table Cell (td)
Number
Table Cell (td)CUSTOM_VALUES
indexstyletruedisplay:none

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.

refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientsWordListMobileClient

Table Row (tr)

Table Cell (td)
Number
Table Cell (td)DATABASE_VALUES
servoy sSummary12%30%58%height: 30px;3Constants SummaryConstant to set the valueListType of a JSValueList. Table Cell (td)EMPTY_VALUE_ALWAYS
Constant to setConstant to set the valueListType of a JSValueList. Table Row (tr)
Table Cell (td)
Number
Table Cell (td)EMPTY_VALUE_NEVER
Constant to set/get the addEmptyValue property of a JSValueList. Table Row (tr)
Table Cell (td)
Number
Constant to set/get the addEmptyValue property of a JSValueList.

HTML Table

idclassservoy sSummary

Colgroup Tag
Col
width80px
Col
Table Head (thead) Table Row (tr)styleservoy sSummary12%30%58%height: 30px;
Table Head (th)
colspan2
Property Summary
Table Row (tr)
Table Cell (td)
Number
Table Cell (td)addEmptyValue
3Property SummaryProperty that tells if an empty value must be shown next to the items in the value list. Table Row (tr)
Table Cell (td)
String
Table Cell (td)customValues
A string with the elements in the valuelist. Table Row (tr)
Table Cell (td)
String
Table Cell (td)dataSource
Compact representation of the names of the server and table that
Table Row (tr)
Table Cell (td)
JSValueList
Table Cell (td)fallbackValueList
are used for loading the data from the database. Table Row (tr)
Table Cell (td)
JSMethod
Table Cell (td)globalMethod
Gets or sets the fallback valuelist.A global method that provides the data for the valuelist. Table Row (tr)
Table Cell (td)
String
Table Cell (td)name
The name of the value list. Table Row (tr)
Table Cell (td)
String
Table Cell (td)relationName
The name of the relation that is used for loading data from the database. Table Row (tr)
Table Cell (td)
String
Table Cell (td)separator
A String representing the A String representing the separator that should be used when multiple
display dataproviders are set, when the value list has the type set to
Table Row (tr)
Table Cell (td)
String
Table Cell (td)serverName
database values.The name of the database server that is used for loading the values when
Table Row (tr) Table Cell (td) the value list has the type set to database values.void
Table Cell (td)
setFallbackValueList
Table Row (tr)
Table Cell (td)
String
Table Cell (td)sortOptions
Sort options that are applied when the valuelist loads its data
from the database. Table Row (tr)
Table Cell (td)
String
Table Cell (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. Table Row (tr)
Table Cell (td)
Boolean
Table Cell (td)useTableFilter
Flag that tells if the name of the valuelist should be applied as a filter on the
idclassservoy sSummary
Colgroup Tag
Col
width80px
Col
Table Head (thead)
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Method Summary
Table Row (tr)
Table Cell (td)
Object[]
Table Cell (td)getDisplayDataProviderIds()
'valuelist_name' column when retrieving the data from the database.
Table Row (tr)
Table Cell (td)
Number
Table Cell (td)
valueListType
The type of the valuelist.
HTML TableidThe type of the valuelist.

servoy sSummary12%30%58%height: 30px;3Methods SummaryReturns an array of the dataproviders that will be used to display the valuelist value. Table Row (tr)

Table Cell (td)
Object[]
Table Cell (td)getReturnDataProviderIds()
Returns an array of Returns an array of the dataproviders that will be used to define the valuelist value that is saved. Table Row (tr)
Table Cell (td)
UUID
Table Cell (td)getUUID()
Table Cell (td)Returns the UUID of the value list Table Row (tr)setDisplayDataProviderIds()
void Table Cell (td)Set the display dataproviders. Table Row (tr) Table Cell (td)void Table Cell (td)setDisplayDataProviderIds(dataprovider1)
Table Cell (td)Set the display dataproviders. Table Row (tr)void Table Cell (td)setDisplayDataProviderIds(dataprovider1, dataprovider2)
Set the display dataproviders. Table Row (tr)
Table Cell (td)
void
Table Cell (td)setDisplayDataProviderIds(dataprovider1, dataprovider2, dataprovider3)
Set Table Row (tr) Table Cell (td)voidSet the display dataproviders.void Table Cell (td)setReturnDataProviderIds()
Table Cell (td)Set the return dataproviders. Table Row (tr)void Table Cell (td)setReturnDataProviderIds(dataprovider1)
Table Cell (td)Set the return dataproviders. Table Row (tr)void Table Cell (td)setReturnDataProviderIds(dataprovider1, dataprovider2)
Table Cell (td)Set the return dataproviders. Table Row (tr)void Table Cell (td)setReturnDataProviderIds(dataprovider1, dataprovider2, dataprovider3)
Set the return dataproviders.

HTML Table

constantclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col
Table Head (thead) Table Row (tr)styleheight:30px; Table Head (th)colspan2Constants Details Table Body (tbody)ididCUSTOM_VALUES Table Row (tr)nametd

CUSTOM_VALUES

tr

iddes Table Cell (td) DivclasssIndentConstant to set the valueListType of a JSValueList.
Sets the value list to use a custom list of values.
Table Row (tr)id Also used in solutionModel.newValueList(...) to create new valueliststdret

Returns

divsIndentclients

class

Supported Clients

sIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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";
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idDATABASE_VALUES
Table Row (tr)
idname
Table Cell (td)

DATABASE_VALUES

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idEMPTY_VALUE_ALWAYS
Table Row (tr)
idname
Table Cell (td)

EMPTY_VALUE_ALWAYS

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant to set/get the addEmptyValue property of a JSValueList.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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;
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idEMPTY_VALUE_NEVER
Table Row (tr)
idname
Table Cell (td)

EMPTY_VALUE_NEVER

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant to set/get the addEmptyValue property of a JSValueList.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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;
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
HTML Table
idproperty
classservoy sDetail
Colgroup Tag
Col
colspan2
width100%
Col
Table Head (thead)
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Property Details
Table Body (tbody)
idaddEmptyValue
Table Row (tr)
idname
Table Cell (td)

addEmptyValue

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Property that tells if an empty value must be shown next to the items in the value list.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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;
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idcustomValues
Table Row (tr)
idname
Table Cell (td)

customValues

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
A string with the elements in the valuelist. The elements
can be separated by linefeeds (custom1
custom2), optional with realvalues ((custom1|1
custom2|2)).
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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("scopes.globals.text",10,10,120,20);
combo1.valuelist = vl1;
var combo2 = form.newComboBox("scopes.globals.id",10,60,120,20);
combo2.valuelist = vl2;
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
iddataSource
Table Row (tr)
idname
Table Cell (td)

dataSource

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Compact representation of the names of the server and table that
are used for loading the data from the database.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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');
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idfallbackValueList
Table Row (tr)
idname
Table Cell (td)

fallbackValueList

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Gets or sets the fallback valuelist.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
JSValueList
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var myValueList = solutionModel.getValueList('myValueListHere')
 //get fallback value list
var fallbackValueList = myValueList.fallbackValueList
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idglobalMethod
Table Row (tr)
idname
Table Cell (td)

globalMethod

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent

A global method that provides the data for the valuelist. The global method must provided the data
as a JSDataSet.

It is called when the valuelist needs data, it has 3 modes.
real and display params both null: return the whole list
only display is specified, called by a typeahead, return a filtered list
only real value is specified, called when the list doesnt contain the real value for the give record value, this will insert this value into the existing list.

In find mode the record with be the FindRecord which is just like a normal JSRecord (DataRecord) it has the same properties (column/dataproviders) but doesnt have its methods (like isEditing())

Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
JSMethod
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var listProvider = solutionModel.newGlobalMethod('globals', 'function getDataSetForValueList(displayValue, realValue, record, valueListName, findMode) {' +
		'	' +
		'var args = null;' +
		'/** @type QBSelect<db:/example_data/employees> */' +
		'var query = databaseManager.createSelect('db:/example_data/employees');' +
		'/** @type  {JSDataSet} */' +
		'var result = null;' +
		'if (displayValue == null && realValue == null) {' +
		'  // TODO think about caching this result. can be called often!' +
		'  // return the complete list' +
		'  query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname)).add(query.columns.employeeid);' +
		'  result = databaseManager.getDataSetByQuery(query,100);' +
		'} else if (displayValue != null) {' +
		'  // TYPE_AHEAD filter call, return a filtered list' +
		'  args = [displayValue + "%", displayValue + "%"]' +
		'  query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname)).add(query.columns.employeeid).' +
		'  root.where.add(query.or.add(query.columns.firstname.lower.like(args[0] + '%')).add(query.columns.lastname.lower.like(args[1] + '%')));' +
		'  result = databaseManager.getDataSetByQuery(query,100);' +
		'} else if (realValue != null) {' +
		'  // TODO think about caching this result. can be called often!' +
		'  // real object not found in the current list, return 1 row with display,realvalue that will be added to the current list' +
		'  // dont return a complete list in this mode because that will be added to the list that is already there' +
		'  args = [realValue];' +
		'  query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname)).add(query.columns.employeeid).' +
		'  root.where.add(query.columns.employeeid.eq(args[0]));' +
		'  result = databaseManager.getDataSetByQuery(query,1);' +
		'}' +
		'return result;' +
		'}');
var vlist = solutionModel.newValueList('vlist', JSValueList.CUSTOM_VALUES);
vlist.globalMethod = listProvider;
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idname
Table Row (tr)
idname
Table Cell (td)

name

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent

The name of the value list.

It is relevant when the "useTableFilter" property is set.

Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.dataSource = 'db:/example_data/valuelists';
vlist.setDisplayDataProviderIds('valuelist_data');
vlist.setReturnDataProviderIds('valuelist_data');
vlist.useTableFilter = true;
vlist.name = 'two';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idrelationName
Table Row (tr)
idname
Table Cell (td)

relationName

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
The name of the relation that is used for loading data from the database.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var rel = solutionModel.newRelation('parent_to_child', 'db:/example_data/parent_table', 'db:/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.dataSource = 'db:/example_data/parent_table';
vlist.relationName = 'parent_to_child';
vlist.setDisplayDataProviderIds('child_table_text');
vlist.setReturnDataProviderIds('child_table_text');
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idseparator
Table Row (tr)
idname
Table Cell (td)

separator

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idserverName
Table Row (tr)
idname
Table Cell (td)

serverName

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
The name of the database server that is used for loading the values when
the value list has the type set to database values.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetFallbackValueList-JSValueList
Table Row (tr)
idname
Table Cell (td)

setFallbackValueList

Table Row (tr)
idprs
Table Cell (td)

Parameters

Div
classsIndent
{JSValueList} vl
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsortOptions
Table Row (tr)
idname
Table Cell (td)

sortOptions

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Sort options that are applied when the valuelist loads its data
from the database.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idtableName
Table Row (tr)
idname
Table Cell (td)

tableName

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
The name of the database table that is used for loading the values when
the value list has the type set to database values.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
iduseTableFilter
Table Row (tr)
idname
Table Cell (td)

useTableFilter

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Boolean
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.DATABASE_VALUES);
vlist.dataSource = 'db:/example_data/valuelists';
vlist.setDisplayDataProviderIds('valuelist_data');
vlist.setReturnDataProviderIds('valuelist_data');
vlist.useTableFilter = true;
vlist.name = 'two';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idvalueListType
Table Row (tr)
idname
Table Cell (td)

valueListType

Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
The type of the valuelist. Can be either custom values or database values.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Number
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
HTML Table
idfunction
classservoy sDetail
Colgroup Tag
Col
colspan2
width100%
Col
Table Head (thead)
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Method Details
Table Body (tbody)
idgetDisplayDataProviderIds
Table Row (tr)
idname
Table Cell (td)

getDisplayDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
Object[]
Span
stylefont-weight: bold;
getDisplayDataProviderIds
Span
()
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Returns an array of the dataproviders that will be used to display the valuelist value.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Object[] - An array of Strings representing the names of the display dataproviders.
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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]);
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idgetReturnDataProviderIds
Table Row (tr)
idname
Table Cell (td)

getReturnDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
Object[]
Span
stylefont-weight: bold;
getReturnDataProviderIds
Span
()
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Returns an array of the dataproviders that will be used to define the valuelist value that is saved.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
Object[] - An array of Strings representing the names of the return dataprovider.
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
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]);
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idgetUUID
Table Row (tr)
idname
Table Cell (td)

getUUID

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
UUID
Span
stylefont-weight: bold;
getUUID
Span
()
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Returns the UUID of the value list
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
UUID
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
application.output(vlist.getUUID().toString());
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetDisplayDataProviderIds
Table Row (tr)
idname
Table Cell (td)

setDisplayDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setDisplayDataProviderIds
Span
()
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetDisplayDataProviderIds-String
Table Row (tr)
idname
Table Cell (td)

setDisplayDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setDisplayDataProviderIds
Span
(dataprovider1)
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idprs
Table Cell (td)

Parameters

Div
classsIndent
{String} dataprovider1 - The first display dataprovider.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetDisplayDataProviderIds-String_String
Table Row (tr)
idname
Table Cell (td)

setDisplayDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setDisplayDataProviderIds
Span
(dataprovider1, dataprovider2)
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idprs
Table Cell (td)

Parameters

Div
classsIndent
{String} dataprovider1 - The first display dataprovider.
{String} dataprovider2 - The second display dataprovider.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetDisplayDataProviderIds-String_String_String
Table Row (tr)
idname
Table Cell (td)

setDisplayDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setDisplayDataProviderIds
Span
(dataprovider1, dataprovider2, dataprovider3)
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
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.
Table Row (tr)
idprs
Table Cell (td)

Parameters

Div
classsIndent
{String} dataprovider1 - The first display dataprovider.
{String} dataprovider2 - The second display dataprovider.
{String} dataprovider3 - The third display dataprovider.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetReturnDataProviderIds
Table Row (tr)
idname
Table Cell (td)

setReturnDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setReturnDataProviderIds
Span
()
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Set the return dataproviders. 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.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetReturnDataProviderIds-String
Table Row (tr)
idname
Table Cell (td)

setReturnDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setReturnDataProviderIds
Span
(dataprovider1)
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Set the return dataproviders. 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.
Table Row (tr)
idprs
Table Cell (td)

Parameters

Div
classsIndent
{String} dataprovider1 - The first return dataprovider.
Table Row (tr)
idret
Table Cell (td)

Returns

Div
classsIndent
void
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetReturnDataProviderIds-String_String
Table Row (tr)
idname
Table Cell (td)

setReturnDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setReturnDataProviderIds
Span
(dataprovider1, dataprovider2)
Table Row (tr)
iddes
Table Cell (td) Div
classsIndent
Set the return SmartClient,WebClient,NGClient,MobileClientsam

Sample

sIdentjavascript
lastDetailRow&nbsp;
DATABASE_VALUESname

DATABASE_VALUES

dessIndentConstant 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 valuelistsret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
EMPTY_VALUE_ALWAYSname

EMPTY_VALUE_ALWAYS

dessIndentConstant to set/get the addEmptyValue property of a JSValueList.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
EMPTY_VALUE_NEVERname

EMPTY_VALUE_NEVER

dessIndentConstant to set/get the addEmptyValue property of a JSValueList.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;

propertyservoy sDetail2100%height:30px2Property DetailsaddEmptyValuename

addEmptyValue

dessIndentProperty that tells if an empty value must be shown next to the items in the value list.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
customValuesname

customValues

dessIndentA string with the elements in the valuelist. The elements can be separated by linefeeds (custom1 custom2), optional with realvalues ((custom1|1 custom2|2)).ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient,MobileClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
dataSourcename

dataSource

dessIndentCompact representation of the names of the server and table that are used for loading the data from the database.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
fallbackValueListname

fallbackValueList

dessIndentGets or sets the fallback valuelist.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
globalMethodname

globalMethod

dessIndentA global method that provides the data for the valuelist. The global method must provided the data as a JSDataSet. It is called when the valuelist needs data, it has 3 modes. real and display params both null: return the whole list only display is specified, called by a typeahead, return a filtered list only real value is specified, called when the list doesnt contain the real value for the give record value, this will insert this value into the existing list. In find mode the record with be the FindRecord which is just like a normal JSRecord (DataRecord) it has the same properties (column/dataproviders) but doesnt have its methods (like isEditing()) The last argument is rawDisplayValue which contains the same text as displayValue but without converting it to lowercase.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
namename

name

dessIndentThe name of the value list. It is relevant when the "useTableFilter" property is set.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient,MobileClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
relationNamename

relationName

dessIndentThe name of the relation that is used for loading data from the database.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
separatorname

separator

dessIndentA 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.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
serverNamename

serverName

dessIndentThe name of the database server that is used for loading the values when the value list has the type set to database values.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setFallbackValueListname

setFallbackValueList

dessIndentret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
sortOptionsname

sortOptions

dessIndentSort options that are applied when the valuelist loads its data from the database.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
tableNamename

tableName

dessIndentThe name of the database table that is used for loading the values when the value list has the type set to database values.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
useTableFiltername

useTableFilter

dessIndentFlag 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.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
valueListTypename

valueListType

dessIndentThe type of the valuelist. Can be either custom values or database values.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;

functionservoy sDetail2100%height:30px2Methods DetailsgetDisplayDataProviderIdsname

getDisplayDataProviderIds()

dessIndentReturns an array of the dataproviders that will be used to display the valuelist value.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;getReturnDataProviderIdsname

getReturnDataProviderIds()

dessIndentReturns an array of the dataproviders that will be used to define the valuelist value that is saved.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
getUUIDname

getUUID()

dessIndentReturns the UUID of the value listret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setDisplayDataProviderIdsname

setDisplayDataProviderIds()

dessIndentSet 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.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setDisplayDataProviderIdsname

setDisplayDataProviderIds(dataprovider1)

dessIndentSet the display dataproviders. There can be at most 3 of them, combined with the
display return dataproviders.
The values taken from these dataproviders, in order, separated by the separator, will be returned
Table Row (tr)iddisplayed by the valuelist.tdprs

Parameters

Divclass

sIndent{String} dataprovider1 - The first return dataprovider.
{String} dataprovider2 - The second return Table Row (tr)iddisplay dataprovider.ret

Table Cell (td)class

Returns

DivsIndentvoid
Table Row (tr)
idsam
Table Cell (td)

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
Table Row (tr)
classlastDetailRow
Table Cell (td)
 
Table Body (tbody)
idsetReturnDataProviderIds-String_String_String
Table Row (tr)
idname
Table Cell (td)

setReturnDataProviderIds

Table Row (tr)
idsig
Table Cell (td)
Span
stylemargin-right: 5px;
void
Span
stylefont-weight: bold;
setReturnDataProviderIds
Span
(dataprovider1, dataprovider2, dataprovider3)
Table Row (tr)
iddes
Table Cell (td) Div
classsIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setDisplayDataProviderIdsname

setDisplayDataProviderIds(dataprovider1, dataprovider2)

dessIndentSet 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.prs

Parameters

sIndentdataprovider1The first display dataprovider.dataprovider2The second display dataprovider.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setDisplayDataProviderIdsname

setDisplayDataProviderIds(dataprovider1, dataprovider2, dataprovider3)

dessIndentSet 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.prs

Parameters

sIndentdataprovider1The first display dataprovider.dataprovider2The second display dataprovider.dataprovider3The third display dataprovider.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setReturnDataProviderIdsname

setReturnDataProviderIds()

dessIndentSet the return dataproviders. 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.ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setReturnDataProviderIdsname

setReturnDataProviderIds(dataprovider1)

dessIndentSet the return dataproviders. 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
id by the valuelist. Table Row (tr)prs

Table Cell (td)

Parameters

Divclass

sIndent{String} dataprovider1 - The first return dataprovider.
{String} dataprovider2 - The second return dataprovider.
{String} dataprovider3 - The third Table Row (tr)id return dataprovider.ret

Table Cell (td)

Returns

divsIndentclients

classid

Supported Clients

sIndent
void Table Row (tr)SmartClient,WebClient,NGClientsam

Table Cell (td) Table Row (tr)

classlastDetailRow
Table Cell (td) 

Sample

Div
classsIndent
Code Block
languagejavascript
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
vlist.valueListType = JSValueList.DATABASE_VALUES; // Change the type to database values.
vlist.dataSource = 'db:/example_data/parent_table';
vlist.setDisplayDataProviderIds('parent_table_text');
vlist.setReturnDataProviderIds('parent_table_text', 'parent_table_id');
vlist.separator = ' ## ';
vlist.sortOptions = 'parent_table_text desc';
sIdentjavascriptlastDetailRow&nbsp;setReturnDataProviderIdsname

setReturnDataProviderIds(dataprovider1, dataprovider2)

dessIndentSet the return dataproviders. 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.prs

Parameters

sIndentdataprovider1The first return dataprovider.dataprovider2The second return dataprovider.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;
setReturnDataProviderIdsname

setReturnDataProviderIds(dataprovider1, dataprovider2, dataprovider3)

dessIndentSet the return dataproviders. 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.prs

Parameters

sIndentdataprovider1The first return dataprovider.dataprovider2The second return dataprovider.dataprovider3The third return dataprovider.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow&nbsp;