Page History

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

...

Table Cell (td)
JSCalculation

...

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.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Divcache

styleindex	display:none

...

id	description

...

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryGet an existing calculation for the datasource node.

...

Table Cell (td)
JSCalculation[]

...

Gets all the calculations for the datasource node.

...

Table Cell (td)
String

...

Get the data source for this node.

...

Table Cell (td)
JSMethod

Get an existing foundset method for the datasource node.

...

Table Cell (td)
JSMethod[]

...

Gets all the foundset methods for the datasource node.

...

Table Cell (td)
JSCalculation

...

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 Cell (td)
JSCalculation

...

Table Cell (td)
JSMethod

...

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.

...

Creates a new foundset method with the specified code.

...

Table Cell (td)
Boolean

...

Removes the calculation specified by name.

...

Table Cell (td)
Boolean

Removes the foundset method specified by name.

...

function

...

servoy sDetail

...

padding	0px
width	100%

...

2100%

height:30px

...

Table Head (th)

colspan	1

Method Details

...

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]);
}

...

class	lastDetailRow

...

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]);
}

...

class	lastDetailRow

...

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();

...

class	lastDetailRow

...

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())

...

class	lastDetailRow

...

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())

...

class	lastDetailRow

...

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;

...

id	prs

...

class	sIndent

...

2

Methods Details

getCalculation

name

getCalculation(name)

des

sIndent

Get an existing calculation for the datasource node.

prs

Parameters

sIndent

name

The name of the calculation

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getCalculations

name

getCalculations()

des

sIndent

Gets all the calculations for the datasource node.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getDataSource

name

getDataSource()

des

sIndent

Get the data source for this node.

ret

Returns

sIndent

the dataSource

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getMethod

name

getMethod(name)

des

sIndent

Get an existing foundset method for the datasource node.

prs

Parameters

sIndent

name

The name of the method

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getMethods

name

getMethods()

des

sIndent

Gets all the foundset methods for the datasource node.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

newCalculation

name

newCalculation(code)

des

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;

prs

Parameters

sIndent

code

The code of the calculation, this must be a full function declaration.

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

id	sam

...

class	lastDetailRow

...

id	newCalculation-String_Number

Table Row (tr)

id	name

Table Cell (td)
newCalculation

...

id	sig

...

Span

style	margin-right: 5px;

JSCalculation

Span

style	font-weight: bold;

newCalculation

...

SmartClient,WebClient,NGClient

sam

Sample

...

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]);
}

sIdent

javascript

lastDetailRow

newCalculation

name

newCalculation(code, type)

...

des

...

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.

...

prs

...

Parameters

...

sIndent

...

code

...

The code of the calculation, this must be a full function declaration.

...

type

...

The type of the calculation, one of the JSVariable types.

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

id	sam

...

class	lastDetailRow

...

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.

...

id	prs

...

class	sIndent

...

SmartClient,WebClient,NGClient

sam

Sample

...

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]);
}

...

sIdent

javascript

lastDetailRow

newMethod

name

newMethod(code)

des

sIndent

Creates a new foundset method with the specified code.

prs

Parameters

sIndent

code

the specified code for the foundset method

...

ret

...

Returns

...

sIndent

...

a JSMethod object

clients

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

...

class	lastDetailRow

...

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.

...

id	prs

...

class	sIndent

...

Sample

...

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())

...

sIdent

javascript

lastDetailRow

removeCalculation

name

removeCalculation(name)

des

sIndent

Removes the calculation specified by name.

prs

Parameters

sIndent

name

the name of the calculation to be removed

...

ret

...

Returns

...

sIndent

...

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.

...

id	prs

...

class	sIndent

...

true if the removal was successful, false otherwise

clients

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]);
}

...

class	lastDetailRow

...

id	removeMethod-String

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

removeMethod

name

removeMethod(name)

des

sIndent

Removes the foundset method specified by name.

prs

Parameters

sIndent

name

the name of the method to be removed

...

ret

...

Returns

...

sIndent

...

true if the removal was successful, false otherwise

clients

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

...

class	lastDetailRow

...

Sample

...

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]);
}

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 11

New Version Current

Key

getCalculation

getCalculations

getDataSource

getMethod

getMethods

newCalculation

getCalculation(name)

getCalculations()

getDataSource()

getMethod(name)

getMethods()

newCalculation(code)

newCalculation

newCalculation(code, type)

newMethod

newMethod(code)

removeCalculation

removeCalculation(name)

removeMethod

removeMethod(name)