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=E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE}{tr:id=name}{td}h6.INNER_JOIN{td}{tr}{tr:id=des}{td}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_des|text=|trigger=button}{sub-section}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_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:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_ret|text=|trigger=button}{sub-section}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_see|text=|trigger=button}{sub-section}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_see|text=|trigger=button}{sub-section}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_sam|text=|trigger=button}{sub-section}{sub-section:E3C46EA02438EBC2-68FD50E5-48794485-A00C943F-E3106B78D797A032785D28FE_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=6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A}{tr:id=name}{td}h6.LEFT_OUTER_JOIN{td}{tr}{tr:id=des}{td}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_des|text=|trigger=button}{sub-section}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_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:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_ret|text=|trigger=button}{sub-section}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_see|text=|trigger=button}{sub-section}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_see|text=|trigger=button}{sub-section}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_sam|text=|trigger=button}{sub-section}{sub-section:6D2EF8673FA1A0CF-CE76080F-4F40477A-8FC8AC6D-C0A8AF86A4D3D1D6E361D58A_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=C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073}{tr:id=name}{td}h6.allowCreationRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_des|text=|trigger=button}{sub-section}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_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:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_ret|text=|trigger=button}{sub-section}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_see|text=|trigger=button}{sub-section}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_see|text=|trigger=button}{sub-section}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_sam|text=|trigger=button}{sub-section}{sub-section:C56ACBE65E45F325-225E2122-43744D79-96C883C2-BA087F787EAF2BCEFCC90073_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=D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B}{tr:id=name}{td}h6.allowParentDeleteWhenHavingRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_des|text=|trigger=button}{sub-section}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_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:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_ret|text=|trigger=button}{sub-section}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_see|text=|trigger=button}{sub-section}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_see|text=|trigger=button}{sub-section}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_sam|text=|trigger=button}{sub-section}{sub-section:D85129294414F83A-40AF0B5E-4BC844F1-8D41AC52-21C793CE5A1B5DED0B6B211B_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=4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C}{tr:id=name}{td}h6.deleteRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_des|text=|trigger=button}{sub-section}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_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:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_ret|text=|trigger=button}{sub-section}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_see|text=|trigger=button}{sub-section}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_see|text=|trigger=button}{sub-section}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_sam|text=|trigger=button}{sub-section}{sub-section:4B2EF6325884E512-F67BFA90-48DE4381-93609DB1-2B463B78577F69F377D7985C_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=EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590}{tr:id=name}{td}h6.foreignDataSource{td}{tr}{tr:id=des}{td}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_des|text=|trigger=button}{sub-section}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_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:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_ret|text=|trigger=button}{sub-section}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_see|text=|trigger=button}{sub-section}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_see|text=|trigger=button}{sub-section}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_sam|text=|trigger=button}{sub-section}{sub-section:EBDFCB5526604DBB-F6EEE552-42DF43AD-81CEB624-985D9AB5A58C23B8A1D59590_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=B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329}{tr:id=name}{td}h6.foreignServerName{td}{tr}{tr:id=des}{td}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_des|text=|trigger=button}{sub-section}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_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:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_ret|text=|trigger=button}{sub-section}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_see|text=|trigger=button}{sub-section}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_see|text=|trigger=button}{sub-section}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_sam|text=|trigger=button}{sub-section}{sub-section:B79890052BEA0483-96978ECF-44AA441A-9CC3BD59-EC18D8DFB2173E8A170A0329_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=018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE}{tr:id=name}{td}h6.foreignTableName{td}{tr}{tr:id=des}{td}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_des|text=|trigger=button}{sub-section}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_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:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_ret|text=|trigger=button}{sub-section}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_see|text=|trigger=button}{sub-section}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_see|text=|trigger=button}{sub-section}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_sam|text=|trigger=button}{sub-section}{sub-section:018C24B2DCD63658-03FA61B6-48594CD8-9CDE9076-3199480E02380451D864C6DE_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=21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84}{tr:id=name}{td}h6.initialSort{td}{tr}{tr:id=des}{td}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_des|text=|trigger=button}{sub-section}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_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:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_ret|text=|trigger=button}{sub-section}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_see|text=|trigger=button}{sub-section}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_see|text=|trigger=button}{sub-section}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_sam|text=|trigger=button}{sub-section}{sub-section:21A50EA6917A46AF-E39353DC-43484515-92BC8143-383F05A8E60478AC4CCD9E84_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=FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719}{tr:id=name}{td}h6.joinType{td}{tr}{tr:id=des}{td}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_des|text=|trigger=button}{sub-section}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_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:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_ret|text=|trigger=button}{sub-section}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_see|text=|trigger=button}{sub-section}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_see|text=|trigger=button}{sub-section}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_sam|text=|trigger=button}{sub-section}{sub-section:FD653BBAAAD2ABCE-27BFEADF-49104971-BB77A505-F2369809967D6B6B6E3E8719_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=AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202}{tr:id=name}{td}h6.name{td}{tr}{tr:id=des}{td}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_des|text=|trigger=button}{sub-section}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_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:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_ret|text=|trigger=button}{sub-section}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_see|text=|trigger=button}{sub-section}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_see|text=|trigger=button}{sub-section}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_sam|text=|trigger=button}{sub-section}{sub-section:AC385CCFB5B9BEE7-80B1FD9D-4A6F4CB0-AC6FB821-5D13C4CF028BDE42F1DCB202_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=66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7}{tr:id=name}{td}h6.primaryDataSource{td}{tr}{tr:id=des}{td}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_des|text=|trigger=button}{sub-section}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_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:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_ret|text=|trigger=button}{sub-section}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_see|text=|trigger=button}{sub-section}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_see|text=|trigger=button}{sub-section}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_sam|text=|trigger=button}{sub-section}{sub-section:66579D0FBBED42CF-97DF10C4-4FFD48AC-8C6F9D7E-B96FC7FAF66F41A8D93F4FE7_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=39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7}{tr:id=name}{td}h6.primaryServerName{td}{tr}{tr:id=des}{td}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_des|text=|trigger=button}{sub-section}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_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:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_ret|text=|trigger=button}{sub-section}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_see|text=|trigger=button}{sub-section}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_see|text=|trigger=button}{sub-section}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_sam|text=|trigger=button}{sub-section}{sub-section:39A216220779C7BE-601635B9-45734F49-A4DA9934-D41CF3A39A86B350DFA4D6F7_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=4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39}{tr:id=name}{td}h6.primaryTableName{td}{tr}{tr:id=des}{td}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_des|text=|trigger=button}{sub-section}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_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:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_ret|text=|trigger=button}{sub-section}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_see|text=|trigger=button}{sub-section}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_see|text=|trigger=button}{sub-section}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_sam|text=|trigger=button}{sub-section}{sub-section:4F4DA17796F79889-35D2FE0C-409640CD-80EEA720-C2C509D561D714B67E938F39_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=46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7}{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:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_des|text=|trigger=button}{sub-section}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_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:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_ret|text=|trigger=button}{sub-section}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_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:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_see|text=|trigger=button}{sub-section}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_see|text=|trigger=button}{sub-section}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_sam|text=|trigger=button}{sub-section}{sub-section:46E0C4137CF98AA1-09761097-42E34E69-A34B8ABC-D2681CC4149BF25EC54587A7_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=7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D}{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:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_des|text=|trigger=button}{sub-section}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_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:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_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:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_ret|text=|trigger=button}{sub-section}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_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:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_see|text=|trigger=button}{sub-section}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_see|text=|trigger=button}{sub-section}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_sam|text=|trigger=button}{sub-section}{sub-section:7E41AC5D98CF6EA8-6EFE404B-4EB545B9-8B51A1A7-B8EFBC48D561F64D670E155D_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 1

New Version 2

Key
