Servoy 5.2.x Documentation
Child pages
  • JSRelationItem
Skip to end of metadata
Go to start of metadata


Property Summery
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.

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', 'example_data', 'parent_table', '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', 'example_data', 'parent_table', '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', 'example_data', 'parent_table', '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 = '<';
  • No labels