Page History

Div

style	display: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.

Div

id	description

HTML Table

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
JSCalculation

Table Cell (td)
getCalculation(name) Get an existing calculation for the datasource node.

Table Row (tr)

Table Cell (td)
JSCalculation[]

Table Cell (td)
getCalculations() Gets all the calculations for the datasource node.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
getDataSource() Get the data source for this node.

Table Row (tr)

Table Cell (td)
JSMethod

Table Cell (td)
getMethod(name) Get an existing foundset method for the datasource node.

Table Row (tr)

Table Cell (td)
JSMethod[]

Table Cell (td)
getMethods() Gets all the foundset methods for the datasource node.

Table Row (tr)

Table Cell (td)
JSCalculation

Table Cell (td)
newCalculation(code) Creates a new calculation for the given code, the type will be the column where it could be build on (if name is a column name), else it will default to JSVariable.

Table Row (tr)

Table Cell (td)
JSCalculation

Table Cell (td)
newCalculation(code, type) Creates a new calculation for the given code and the type, if it builds on a column (name is a column name) then type will be ignored.

Table Row (tr)

Table Cell (td)
JSMethod

Table Cell (td)
newMethod(code) Creates a new foundset method with the specified code.

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
removeCalculation(name) Removes the calculation specified by name.

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
removeMethod(name) Removes the foundset method specified by name.

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Details

Table Body (tbody)

id	getCalculation-String

Table Row (tr)

id	name

Table Cell (td)
getCalculation

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSCalculation

Span

style	font-weight: bold;

getCalculation

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get an existing calculation for the datasource node.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name - The name of the calculation

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSCalculation

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
var calc2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation2() { return '20'; }");
var calc3 = solutionModel.getDataSourceNode("db:/example_data/employees").newCalculation("function myCalculation3() { return 'Hello World!'; }",	JSVariable.TEXT);

var c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
application.output("Name: " + c.getName() + ", Stored: " + c.isStored());

