allowCreationRelatedRecords |
|
Flag that tells if related records can be created through this relation.
The default value of this flag is "false". |
|
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowCreationRelatedRecords = true;
|
|
|
|
|
allowParentDeleteWhenHavingRelatedRecords |
|
Flag that tells if the parent record can be deleted while it has related records.
The default value of this flag is "true". |
|
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowParentDeleteWhenHavingRelatedRecords = false;
|
|
|
|
|
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". |
|
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.deleteRelatedRecords = true;
|
|
|
|
|
Qualified name of the foreign data source. Contains both the name of the foreign
server and the name of the foreign table. |
|
Sample
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';
|
|
|
|
|
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, ...". |
|
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.initialSort = 'another_child_table_text asc';
|
|
|
|
|
The join type that is performed between the primary table and the foreign table.
Can be "inner join" or "left outer join". |
|
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
|
|
|
|
|
The name of the relation. |
|
Sample
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;
|
|
|
|
|
Qualified name of the primary data source. Contains both the name of the primary server
and the name of the primary table. |
|
Sample
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';
|
|
|
|
|
|