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

...

id

HTML Table
Removes the foundset method specified by name.

...

servoy sDetail

function

class

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style

2100%

height:30px

;

Table Head (th)

colspan	1

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 – Table Row (tr)id

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

Table Cell (td)

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

JSCalculation Table Row (tr)

id	sam

Span

SmartClient,WebClient,NGClient

sam

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

sIdent

javascript

lastDetailRow

newCalculation

name

newCalculation(code, type)

tr

idclass

des

Table Cell (td) Div

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

prsParameters
 DivclasssIndent{String} code – The code of the calculation, this must be a full function declaration.
 {Number} type –  Table Row (tr)idThe type of the calculation, one of the JSVariable types.tdret
ReturnsdivsIndentclientsclasstd
Supported Clients
sIndentJSCalculation Table Row (tr)id sam
 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
 Divclass sIndent
{String} code – SmartClient,WebClient,NGClientsamSample 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)idsIdentjavascriptlastDetailRownewMethodnamenewMethod(code)dessIndentCreates a new foundset method with the specified code.prsParameters
sIndentcodethe specified code for the foundset methodtdretReturns
 DivclassJSMethod – sIndent a JSMethod objectclients
 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
 Divclass sIndent
{String} name – idSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowremoveCalculationnameremoveCalculation(name)dessIndentRemoves the calculation specified by name.prsParameters
sIndentnamethe name of the calculation to be removed Table Row (tr)ret Table Cell (td)
Returns
divclasssIndentBoolean – id true if the removal was successful, false otherwiseclients
 Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td) 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
 Divclass sIndent
{String} name – 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]);
}
idsIdentjavascriptlastDetailRowremoveMethodnameremoveMethod(name)dessIndentRemoves the foundset method specified by name.prsParameters
sIndentnamethe name of the method to be removed Table Row (tr)ret Table Cell (td)
Returns
divclasssIndentBoolean –  Table Row (tr)
class lastDetailRow
td true if the removal was successful, false otherwiseclients
 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]);
}
Supported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 10

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)