Page History

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

id	description

HTML Table

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

sIndent

Get an existing calculation for the datasource node.

Table Row (tr)idtd

prsParametersdivclasssIndent{String} name - The name of the calculation Table Row (tr)idtdret
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 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
 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)idsIdentjavascriptlastDetailRowgetCalculationsnamegetCalculations()dessIndentGets all the calculations for the datasource node.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetDataSourcenamegetDataSource()dessIndentGet the data source for this node.retReturns
sIndent the dataSourceclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetMethodnamegetMethod(name)dessIndentGet an existing foundset method for the datasource node.prsParameters
sIndentnameThe name of the methodretReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetMethodsnamegetMethods()dessIndentGets all the foundset methods for the datasource node.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRownewCalculationnamenewCalculation(code)dessIndentCreates 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;prsParameters
sIndentcodeThe code of the calculation, this must be a full function declaration.ret Table Cell (td)
ReturnsdivsIndentclientsclasstd
Supported Clients
sIndentJSCalculation 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
 SpanSmartClient,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]);
}
idsIdentjavascriptlastDetailRownewCalculationnamenewCalculation(code, type) Table Row (tr)classdes Table Cell (td) DivsIndentCreates 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.tridtdprsParametersdivclasssIndent{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 methodtdretReturns DivclassJSMethod - sIndent Table Row (tr)
id prs
 Table Cell (td)Parameters
 Divclass sIndent
{String} name -  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.
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)tdretclassReturns DivsIndentBoolean -  Table Row (tr)id prs
 Table Cell (td)Parameters
 Divclass sIndent
{String} name -  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 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.
idSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowremoveMethodnameremoveMethod(name)dessIndentRemoves the foundset method specified by name.prsParameters
sIndentnamethe name of the method 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) 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]);
}
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 12

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)