Page History
Divcache | ||
---|---|---|
| DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
Div | ||
---|---|---|
| ||
For more information see Relations |
...
padding | 0px |
---|---|
width | 80px |
...
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
Table Cell (td) |
---|
Number |
...
| |||||||||||||
...
Table Cell (td) |
---|
Number |
...
...
Table Cell (td) |
---|
Number |
...
...
Table Cell (td) |
---|
Number |
...
...
padding | 0px |
---|---|
width | 80px |
...
...
Table Head (th) | ||
---|---|---|
| ||
Property Summary |
...
Table Cell (td) |
---|
Boolean |
...
...
Table Cell (td) |
---|
Boolean |
...
...
Table Cell (td) |
---|
Boolean |
...
Table Cell (td) |
---|
String |
...
...
...
Table Cell (td) |
---|
String |
...
...
Table Cell (td) |
---|
Number |
...
...
...
...
Table Cell (td) |
---|
String |
...
...
Table Cell (td) |
---|
String |
...
...
padding | 0px |
---|---|
width | 80px |
...
...
Table Head (th) | ||
---|---|---|
| ||
Method Summary |
...
Table Cell (td) |
---|
JSRelationItem[] |
...
Table Cell (td) |
---|
UUID |
...
...
...
Table Cell (td) |
---|
JSRelationItem |
...
...
...
...
...
...
...
...
padding | 0px |
---|---|
width | 100% |
...
...
colspan | 1 |
---|
...
...
...
...
FULL_JOIN |
...
...
Constant for the joinType of a |
...
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | INNER_JOIN |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
...
id | des |
---|
...
class | sIndent |
---|
...
JSRelation. It is also used in solutionModel.newRelation(...). Returns Supported Clients Sample INNER_JOINConstant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...) |
...
. |
...
...
Returns |
...
...
Supported Clients |
...
id | sam |
---|
...
class | lastDetailRow |
---|
...
Sample |
...
class | sIndent |
---|
...
Code Block | ||
---|---|---|
| ||
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid)) |
...
...
LEFT_OUTER_JOIN |
...
...
Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...) |
...
. |
...
...
Returns |
...
...
Supported Clients |
...
id | sam |
---|
...
class | lastDetailRow |
---|
...
Sample |
...
class | sIndent |
---|
...
Code Block | ||
---|---|---|
| ||
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
/** @type {QBJoin<db:/example_data/order_details>} */
var join = query.joins.add('db:/example_data/order_details', JSRelation.INNER_JOIN, 'odetail')
join.on.add(join.columns.orderid.eq(query.columns.orderid)) |
...
...
RIGHT_OUTER_JOIN |
...
...
Constant for the joinType of a |
...
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | property |
---|---|
class | servoy sDetail |
...
padding | 0px |
---|---|
width | 100% |
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
id | allowCreationRelatedRecords |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | allowParentDeleteWhenHavingRelatedRecords |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | deleteRelatedRecords |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | foreignDataSource |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | initialSort |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | joinType |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | name |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | primaryDataSource |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | function |
---|---|
class | servoy sDetail |
...
padding | 0px |
---|---|
width | 100% |
Table Row (tr) | |||||
---|---|---|---|---|---|
| |||||
|
...
id | getRelationItems |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
...
id | ret |
---|
...
class | sIndent |
---|
...
id | sig |
---|
...
Span | ||
---|---|---|
| ||
JSRelationItem |
Span | ||
---|---|---|
| ||
newRelationItem |
...
JSRelation. It is also used in solutionModel.newRelation(...). Returns Supported Clients Sample allowCreationRelatedRecordsFlag that tells if related records can be created through this relation.
The default value of this flag is "false". Returns Supported Clients Sample allowParentDeleteWhenHavingRelatedRecordsFlag that tells if the parent record can be deleted while it has related records.
The default value of this flag is "true". Returns Supported Clients Sample deleteRelatedRecordsFlag that tells if related records should be deleted or not when a parent record is deleted.
The default value of this flag is "false". Returns Supported Clients Sample foreignDataSourceQualified name of the foreign data source. Contains both the name of the foreign
server and the name of the foreign table. Returns Supported Clients Sample initialSortA 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, ...". Returns Supported Clients Sample joinTypeThe join type that is performed between the primary table and the foreign table.
Can be "inner join" or "left outer join". Returns Supported Clients Sample nameThe name of the relation. Returns Supported Clients Sample primaryDataSourceQualified name of the primary data source. Contains both the name of the primary server
and the name of the primary table. Returns Supported Clients Sample getRelationItems()Returns an array of JSRelationItem objects representing the relation criteria defined for this relation. Returns |
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | getUUID |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
id | newRelationItem-String_String_String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Supported Clients Sample getUUID()Returns the UUID of the relation object Returns Supported Clients Sample 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 |
...
...
...
...
...
...
...
...
...
Returns |
...
...
...
Supported Clients |
...
class | lastDetailRow |
---|
...
id | removeRelationItem-String_String_String |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
...
id | sig |
---|
...
Span | ||
---|---|---|
| ||
void |
Span | ||
---|---|---|
| ||
removeRelationItem |
...
Sample |
...
class | sIndent |
---|
...
Code Block | ||
---|---|---|
| ||
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 |
...
...
...
...
...
...
...
...
...
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
...
class | lastDetailRow |
---|
...
Supported Clients Sample |