servoy sReturnTypes 2 100% height: 30px; 2 Supported Clients sWordList SmartClient sWordList WebClient sWordList NGClient
servoy sSummary 12% 30% 58% height: 30px; 3 Constants Summary Constant for the joinType of a Query Builder join. Constant for the joinType of a JSRelation. Constant for the joinType of a JSRelation. Constant for the joinType of a Query Builder join.
servoy sSummary 12% 30% 58% height: 30px; 3 Property Summary 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.
servoy sSummary 12% 30% 58% height: 30px; 3 Methods Summary 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. void Removes the desired relation item from the specified relation.
constant servoy sDetail 2 100% height:30px 2 Constants Details FULL_JOIN name FULL_JOIN des sIndent Constant for the joinType of a Query Builder join. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow INNER_JOIN name INNER_JOIN des sIndent Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...) and in the QueryBuilder. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow LEFT_OUTER_JOIN name LEFT_OUTER_JOIN des sIndent Constant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...) and in the QueryBuilder. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow RIGHT_OUTER_JOIN name RIGHT_OUTER_JOIN des sIndent Constant for the joinType of a Query Builder join. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
property servoy sDetail 2 100% height:30px 2 Property Details allowCreationRelatedRecords name allowCreationRelatedRecords des sIndent Flag that tells if related records can be created through this relation.
The default value of this flag is "false". ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow allowParentDeleteWhenHavingRelatedRecords name allowParentDeleteWhenHavingRelatedRecords des sIndent Flag that tells if the parent record can be deleted while it has related records.
The default value of this flag is "true". ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow deleteRelatedRecords name deleteRelatedRecords des sIndent 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". ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow foreignDataSource name foreignDataSource des sIndent Qualified name of the foreign data source. Contains both the name of the foreign
server and the name of the foreign table. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow initialSort name initialSort des sIndent 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, ...". ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow joinType name joinType des sIndent The join type that is performed between the primary table and the foreign table.
Can be "inner join" or "left outer join". ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow name name name des sIndent The name of the relation. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow primaryDataSource name primaryDataSource des sIndent Qualified name of the primary data source. Contains both the name of the primary server
and the name of the primary table. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
function servoy sDetail 2 100% height:30px 2 Methods Details getRelationItems name getRelationItems() des sIndent Returns an array of JSRelationItem objects representing the relation criteria defined for this relation. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getUUID name getUUID() des sIndent Returns the UUID of the relation object ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow newRelationItem name newRelationItem(dataprovider, operator, foreinColumnName) des sIndent Creates a new relation item for this relation. The primary dataprovider, the foreign data provider
and one relation operators (like '=' '!=' '>' '<') must be provided. prs Parameters
sIndent 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. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow removeRelationItem name removeRelationItem(primaryDataProviderID, operator, foreignColumnName) des sIndent Removes the desired relation item from the specified relation. prs Parameters
sIndent primaryDataProviderID the primary data provider (column) name operator the operator foreignColumnName the foreign column name clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow