servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Constants SummaryConstant 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 sSummary12%30%58%height: 30px;3Property SummaryFlag 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 sSummary12%30%58%height: 30px;3Methods SummaryReturns an array of JSRelationItem objects representing the relation criteria defined for this relation.Returns the UUID of the relation objectCreates a new relation item for this relation.voidRemoves the desired relation item from the specified relation.constantservoy sDetail2100%height:30px2Constants DetailsFULL_JOINname
FULL_JOIN
dessIndentConstant for the joinType of a Query Builder join.ret
Returns
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow INNER_JOINname
INNER_JOIN
dessIndentConstant for the joinType of a JSRelation. It is also used in solutionModel.newRelation(...) and in the QueryBuilder.ret
dessIndentA 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
sIndentclients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRow joinTypename
joinType
dessIndentThe join type that is performed between the primary table and the foreign table. Can be "inner join" or "left outer join".ret
dessIndentCreates a new relation item for this relation. The primary dataprovider, the foreign data provider and one relation operators (like '=' '!=' '>' '<') must be provided.prs
Parameters
sIndentdataproviderThe name of the primary dataprovider.operatorThe operator used to relate the primary and the foreign dataproviders.foreinColumnNameThe name of the foreign dataprovider.ret