Page History

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Summary

...

Table Cell (td)
String

...

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;2Return TypessWordListBLOCK

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Constants SummaryConstant for using literals in solution model in relations.

...

servoy sSummary

...

padding	0px
width	80px

...

Table Cell (td)
String

...

12%

30%

58%

height: 30px;

...

Table Head (th)

colspan	2

Property Summary

...

3

Property Summary

The name of the column from the destination table

...

that this relation item is based on.

...

Table Cell (td)
String

...

The operator that defines the relationship between the primary dataprovider

...

and the foreign column.

...

Table Cell (td)
String

...

The name of the column from the source table

...

that this relation item is based on.

...

Table Cell (td)
Object

...

Get the literal.

...

servoy sSummary

...

padding	0px
width	80px

...

Table Cell (td)
UUID

...

12%

30%

58%

height: 30px;

...

Table Head (th)

colspan	2

Method Summary

3

Methods Summary

Returns the comment of this component.

Returns the UUID of this component.

...

constant

...

servoy sDetail

...

padding	0px
width	100%

...

2100%

height:30px

...

colspan	1

...

2

Constants Details

...

LITERAL_PREFIX

...

name

...

LITERAL_PREFIX

...

des

...

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.

...

ret

...

Returns

...

sIndent

clients

...

Supported Clients

sIndent

...

id	sam

...

class	lastDetailRow

...

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;

...

class	lastDetailRow

...

id	function
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

...

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());

...

class	lastDetailRow

...

SmartClient,WebClient,NGClient

sam

Sample

...

class	sIndent

...

Code Block

language	javascript

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

...

class	lastDetailRow

...

id	property
class	servoy sDetail

...

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

...

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 = '<';

...

class	lastDetailRow

...

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 = '<';

...

class	lastDetailRow

...

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 = '<';

sIdent

javascript

lastDetailRow

propertyservoy sDetail2100%height:30px2Property DetailsforeignColumnNamename

foreignColumnName

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

operator

name

operator

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

primaryDataProviderID

name

primaryDataProviderID

des

sIndent

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

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

primaryLiteral

name

primaryLiteral

des

sIndent

Get the literal.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

functionservoy sDetail2100%height:30px2Methods DetailsgetCommentname

getComment()

des

sIndent

Returns the comment of this component.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getUUID

name

getUUID()

des

sIndent

Returns the UUID of this component.

ret

Returns

sIndent

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 30

New Version Current

Key

LITERAL_PREFIX

des

primaryLiteral

getUUID

foreignColumnName

operator

primaryDataProviderID

foreignColumnName

operator

primaryDataProviderID

primaryLiteral

getComment()

getUUID()