Page History

Divcache

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)

styleindex	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.

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

id

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryGet 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()

Table Cell (td)
JSMethod

Table Cell (td)getMethod(name)

Get the data source for this node.

Table Row (tr)

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)

Table Cell (td)
JSMethod

Table Cell (td)newMethod(code)

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)

Creates a new foundset method with the specified code.

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)removeCalculation(name)

Table Cell (td)
Boolean

Table Cell (td)removeMethod(name)

Removes the calculation specified by name.

Table Row (tr)

Removes the foundset method specified by name.

HTML Table

functionclass Colgroup Tag Colcolspanservoy sDetail2width100%

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

Spanid

2

Methods Details

getCalculation

name

getCalculation(name)

Table Row (tr)

des

Table Cell (td) Divclassid

sIndent

Get an existing calculation for the datasource node.

Table Row (tr)td

prs

Parameters

Divclass

sIndent{String} name - The name of the calculation Table Row (tr)idret

Table Cell (td)

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

JSCalculation Table Row (tr)

id	sam

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 -

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

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.

td

ret

Returns

div

sIndent

clients

classtd

Supported Clients

sIndent

JSCalculation Table Row (tr)

id	sam

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

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

id

sIdent

javascript

lastDetailRow

newCalculation

name

newCalculation(code, type)

Table Row (tr)class

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

prs Table Cell (td)
Parameters 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.ret
 Table Cell (td)
ReturnsdivsIndentclientsclassid
Supported Clients
sIndentJSCalculation Table Row (tr)SmartClient,WebClient,NGClientsam Table Cell (td)
 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 - 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)idsIdentjavascriptlastDetailRownewMethodnamenewMethod(code)dessIndentCreates a new foundset method with the specified code.prsParameters
sIndentcodethe specified code for the foundset methodret Table Cell (td)class
Returns DivJSMethod - sIndentid a JSMethod objectclients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td)
 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 - 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())
idsIdentjavascriptlastDetailRowremoveCalculationnameremoveCalculation(name)dessIndentRemoves the calculation specified by name.prsParameters
sIndentnamethe name of the calculation to be removed Table Row (tr)tdretclassReturns DivsIndentBoolean - 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)tdretReturns DivclasssIndentBoolean -  Table Row (tr)
class lastDetailRow
 Table Cell (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 14

New Version Current

Key

getCalculation

getCalculation(name)

getCalculations

getDataSource

getMethod

getMethods

newCalculation

getCalculations()

getDataSource()

getMethod(name)

getMethods()

newCalculation(code)

newCalculation

newCalculation(code, type)

newMethod

newMethod(code)

removeCalculation

removeCalculation(name)

removeMethod

removeMethod(name)