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

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

idclassservoy 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 comment of this component.

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

retReturnsdivsIndentclientsclasstd
Supported Clients
sIndentString Table Row (tr)id sam
SmartClient,WebClient,NGClientsamSample 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
 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
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
 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
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) sIdentjavascriptlastDetailRow
propertyservoy sDetail2100%height:30px2Property DetailsforeignColumnNamename
foreignColumnName
dessIndentThe name of the column from the destination table
that this relation item is based on.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowoperatornameoperatordessIndentThe operator that defines the relationship between the primary dataprovider
and the foreign column.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowprimaryDataProviderIDnameprimaryDataProviderIDdessIndentThe name of the column from the source table
that this relation item is based on.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowprimaryLiteralnameprimaryLiteraldessIndentGet the literal.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow
functionservoy sDetail2100%height:30px2Methods DetailsgetCommentname
getComment()
dessIndentReturns the comment of this component.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetUUIDnamegetUUID()dessIndentReturns the UUID of this component.retReturns
sIndentclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 33

New Version Current

Key

LITERAL_PREFIX

foreignColumnName

operator

primaryDataProviderID

primaryLiteral

getUUID

foreignColumnName

operator

primaryDataProviderID

primaryLiteral

getComment()

getUUID()