Page History

Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\{table:class=servoy sReturnTypes}{tr:style=height: 30px;}{th}Return Types{th}{tr}{tr}{td}{span:class=sWordList}[JSRelationItem]{span}{td}{tr}{table}\\{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#INNER_JOIN]
Constant for set/get the joinType of a JSRelation.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#LEFT_OUTER_JOIN]
Constant for set/get the joinType of a JSRelation.{td}{tr}{tbody}{table}\\{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[Boolean]{td}{td}[#allowCreationRelatedRecords]
Flag that tells if related records can be created through this relation.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#allowParentDeleteWhenHavingRelatedRecords]
Flag that tells if the parent record can be deleted while it has related records.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#deleteRelatedRecords]
Flag that tells if related records should be deleted or not when a parent record is deleted.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#foreignDataSource]
Qualified name of the foreign data source.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#foreignServerName]
The name of the server where the foreign table is located.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#foreignTableName]
The name of the foreign table.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#initialSort]
A String which specified a set of sort options for the initial sorting of data
retrieved through this relation.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#joinType]
The join type that is performed between the primary table and the foreign table.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#name]
The name of the relation.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#primaryDataSource]
Qualified name of the primary data source.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#primaryServerName]
The name of the server where the primary table is located.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#primaryTableName]
The name of the primary table.{td}{tr}{tbody}{table}\\{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[JSRelationItem]\[]{td}{td}[#getRelationItems]\()
Returns an array of JSRelationItem objects representing the relation criteria defined for this relation.{td}{tr}{tbody}{tbody}{tr}{td}[JSRelationItem]{td}{td}[#newRelationItem]\(dataprovider, operator, foreinColumnName)
Creates a new relation item for this relation.{td}{tr}{tbody}{table}\\{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80}{tr:id=name}{td}h6.INNER_JOIN{td}{tr}{tr:id=des}{td}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_des|text=|trigger=button}{sub-section}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_des|trigger=none|class=sIndent}Constant for set/get the joinType of a JSRelation. It is also used in solutionModel.newRelation(...).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_ret|text=|trigger=button}{sub-section}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_see|text=|trigger=button}{sub-section}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_see|text=|trigger=button}{sub-section}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_sam|text=|trigger=button}{sub-section}{sub-section:2438EBC207AF28A3-50E566C6-448545AE-943FBEEE-A032785D28FEFC31DC172C80_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F}{tr:id=name}{td}h6.LEFT_OUTER_JOIN{td}{tr}{tr:id=des}{td}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_des|text=|trigger=button}{sub-section}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_des|trigger=none|class=sIndent}Constant for set/get the joinType of a JSRelation. It is also used in solutionModel.newRelation(...).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_ret|text=|trigger=button}{sub-section}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_see|text=|trigger=button}{sub-section}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_see|text=|trigger=button}{sub-section}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_sam|text=|trigger=button}{sub-section}{sub-section:3FA1A0CF326B4F43-080F3AD1-477A49AC-AC6DAD4F-D1D6E361D58A730177BD1E6F_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6}{tr:id=name}{td}h6.allowCreationRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_des|text=|trigger=button}{sub-section}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_des|trigger=none|class=sIndent}Flag that tells if related records can be created through this relation.

The default value of this flag is "false".{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_ret|text=|trigger=button}{sub-section}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_see|text=|trigger=button}{sub-section}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_see|text=|trigger=button}{sub-section}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_sam|text=|trigger=button}{sub-section}{sub-section:5E45F3256565DC86-21220F72-4D794486-83C2A482-2BCEFCC900730D1BD82CFCB6_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowCreationRelatedRecords = true;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724}{tr:id=name}{td}h6.allowParentDeleteWhenHavingRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_des|text=|trigger=button}{sub-section}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_des|trigger=none|class=sIndent}Flag that tells if the parent record can be deleted while it has related records.

