Servoy 2020 Documentation
Child pages
  • JSRelationItem
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 33 Next »



Constants Summary
String LITERAL_PREFIX
Constant for using literals in solution model in relations.



Property Summary
String foreignColumnName
The name of the column from the destination table
that this relation item is based on.
String operator
The operator that defines the relationship between the primary dataprovider
and the foreign column.
String primaryDataProviderID
The name of the column from the source table
that this relation item is based on.
Object primaryLiteral
Get the literal.



Method Summary
UUID getUUID()
Returns the UUID of this component.



Constants Details

LITERAL_PREFIX
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.

Returns

String

Sample

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



Property Details

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

Returns

String

Sample

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

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

Returns

String

Sample

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

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

Returns

String

Sample

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

primaryLiteral
Get the literal.

Returns

Object

Sample

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;
 



Method Details

getUUID
UUID getUUID ()
Returns the UUID of this component.

Returns

UUID

Sample

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



  • No labels