JSCalculation

Property Summary

TypeNameSummary

The full source code of this method (including doc and function declaration)..

Get or set the sql type of this variable..

Methods Summary

TypeNameSummary

This method returns the name of the stored calculation..

Returns the UUID of the calculation..

Check a flag of the calculation..

Returns whether this calculation is a stored one or not..

Properties Details

code

The full source code of this method (including doc and function declaration).

Returns String

Sample

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
calc.code = "function myCalculation() { return 123; }";

variableType

Get or set the sql type of this variable. Type should be one of JSVariable.DATETIME, JSVariable.TEXT, JSVariable.NUMBER , JSVariable.INTEGER or JSVariable.MEDIA.

Returns Number

Sample

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").getCalculation("myCalculation");
calc.variableType = JSVariable.DATETIME;

Methods Details

getName()

This method returns the name of the stored calculation.

Returns String the name of the stored calculation

Sample

var calc = solutionModel.newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER, "db:/example_data/customers");
application.output(calc.getName());

getUUID()

Returns the UUID of the calculation.

Returns UUID

Sample

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
application.output(calc.getUUID().toString());

hasFlag(flag)

Check a flag of the calculation. The flags are a bit pattern consisting of 1 or more of the following bits:

  • JSColumn.UUID_COLUMN

Parameters Number flag ;

Returns Boolean boolean whether flag is set.

Sample

var datasourceNode = solutionModel.getDataSourceNode('db:/example_data/orders')
var calculation = datasourceNode.getCalculation('mycalculation')
if (calculation.hasFlag(JSColumn.UUID_COLUMN))
{
	 // calculation was typed as UUID
}

isStored()

Returns whether this calculation is a stored one or not.

Returns Boolean true if the calculation is stored, false otherwise

Sample

var calc = solutionModel.getDataSourceNode("db:/example_data/customers").newCalculation("function myCalculation() { return 123; }", JSVariable.INTEGER);
if (calc.isStored()) application.output("The calculation is stored");
else application.output("The calculation is not stored");

Last updated