The default value of this flag is "true".{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_ret|text=|trigger=button}{sub-section}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_see|text=|trigger=button}{sub-section}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_see|text=|trigger=button}{sub-section}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_sam|text=|trigger=button}{sub-section}{sub-section:4414F83A9D6D38A7-0B5EBBA6-44F14EF9-AC529414-5DED0B6B211B9F7D5C04F724_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.allowParentDeleteWhenHavingRelatedRecords = false;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD}{tr:id=name}{td}h6.deleteRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_des|text=|trigger=button}{sub-section}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_des|trigger=none|class=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".{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_ret|text=|trigger=button}{sub-section}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_see|text=|trigger=button}{sub-section}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_see|text=|trigger=button}{sub-section}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_sam|text=|trigger=button}{sub-section}{sub-section:5884E5121FEA85A5-FA90A216-43814195-9DB19746-69F377D7985CAE19066118DD_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.deleteRelatedRecords = true;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3}{tr:id=name}{td}h6.foreignDataSource{td}{tr}{tr:id=des}{td}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_des|text=|trigger=button}{sub-section}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_des|trigger=none|class=sIndent}Qualified name of the foreign data source. Contains both the name of the foreign
server and the name of the foreign table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_ret|text=|trigger=button}{sub-section}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_see|text=|trigger=button}{sub-section}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_see|text=|trigger=button}{sub-section}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_sam|text=|trigger=button}{sub-section}{sub-section:26604DBB16410C43-E552AFCA-43AD407A-B6248414-23B8A1D59590B9548F14CFC3_sam|class=sIndent|trigger=none}{code:language=javascript}
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';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86}{tr:id=name}{td}h6.foreignServerName{td}{tr}{tr:id=des}{td}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_des|text=|trigger=button}{sub-section}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_des|trigger=none|class=sIndent}The name of the server where the foreign table is located.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_ret|text=|trigger=button}{sub-section}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_see|text=|trigger=button}{sub-section}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_see|text=|trigger=button}{sub-section}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_sam|text=|trigger=button}{sub-section}{sub-section:2BEA0483D92B339D-8ECFE6FA-441A4F35-BD59B40B-3E8A170A0329FFE13E8F3F86_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryTableName = 'another_parent_table';
relation.primaryServerName = 'user_data';
relation.foreignTableName = 'another_child_table';
relation.foreignServerName = 'user_data';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE}{tr:id=name}{td}h6.foreignTableName{td}{tr}{tr:id=des}{td}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_des|text=|trigger=button}{sub-section}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_des|trigger=none|class=sIndent}The name of the foreign table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_ret|text=|trigger=button}{sub-section}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_see|text=|trigger=button}{sub-section}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_see|text=|trigger=button}{sub-section}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_sam|text=|trigger=button}{sub-section}{sub-section:DCD636581ACBB6ED-61B64AFD-4CD845F7-9076A537-0451D864C6DE2537C84138BE_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryTableName = 'another_parent_table';
relation.primaryServerName = 'user_data';
relation.foreignTableName = 'another_child_table';
relation.foreignServerName = 'user_data';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834}{tr:id=name}{td}h6.initialSort{td}{tr}{tr:id=des}{td}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_des|text=|trigger=button}{sub-section}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_des|trigger=none|class=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, ...".{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_ret|text=|trigger=button}{sub-section}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_see|text=|trigger=button}{sub-section}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_see|text=|trigger=button}{sub-section}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_sam|text=|trigger=button}{sub-section}{sub-section:917A46AF90E7B524-53DCD894-4515415D-81439B0A-78AC4CCD9E8495D3CB17D834_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.initialSort = 'another_child_table_text asc';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B}{tr:id=name}{td}h6.joinType{td}{tr}{tr:id=des}{td}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_des|text=|trigger=button}{sub-section}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_des|trigger=none|class=sIndent}The join type that is performed between the primary table and the foreign table.
Can be "inner join" or "left outer join".{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_ret|text=|trigger=button}{sub-section}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_see|text=|trigger=button}{sub-section}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_see|text=|trigger=button}{sub-section}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_sam|text=|trigger=button}{sub-section}{sub-section:AAD2ABCE44223C27-EADFC555-497146CE-A505BB00-6B6B6E3E8719E06F4D04B56B_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.joinType = JSRelation.LEFT_OUTER_JOIN;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1}{tr:id=name}{td}h6.name{td}{tr}{tr:id=des}{td}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_des|text=|trigger=button}{sub-section}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_des|trigger=none|class=sIndent}The name of the relation.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_ret|text=|trigger=button}{sub-section}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_see|text=|trigger=button}{sub-section}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_see|text=|trigger=button}{sub-section}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_sam|text=|trigger=button}{sub-section}{sub-section:B5B9BEE7A2985AD0-FD9D4389-4CB04F26-B821913B-DE42F1DCB20247F6C6A240A1_sam|class=sIndent|trigger=none}{code:language=javascript}
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;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987}{tr:id=name}{td}h6.primaryDataSource{td}{tr}{tr:id=des}{td}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_des|text=|trigger=button}{sub-section}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_des|trigger=none|class=sIndent}Qualified name of the primary data source. Contains both the name of the primary server
and the name of the primary table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_ret|text=|trigger=button}{sub-section}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_see|text=|trigger=button}{sub-section}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_see|text=|trigger=button}{sub-section}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_sam|text=|trigger=button}{sub-section}{sub-section:BBED42CF0FF9CC32-10C48E83-48AC4138-9D7EB6A5-41A8D93F4FE7D9EA69290987_sam|class=sIndent|trigger=none}{code:language=javascript}
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';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E}{tr:id=name}{td}h6.primaryServerName{td}{tr}{tr:id=des}{td}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_des|text=|trigger=button}{sub-section}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_des|trigger=none|class=sIndent}The name of the server where the primary table is located.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_ret|text=|trigger=button}{sub-section}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_see|text=|trigger=button}{sub-section}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_see|text=|trigger=button}{sub-section}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_sam|text=|trigger=button}{sub-section}{sub-section:0779C7BEE48D2124-35B9C8AA-4F4947A1-9934B2FF-B350DFA4D6F7F147856FD78E_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryTableName = 'another_parent_table';
relation.primaryServerName = 'user_data';
relation.foreignTableName = 'another_child_table';
relation.foreignServerName = 'user_data';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8}{tr:id=name}{td}h6.primaryTableName{td}{tr}{tr:id=des}{td}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_des|text=|trigger=button}{sub-section}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_des|trigger=none|class=sIndent}The name of the primary table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_ret|text=|trigger=button}{sub-section}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_see|text=|trigger=button}{sub-section}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_see|text=|trigger=button}{sub-section}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_sam|text=|trigger=button}{sub-section}{sub-section:96F798897956ACDE-FE0C6C44-40CD4241-A720BE8B-14B67E938F392B8918C4E0E8_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.primaryTableName = 'another_parent_table';
relation.primaryServerName = 'user_data';
relation.foreignTableName = 'another_child_table';
relation.foreignServerName = 'user_data';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5}{tr:id=name}{td}h6.getRelationItems{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSRelationItem]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getRelationItems{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_des|text=|trigger=button}{sub-section}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_des|trigger=none|class=sIndent}Returns an array of JSRelationItem objects representing the relation criteria defined for this relation.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_ret|text=|trigger=button}{sub-section}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_ret|trigger=none|class=sIndent}[JSRelationItem]\[] -- An array of JSRelationItem instances representing the relation criteria of this relation.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_see|text=|trigger=button}{sub-section}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_see|text=|trigger=button}{sub-section}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_sam|text=|trigger=button}{sub-section}{sub-section:7CF98AA104E07B95-10978F32-4E694415-8ABCBCE6-F25EC54587A7D0815290AAD5_sam|class=sIndent|trigger=none}{code:language=javascript}
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);
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577}{tr:id=name}{td}h6.newRelationItem{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSRelationItem]{span}{span:id=iets|style=float: left; font-weight: bold;}newRelationItem{span}{span:id=iets|style=float: left;}\(dataprovider, operator, foreinColumnName){span}{td}{tr}{tr:id=des}{td}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_des|text=|trigger=button}{sub-section}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_des|trigger=none|class=sIndent}Creates a new relation item for this relation. The primary dataprovider, the foreign data provider 
and one relation operators (like '=' '!=' '>' '<') must be provided.{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_prs|trigger=none}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.
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_ret|text=|trigger=button}{sub-section}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_ret|trigger=none|class=sIndent}[JSRelationItem] -- A JSRelationItem instance representing the newly added relation item.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_see|text=|trigger=button}{sub-section}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_see|text=|trigger=button}{sub-section}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_sam|text=|trigger=button}{sub-section}{sub-section:98CF6EA842738F63-404BF161-45B94F21-A1A7BDE4-F64D670E155D6EED0E329577_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
relation.newRelationItem('another_parent_table_id', '=', 'another_child_table_parent_id');
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 2

New Version 3

Key
