{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 sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[String]{td}{td}[#foreignColumnName]
The name of the column from the destination table
that this relation item is based on.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#operator]
The operator that defines the relationship between the primary dataprovider
and the foreign column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#primaryDataProviderID]
The name of the column from the source table 
that this relation item is based on.{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=5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0}{tr:id=name}{td}h6.foreignColumnName{td}{tr}{tr:id=des}{td}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_des|text=|trigger=button}{sub-section}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_des|trigger=none|class=sIndent}The name of the column from the destination table
that this relation item is based on.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_ret|text=|trigger=button}{sub-section}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_see|text=|trigger=button}{sub-section}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_see|text=|trigger=button}{sub-section}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_sam|text=|trigger=button}{sub-section}{sub-section:5F12A88A-5C4C-40B8-9484-FAD5E7DD38D0_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=EA4EE053-C650-4BBB-9316-7174A7ED57EC}{tr:id=name}{td}h6.operator{td}{tr}{tr:id=des}{td}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_des|text=|trigger=button}{sub-section}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_des|trigger=none|class=sIndent}The operator that defines the relationship between the primary dataprovider
and the foreign column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_ret|text=|trigger=button}{sub-section}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_see|text=|trigger=button}{sub-section}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_see|text=|trigger=button}{sub-section}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_sam|text=|trigger=button}{sub-section}{sub-section:EA4EE053-C650-4BBB-9316-7174A7ED57EC_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=EC4E0421-25E2-4937-AA1B-F1E270A94ECB}{tr:id=name}{td}h6.primaryDataProviderID{td}{tr}{tr:id=des}{td}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_des|text=|trigger=button}{sub-section}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_des|trigger=none|class=sIndent}The name of the column from the source table 
that this relation item is based on.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_ret|text=|trigger=button}{sub-section}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_see|text=|trigger=button}{sub-section}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_see|text=|trigger=button}{sub-section}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_sam|text=|trigger=button}{sub-section}{sub-section:EC4E0421-25E2-4937-AA1B-F1E270A94ECB_sam|class=sIndent|trigger=none}{code:language=javascript}
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}