Constant for the joinType of a JSRelation. |
|
Constant for the joinType of a JSRelation. |
|
Constant for the joinType of a JSRelation. |
|
Constant for the joinType of a JSRelation. |
|
|
Flag that tells if related records can be created through this relation. |
|
Flag that tells if the parent record can be deleted while it has related records. |
|
Flag that tells if related records should be deleted or not when a parent record is deleted. |
|
Qualified name of the foreign data source. |
|
A String which specified a set of sort options for the initial sorting of data
retrieved through this relation. |
|
The join type that is performed between the primary table and the foreign table. |
|
The name of the relation. |
|
Qualified name of the primary data source. |
|
|
Returns an array of JSRelationItem objects representing the relation criteria defined for this relation. |
|
Returns the UUID of the relation object |
|
Creates a new relation item for this relation. |
|
Removes the desired relation item from the specified relation. |
|
|
Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...). |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN; |
|
|
|
|
Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...). |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN; |
|
|
|
|
Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...). |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN; |
|
|
|
|
Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...). |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN; |
|
|
|
|
|
allowCreationRelatedRecords |
|
Flag that tells if related records can be created through this relation.
The default value of this flag is "false". |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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". |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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". |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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, ...". |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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". |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN; |
|
|
|
|
The name of the relation. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.primaryDataSource = 'db:/user_data/another_parent_table';
relation.foreignDataSource = 'db:/user_data/another_child_table'; |
|
|
|
|
|
Returns an array of JSRelationItem objects representing the relation criteria defined for this relation. |
|
|
Returns Array An array of JSRelationItem instances representing the relation criteria of this relation. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample 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);
} |
|
|
|
|
Returns the UUID of the relation object |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
application.output(relation.getUUID().toString()) |
|
|
|
|
newRelationItem(dataprovider, operator, foreinColumnName) |
|
Creates a new relation item for this relation. The primary dataprovider, the foreign data provider
and one relation operators (like '=' '!=' '>' '<') must be provided. |
|
|
Parameters The name of the primary dataprovider. |
|
The operator used to relate the primary and the foreign dataproviders. |
|
The name of the foreign dataprovider. |
|
|
|
|
Returns JSRelationItem A JSRelationItem instance representing the newly added relation item. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.newRelationItem('another_parent_table_id', '=', 'another_child_table_parent_id');
// for literals use a prefix
relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'mytextfield'); |
|
|
|
|
removeRelationItem(primaryDataProviderID, operator, foreignColumnName) |
|
Removes the desired relation item from the specified relation. |
|
|
Parameters the primary data provider (column) name |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('myRelation', 'db:/myServer/parentTable', 'db:/myServer/childTable', JSRelation.INNER_JOIN);
relation.newRelationItem('someColumn1', '=', 'someColumn2');
relation.newRelationItem('anotherColumn', '=', 'someOtherColumn');
relation.removeRelationItem('someColumn1', '=', 'someColumn2');
var criteria = relation.getRelationItems();
for (var i = 0; i < criteria.length; i++) {
var item = criteria[i];
application.output('primary column: ' + item.primaryDataProviderID);
application.output('operator: ' + item.operator);
application.output('foreign column: ' + item.foreignColumnName);
} |
|
|
|
|
|
|