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

Constants Summary

Table Row (tr)

Table Cell (td)
String

Table Cell (td)LITERAL_PREFIX

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

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

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

classservoy sSummaryidclass

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style Table Row (tr)

Table Cell (td)
String

Table Cell (td)foreignColumnName

servoy sSummary

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 Row (tr)

Table Cell (td)
String

Table Cell (td)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

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

Colgroup Tag

Col

width	80px

Col

Table Head (thead) Table Row (tr)style

servoy sSummary

id Table Row (tr)

Table Cell (td)
UUID

Table Cell (td)getUUID()

12%

30%

58%

height: 30px;

Table Head (th)

colspan	2

Method Summary

3

Methods Summary

Returns the UUID of this component.

HTML Table

constantclass Colgroup Tag Colcolspanservoy sDetail2width100%

Col

Table Head (thead) Table Row (tr)style

height:30px

; Table Head (th)colspan

2

Constants Details

Table Body (tbody)idid

LITERAL_PREFIX

Table Row (tr)

name

td

LITERAL_PREFIX

Table Row (tr)id

des

Table Cell (td) Divclass

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

sIndent

clients

classid

Supported Clients

sIndent

String Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

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

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

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.

Table Row (tr)id

ret

Table Cell (td)

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

String Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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

operator

name

operator

des

sIndent

The operator that defines the relationship between the primary dataprovider

and the foreign column.

Table Row (tr)idtd

ret

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

String Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td)

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

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

primaryDataProviderID

name

primaryDataProviderID

des

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

sIndent

clients

classtd

Supported Clients

sIndent

String Table Row (tr)

id	sam

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

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

SmartClient,WebClient,NGClient

sam

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

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 DetailsgetUUIDname

getUUID()

des

sIndent

Returns the UUID of this component.

Table Row (tr)id

ret

Table Cell (td)

Returns

div

sIndent

clients

classid

Supported Clients

sIndent

UUID Table Row (tr)

SmartClient,WebClient,NGClient

sam

Table Cell (td) Table Row (tr)

class	lastDetailRow

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

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 33

New Version 34

Key

LITERAL_PREFIX

foreignColumnName

foreignColumnName

operator

operator

primaryDataProviderID

primaryDataProviderID

getUUID

primaryLiteral

primaryLiteral

getUUID()