var allCalcs = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculations();
for (var i = 0; i < allCalcs.length; i++) {
	application.output(allCalcs[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getCalculations

Table Row (tr)

id	name

Table Cell (td)
getCalculations

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSCalculation[]

Span

style	font-weight: bold;

getCalculations

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Gets all the calculations for the datasource node.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSCalculation[]

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
var calc2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation2() { return '20'; }");
var calc3 = solutionModel.getDataSourceNode("db:/example_data/employees").newCalculation("function myCalculation3() { return 'Hello World!'; }",	JSVariable.TEXT);

var c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
application.output("Name: " + c.getName() + ", Stored: " + c.isStored());

var allCalcs = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculations();
for (var i = 0; i < allCalcs.length; i++) {
	application.output(allCalcs[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getDataSource

Table Row (tr)

id	name

Table Cell (td)
getDataSource

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getDataSource

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the data source for this node.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - the dataSource

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var nodeDataSource = solutionModel.getDataSourceNode("db:/example_data/customers").getDataSource();

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getMethod-String

Table Row (tr)

id	name

Table Cell (td)
getMethod

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSMethod

Span

style	font-weight: bold;

getMethod

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get an existing foundset method for the datasource node.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name - The name of the method

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSMethod

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var method = solutionModel.getDataSourceNode("db:/example_data/orders").newMethod("function doubleSize() { return 2*getSize(); }");

application.output('Doubled orders for this customer: '+customers_to_orders.doubleSize())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getMethods

Table Row (tr)

id	name

Table Cell (td)
getMethods

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSMethod[]

Span

style	font-weight: bold;

getMethods

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Gets all the foundset methods for the datasource node.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSMethod[]

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var method = solutionModel.getDataSourceNode("db:/example_data/orders").newMethod("function doubleSize() { return 2*getSize(); }");

application.output('Doubled orders for this customer: '+customers_to_orders.doubleSize())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	newCalculation-String

Table Row (tr)

id	name

Table Cell (td)
newCalculation

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSCalculation

Span

style	font-weight: bold;

newCalculation

Span
(code)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Creates a new calculation for the given code, the type will be the column where it could be build on (if name is a column name),
else it will default to JSVariable.TEXT;

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} code - The code of the calculation, this must be a full function declaration.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSCalculation

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
var calc2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation2() { return '20'; }");
var calc3 = solutionModel.getDataSourceNode("db:/example_data/employees").newCalculation("function myCalculation3() { return 'Hello World!'; }",	JSVariable.TEXT);

var c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
application.output("Name: " + c.getName() + ", Stored: " + c.isStored());

var allCalcs = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculations();
for (var i = 0; i < allCalcs.length; i++) {
	application.output(allCalcs[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	newCalculation-String_Number

Table Row (tr)

id	name

Table Cell (td)
newCalculation

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSCalculation

Span

style	font-weight: bold;

newCalculation

Span
(code, type)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Creates a new calculation for the given code and the type, if it builds on a column (name is a column name) then type will be ignored.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} code - The code of the calculation, this must be a full function declaration.
{Number} type - The type of the calculation, one of the JSVariable types.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSCalculation

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
var calc2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation2() { return '20'; }");
var calc3 = solutionModel.getDataSourceNode("db:/example_data/employees").newCalculation("function myCalculation3() { return 'Hello World!'; }",	JSVariable.TEXT);

var c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
application.output("Name: " + c.getName() + ", Stored: " + c.isStored());

var allCalcs = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculations();
for (var i = 0; i < allCalcs.length; i++) {
	application.output(allCalcs[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	newMethod-String

Table Row (tr)

id	name

Table Cell (td)
newMethod

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSMethod

Span

style	font-weight: bold;

newMethod

Span
(code)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Creates a new foundset method with the specified code.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} code - the specified code for the foundset method

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

JSMethod - a JSMethod object

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var method = solutionModel.getDataSourceNode("db:/example_data/orders").newMethod("function doubleSize() { return 2*getSize(); }");

application.output('Doubled orders for this customer: '+customers_to_orders.doubleSize())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	removeCalculation-String

Table Row (tr)

id	name

Table Cell (td)
removeCalculation

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

removeCalculation

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Removes the calculation specified by name.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name - the name of the calculation to be removed

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean - true if the removal was successful, false otherwise

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var calc1 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation1() { return 123; }", JSVariable.INTEGER);
var calc2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation2() { return '20'; }");

var c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation1");
application.output("Name: " + c.getName() + ", Stored: " + c.isStored());

solutionModel.getDataSourceNode("db:/example_data/customers").removeCalculation("myCalculation1");
c = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation1");
if (c != null) {
	application.output("myCalculation could not be removed.");
}

var allCalcs = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculations();
for (var i = 0; i < allCalcs.length; i++) {
	application.output(allCalcs[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	removeMethod-String

Table Row (tr)

id	name

Table Cell (td)
removeMethod

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

removeMethod

Span
(name)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Removes the foundset method specified by name.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{String} name - the name of the method to be removed

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean - true if the removal was successful, false otherwise

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var method1 = solutionModel.getDataSourceNode("db:/example_data/customers").newMethod("function myFoundsetMethod1() { return 123; }");
var method2 = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myFoundsetMethod2() { return '20'; }");

var m = solutionModel.getDataSourceNode("db:/example_data/customers").getMethod("myFoundsetMethod1");
application.output("Name: " + m.getName());

solutionModel.getDataSourceNode("db:/example_data/customers").removeMethod("myFoundsetMethod1");
m = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myFoundsetMethod1");
if (m != null) { application.output("myFoundsetMethod1 could not be removed."); }

var allMethods = solutionModel.getDataSourceNode("db:/example_data/customers").getMethod();
for (var i = 0; i < allMethods; i++)
{
	application.output(allMethods[i]);
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 13

New Version Current

Key

getCalculation

getCalculations

getDataSource

getMethod

getMethods

newCalculation

newCalculation

newMethod

removeCalculation

removeMethod