Unknown macro: {sub-section}
For more information see [Relations]
Unknown macro: {table}
Unknown macro: {tr}
Unknown macro: {th}
Return Types
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
Unknown macro: {table}
{column:width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Constants Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
INNER_JOIN
Constant for set/get the joinType of a JSRelation.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
LEFT_OUTER_JOIN
Constant for set/get the joinType of a JSRelation.
Unknown macro: {table}
{column:width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Property Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
allowCreationRelatedRecords
Flag that tells if related records can be created through this relation.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
allowParentDeleteWhenHavingRelatedRecords
Flag that tells if the parent record can be deleted while it has related records.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
deleteRelatedRecords
Flag that tells if related records should be deleted or not when a parent record is deleted.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
foreignDataSource
Qualified name of the foreign data source.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
initialSort
A String which specified a set of sort options for the initial sorting of data
retrieved through this relation.
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
primaryDataSource
Qualified name of the primary data source.
Unknown macro: {table}
{column:width=80px}{column}{column}{column}
Unknown macro: {tr}
Unknown macro: {th}
Method Summary
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
getRelationItems()
Returns an array of JSRelationItem objects representing the relation criteria defined for this relation.
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {td}
newRelationItem(dataprovider, operator, foreinColumnName)
Creates a new relation item for this relation.
Unknown macro: {table}
{column:width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Constants Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Constant for set/get the joinType of a JSRelation. It is also used in solutionModel.newRelation(...).
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Constant for set/get the joinType of a JSRelation. It is also used in solutionModel.newRelation(...).
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {table}
{column:width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Property Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Flag that tells if related records can be created through this relation.
The default value of this flag is "false".
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowCreationRelatedRecords = true;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Flag that tells if the parent record can be deleted while it has related records.
The default value of this flag is "true".
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowParentDeleteWhenHavingRelatedRecords = false;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Flag that tells if related records should be deleted or not when a parent record is deleted.
The default value of this flag is "false".
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.deleteRelatedRecords = true;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Qualified name of the foreign data source. Contains both the name of the foreign
server and the name of the foreign table.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryDataSource = 'db:/user_data/another_parent_table';
relation.foreignDataSource = 'db:/user_data/another_child_table';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
A String which specified a set of sort options for the initial sorting of data
retrieved through this relation.
Has the form "column_name asc, another_column_name desc, ...".
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.initialSort = 'another_child_table_text asc';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The join type that is performed between the primary table and the foreign table.
Can be "inner join" or "left outer join".
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
The name of the relation.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.name = 'anotherName';
var firstTab = tabs.newTab('firstTab', 'Child Form', childForm, relation);
firstTab.relationName = relation.name;
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Qualified name of the primary data source. Contains both the name of the primary server
and the name of the primary table.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryDataSource = 'db:/user_data/another_parent_table';
relation.foreignDataSource = 'db:/user_data/another_child_table';
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {table}
{column:width=100%}{column}
Unknown macro: {tr}
Unknown macro: {th}
Method Details
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
Unknown macro: {span}
getRelationItems
Unknown macro: {span}
()
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Returns an array of JSRelationItem objects representing the relation criteria defined for this relation.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
JSRelationItem[] – An array of JSRelationItem instances representing the relation criteria of this relation.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var criteria = relation.getRelationItems();
for (var i=0; i<criteria.length; i++)
{
var item = criteria[i];
application.output('relation item no. ' + i);
application.output('primary column: ' + item.primaryDataProviderID);
application.output('operator: ' + item.operator);
application.output('foreign column: ' + item.foreignColumnName);
}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {tbody}
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {span}
Unknown macro: {span}
newRelationItem
Unknown macro: {span}
(dataprovider, operator, foreinColumnName)
Unknown macro: {tr}
Unknown macro: {td}
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Creates a new relation item for this relation. The primary dataprovider, the foreign data provider
and one relation operators (like '=' '!=' '>' '<') must be provided.
Unknown macro: {tr}
Unknown macro: {td}
Parameters
Unknown macro: {sub-section}
Unknown macro: {div}
Unknown macro: {sub-section}
dataprovider – The name of the primary dataprovider.
operator – The operator used to relate the primary and the foreign dataproviders.
foreinColumnName – The name of the foreign dataprovider.
Unknown macro: {tr}
Unknown macro: {td}
Returns
Unknown macro: {sub-section}
Unknown macro: {sub-section}
JSRelationItem – A JSRelationItem instance representing the newly added relation item.
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
Also see
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {builder-show}
Unknown macro: {tr}
Unknown macro: {td}
External links
Unknown macro: {sub-section}
Unknown macro: {sub-section}
Unknown macro: {tr}
Unknown macro: {td}
Sample
Unknown macro: {sub-section}
Unknown macro: {sub-section}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.newRelationItem('another_parent_table_id', '=', 'another_child_table_parent_id');
Unknown macro: {tr}
Unknown macro: {td}
Overview
Content Tools
Activity