Unknown macro: {sub-section}
Unknown macro: {table}
{column:padding=0px|width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Constants Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
CUSTOM_VALUES
Constant to set the valueListType of a JSValueList.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
DATABASE_VALUES
Constant to set the valueListType of a JSValueList.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
EMPTY_VALUE_ALWAYS
Constant to set/get the addEmptyValue property of a JSValueList.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
EMPTY_VALUE_NEVER
Constant to set/get the addEmptyValue property of a JSValueList.
Unknown macro: {table}
{column:padding=0px|width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Property Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
addEmptyValue
Property that tells if an empty value must be shown next to the items in the value list.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
customValues
A string with the elements in the valuelist.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
dataSource
Compact representation of the names of the server and table that
are used for loading the data from the database.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
globalMethod
A global method that provides the data for the valuelist.
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
relationName
The name of the relation that is used for loading data from the database.
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {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.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
sortOptions
Sort options that are applied when the valuelist loads its data
from the database.
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {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.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
valueListType
The type of the valuelist.
Unknown macro: {table}
{column:padding=0px|width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Method Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Object[]
Unknown macro: {td}
getDisplayDataProviderIds()
Returns an array of the dataproviders that will be used to display the valuelist value.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Object[]
Unknown macro: {td}
getReturnDataProviderIds()
Returns an array of the dataproviders that will be used to define the valuelist value that is saved.
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
void
Unknown macro: {td}
setDisplayDataProviderIds(dataprovider1, [dataprovider2], [dataprovider3])
Set the display dataproviders.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
void
Unknown macro: {td}
setReturnDataProviderIds(dataprovider1, [dataprovider2], [dataprovider3])
Set the return dataprovers.
Unknown macro: {table}
{column:padding=0px|width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Constants Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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";
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Constant to set/get the addEmptyValue property of a JSValueList.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Constant to set/get the addEmptyValue property of a JSValueList.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {table}
{column:padding=0px|width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Property Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Property that tells if an empty value must be shown next to the items in the value list.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
A string with the elements in the valuelist. The elements
can be separated by linefeeds (custom1
custom2), optional with realvalues ((custom1|1
custom2|2)).
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Compact representation of the names of the server and table that
are used for loading the data from the database.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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');
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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())
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
var listProvider = solutionModel.newGlobalMethod('function getDataSetForValueList(displayValue, realValue, record, valueListName, findMode) {' +
' ' +
'if (displayValue == null && realValue == null) {' +
' // TODO think about caching this result. can be called often!' +
' // return the complete list' +
' return databaseManager.getDataSetByQuery("example_data", "select firstname || ' ' || lastname, employeeid from employees", null, 100);' +
'} else if (displayValue != null) {' +
' // TYPE_AHEAD filter call, return a filtered list' +
' var args = [displayValue + "%", displayValue + "%"]' +
' return databaseManager.getDataSetByQuery("example_data", "select firstname || ' ' || lastname, employeeid from employees where firstname like ? or lastname like ?", args, 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];' +
' return databaseManager.getDataSetByQuery("example_data", "select firstname || ' ' || lastname, employeeid from employees where employeeid = ?", args, 1);' +
'}' +
'}');
var vlist = solutionModel.newValueList('vlist', JSValueList.CUSTOM_VALUES);
vlist.globalMethod = listProvider;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The name of the value list.
It is relevant when the "useTableFilter" property is set.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The name of the relation that is used for loading data from the database.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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');
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The name of the database server that is used for loading the values when
the value list has the type set to database values.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Sort options that are applied when the valuelist loads its data
from the database.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The name of the database table that is used for loading the values when
the value list has the type set to database values.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The type of the valuelist. Can be either custom values or database values.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {table}
{column:padding=0px|width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Method Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
Object[]
Unknown macro: {span}
getDisplayDataProviderIds
Unknown macro: {span}
()
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Returns an array of the dataproviders that will be used to display the valuelist value.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Object[] – An array of Strings representing the names of the display dataproviders.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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]);
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
Object[]
Unknown macro: {span}
getReturnDataProviderIds
Unknown macro: {span}
()
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Returns an array of the dataproviders that will be used to define the valuelist value that is saved.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Object[] – An array of Strings representing the names of the return dataprovider.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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]);
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Returns the UUID of the value list
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
var vlist = solutionModel.newValueList('options', JSValueList.CUSTOM_VALUES);
application.output(vlist.getUUID().toString());
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
void
Unknown macro: {span}
setDisplayDataProviderIds
Unknown macro: {span}
(dataprovider1, [dataprovider2], [dataprovider3])
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
dataprovider1 – The first display dataprovider.
[dataprovider2] – The second display dataprovider.
[dataprovider3] – The third display dataprovider.
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
void
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
void
Unknown macro: {span}
setReturnDataProviderIds
Unknown macro: {span}
(dataprovider1, [dataprovider2], [dataprovider3])
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
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.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Since
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Replace with version info
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {sub-section}
dataprovider1 – The first return dataprovider.
[dataprovider2] – The second return dataprovider.
[dataprovider3] – The third return dataprovider.
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
void
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
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';
Unknown macro: {tr}
Unknown macro: {td}
Overview
Content Tools
Activity