Page History

{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=}h3.Relations
By default, relations join together two datasources, for example a CUSTOMERS (source) and a ORDERS (destination) table. Through [RelationItems|RelationItem] the nature of the link between the datasources is defined, for example to link the CUSTOMERS and ORDERS table based on the customer_id column.

At runtime a relation is an object of type [JSFoundset]. The related FoundSet that a Relation is, is used in Solutions to display related data, for example using a [Field], a [TabPanel] or a [Portal] or to work with related data in business logic.

h3.Special Relations
Next to the default relations that link two datasources together, there are several other types of relations, based on how the relation is setup.

h6.Global relations
Relations that contain only RelationItems based on global variables on the source side, thus no dependency on the source table are considered global relations.

Global relations can be used to get a limited FoundSet, for example all active customers, by adding a relation item that specifies that the "active" flag in the CUSTOMERS table has to be equal to a certain global variable. For example, if the CUSTOMERS table (used as destination datasource) contains a column called "is_active" of type INTEGER and a default value of 1 (indicating it is an active record), the following would create a global relation that returns a FoundSet with all active customers:
{code:title=Setup a global variable}var ACTIVE = 1;{code}

!Global Relation Item.JPG|border=1!

h6.Container relations
If the source and destination datasources are equal and the relation does not contain any RelationItems, it becomes a Container relation. A Container relation returns it originating FoundSet. A Container relation can be used to set the FoundSet of the parent form into the Form displayed in a TabPanel.

h6.Selfjoins
Relations can use the same datasource as source and destination datasource. Depending on the setup of the the RelationItems the relation can point back to the originating record or one or more different records.

h3.Relation options
Relations have several settings that influence the behavior of the Relation under different circumstances.

h6.Join Types
Join types determine the behavior of sorting when there are no related records and the sort is performed on related fields.

*Inner join*: When sorting records on related dataproviders over a relation that uses the "inner join" type, if a parent record does not have any related records, the parent record is excluded from the foundset
*Left outer join*: When sorting records on related dataproviders over a relation that uses the "left outer join" type, if a parent record does not have any related records, the parent record remains in the foundset

{tip:title=Use Left outer join}In most scenario's the "Left outer join" type is the join type to use for relations{tip}

h6.Record creation
*Allow creation of related records*: This property indicates if the relation can be used to create new related records
- true: the execution of "customers_to_orders.newRecord()" will create a new record.
- false: trying to create a new record over the relation  will throw a [ServoyException.NO_RELATED_CREATE_ACCESS|ServoyException#ServoyException.NO_RELATED_CREATE_ACCESS] exception.

h6.Record deletion
*Allow parent delete when having related records*: This property indicates if a record can be deleted if it has child records
- true: related records will not block the delete of thetheir parent record
- false: when there are related order records, Servoy will block the delete of thetheir customerparent record and raise a [ServoyException.NO_PARENT_DELETE_WITH_RELATED_RECORDS|ServoyException#ServoyException.NO_PARENT_DELETE_WITH_RELATED_RECORDS] exception.

{note:title=*Allow parent delete when having related records* overrules *Delete related records*}The option *Allow parent delete when having related records* overrules the option *Delete related records*. This means that if the first option is set to false, the latter option is ignored. Setting the first option to false and the latter option to true will still block the delete.{note}

{note:title=All relations for the datasource checked on delete}When an attempt is made to delete a record, each relation that uses as source the same datasource as the record that is to be deleted will be checked to see if it allows the delete to proceed. If one relation is found that blocks the delete, the entire delete will fail.{note}

{note:title=Performance}If the option *Allow parent delete when having related records* is set to false on a relation, when a record is deleted from the datasource that is used as source for the relation, a check will be made to see if there are related records. If many relations exist with the option set to false, this can impact the performance of deletes.{note}

*Delete related records*: This property indicates if child records should be automatically deleted when the parent record is deleted
- true: when the customer record is deleted and there are related records in the orders table, those order records will also get deleted.
- false: related records will remain untouched.

{note:title=Cascading deletes}Deletes cascade down when encountering relations on the related records that are to be deleted that also have the *Delete related records* property set to true. This means that when a record from the CUSTOMERS datasource is deleted and the relation customer_to_orders has the *Delete related records* set to true, the order records will also be deleted. If there is a relation order_to_orderitems that also has the *Delete related records* property set to true, the orderitem records will also get deleted.{note}

{note:title=Deleting of related records can block the overall delete}When a relation has the *Delete related records* property set to true, an attempt is made to also delete all individual related records. On each individual related record the checks mentioned previous will also be performed. If any of the related records blocks the delete, the entire delete is blocked.{note}

_Example 1: A simple scenario_
This example defines three relations in the typical customer > orders > orderitems setup:
Relation 1: customer_to_orders, allowParentDeleteWhenHavingRelatedRecords=true, deleteRelatedRecords=true
Relation 2: order_to_orderitems, allowParentDeleteWhenHavingRelatedRecords=true, deleteRelatedRecords=true
Relation 3: orderitem_to_product, allowParentDeleteWhenHavingRelatedRecords=true, deleteRelatedRecords=true

If an attempt is made to delete a customer record which has order and the orders have orderitems, when the relations are setup as described above the customer record will be deleted, all the orders related to the customer are deleted and all orderitems related to the orders of the customer will be deleted.

As Relation 3 has the deleteRelatedRecords property set to false, no attempt will be made to delete the product record related to the orderitems that are to be deleted.

_Example 2: Implementing business logic enforcement in the data layer_
This example defines four relations starting with the in the typical customer > orders > orderitems setup, followed by the following business logic enforced by the datamodel: If an order resulted in an Invoice, the id of the invoice is stored on the order record in the invoice_id column. If an order has a related invoice then it cannot be deleted
Relation 1: customer_to_orders, allowParentDeleteWhenHavingRelatedRecords=false, deleteRelatedRecords=false
Relation 2: order_to_orderitems, allowParentDeleteWhenHavingRelatedRecords=false, deleteRelatedRecords=false
Relation 3: orderitem_to_product, allowParentDeleteWhenHavingRelatedRecords=false, deleteRelatedRecords=false
Relation 4: order_to_invoice, allowParentDeleteWhenHavingRelatedRecords=false

This setup is mostly the same as example 1, except for the additional fourth relation. This relation from the orders table to the invoices defines that the order record cannot be deleted if it has a related invoice record.

In this setup, when an attempt is made to delete a customer record the delete is blocked if the customer has a related order that has a related invoice record.
{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}[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}[#foreignTable]
Qualified name of the foreign data source.{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}[#primaryTable]
Qualified name of the primary data source.{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=16474A7A-E3F8-4521-B8B8-0117531AB502}{tr:id=name}{td}

h6. allowCreationRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_des|text=|trigger=button}{sub-section}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_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:16474A7A-E3F8-4521-B8B8-0117531AB502_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_ret|text=|trigger=button}{sub-section}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_see|text=|trigger=button}{sub-section}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_see|text=|trigger=button}{sub-section}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_sam|text=|trigger=button}{sub-section}{sub-section:16474A7A-E3F8-4521-B8B8-0117531AB502_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DE00CF62-BBFF-4CCF-8F92-E4A2627EA196}{tr:id=name}{td}

h6. allowParentDeleteWhenHavingRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_des|text=|trigger=button}{sub-section}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_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:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_ret|text=|trigger=button}{sub-section}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_see|text=|trigger=button}{sub-section}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_see|text=|trigger=button}{sub-section}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_sam|text=|trigger=button}{sub-section}{sub-section:DE00CF62-BBFF-4CCF-8F92-E4A2627EA196_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3015BAAD-69EB-4E7B-B237-09C6198EE2FF}{tr:id=name}{td}

h6. deleteRelatedRecords{td}{tr}{tr:id=des}{td}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_des|text=|trigger=button}{sub-section}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_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:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_ret|text=|trigger=button}{sub-section}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_see|text=|trigger=button}{sub-section}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_see|text=|trigger=button}{sub-section}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_sam|text=|trigger=button}{sub-section}{sub-section:3015BAAD-69EB-4E7B-B237-09C6198EE2FF_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F03C0813-5AC8-47C8-A7C6-060FEC49D6CB}{tr:id=name}{td}

h6. foreignTable{td}{tr}{tr:id=des}{td}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_des|text=|trigger=button}{sub-section}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_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:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_ret|text=|trigger=button}{sub-section}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_see|text=|trigger=button}{sub-section}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_see|text=|trigger=button}{sub-section}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_sam|text=|trigger=button}{sub-section}{sub-section:F03C0813-5AC8-47C8-A7C6-060FEC49D6CB_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=5394857F-A29E-42EC-9692-35CF2793B324}{tr:id=name}{td}

h6. initialSort{td}{tr}{tr:id=des}{td}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_des|text=|trigger=button}{sub-section}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_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:5394857F-A29E-42EC-9692-35CF2793B324_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:5394857F-A29E-42EC-9692-35CF2793B324_ret|text=|trigger=button}{sub-section}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_see|text=|trigger=button}{sub-section}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_see|text=|trigger=button}{sub-section}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_sam|text=|trigger=button}{sub-section}{sub-section:5394857F-A29E-42EC-9692-35CF2793B324_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=94F12761-3463-4AA7-A73B-526516E198EF}{tr:id=name}{td}

h6. joinType{td}{tr}{tr:id=des}{td}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_des|text=|trigger=button}{sub-section}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_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:94F12761-3463-4AA7-A73B-526516E198EF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:94F12761-3463-4AA7-A73B-526516E198EF_ret|text=|trigger=button}{sub-section}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_see|text=|trigger=button}{sub-section}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_see|text=|trigger=button}{sub-section}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_sam|text=|trigger=button}{sub-section}{sub-section:94F12761-3463-4AA7-A73B-526516E198EF_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=3A513961-7973-4ABF-9E87-501D97E23B68}{tr:id=name}{td}

h6. name{td}{tr}{tr:id=des}{td}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_des|text=|trigger=button}{sub-section}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_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:3A513961-7973-4ABF-9E87-501D97E23B68_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_ret|text=|trigger=button}{sub-section}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_see|text=|trigger=button}{sub-section}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_see|text=|trigger=button}{sub-section}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_sam|text=|trigger=button}{sub-section}{sub-section:3A513961-7973-4ABF-9E87-501D97E23B68_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=157DD405-5AA6-49DB-82E9-09AA9C06343C}{tr:id=name}{td}

h6. primaryTable{td}{tr}{tr:id=des}{td}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_des|text=|trigger=button}{sub-section}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_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:157DD405-5AA6-49DB-82E9-09AA9C06343C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}{*}Returns*
\\  {sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_ret|text=|trigger=button}{sub-section}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_see|text=|trigger=button}{sub-section}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_see|text=|trigger=button}{sub-section}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sam}{td}*Sample*\\{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_sam|text=|trigger=button}{sub-section}{sub-section:157DD405-5AA6-49DB-82E9-09AA9C06343C_sam|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}