Join Table data source is the result of a join operation. Nested joins are supported. To use nested joins, set either leftTableSource or rightTableSource to be a joinTable.
Referenced by: dataSource
Properties
| Property | Details |
|---|---|
| joinType | The type of join (left outer or left inner). Valid values:
|
| leftTableKey | Field name from the left table. |
| leftTableSource | The left source. If the leftTableSource is a table, the resulting joinTable is a table. If the leftTableSource is a layer, the resulting joinTable is a layer. |
| rightTableKey | Field name from the right table. |
| rightTableSource | The right table source. |
| type | String value indicating the type for the dataSource. Valid value of this property joinTable |
Join Table DataSource Example
{
"type": "joinTable",
"leftTableSource": {
"type": "mapLayer",
"mapLayerId": 0
},
"rightTableSource": {
"type": "dataLayer",
"dataSource": {
"type": "table",
"workspaceId": "MAP",
"dataSourceName": "MAP.user1.TaxLots",
"gdbVersion": "MAP.Version1"
}
},
"leftTableKey": "STATE_FIPS",
"rightTableKey": "FIPS",
"joinType": "esriLeftOuterJoin"
}