Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#LITERALLITERAL_PREFIX Constant for using literals in solution model in relations.

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

tbody

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#foreignColumnName foreignColumnName The name of the column from the destination table that this relation item is based on.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#operator operator The operator that defines the relationship between the primary dataprovider and the foreign column.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#primaryDataProviderID primaryDataProviderID The name of the column from the source table that this relation item is based on.

Table Row (tr)

Table Cell (td)
Object

Table Cell (td)
primaryLiteral Get the literal.

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

tbody

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Row (tr)

Table Cell (td)
UUID

Table Cell (td)
#getUUID getUUID() Returns the UUID of this component.

HTML Table

id	constant
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Constants Details

Table Body (tbody)

id	LITERAL_PREFIX

Table Row (tr)

id	name

Table Cell (td)
LITERAL_PREFIX

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant for using literals in solution model in relations.
Strings must be passed as quoted value to make a distinction between string '5' and number 5.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript


relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'mytextfield');

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

Table Body (tbody)

id	foreignColumnName

Table Row (tr)

id	name

Table Cell (td)
foreignColumnName

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

The name of the column from the destination table
that this relation item is based on.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	operator

Table Row (tr)

id	name

Table Cell (td)
operator

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

The operator that defines the relationship between the primary dataprovider
and the foreign column.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	primaryDataProviderID

Table Row (tr)

id	name

Table Cell (td)
primaryDataProviderID

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

The name of the column from the source table
that this relation item is based on.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	primaryLiteral

Table Row (tr)

id	name

Table Cell (td)
primaryLiteral

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Get the literal.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Object

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'myTextField');
criteria.primaryLiteral = 'literal_text';
//criteria.primaryLiteral = number;
var primaryLiteral = criteria.primaryLiteral;

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	getUUID

Table Row (tr)

id	name

Table Cell (td)
getUUID

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

UUID

Span

style	font-weight: bold;

getUUID

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the UUID of this component.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

UUID

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var button_uuid = solutionModel.getForm("my_form").getButton("my_button").getUUID();
application.output(button_uuid.toString());

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 29

New Version 30

Key

LITERAL_PREFIX

foreignColumnName

operator

primaryDataProviderID

primaryLiteral

getUUID