Territories
Get the list of territories enabled for your organization.
Table-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.
- Id supports the '=' operator.
For example, the following queries are processed server-side:
SELECT * FROM Territories WHERE Id = '1234567890123456789'
Insert
To create a territory, you must at least supply values for the Name, PermissionType, and ReportingToId columns.INSERT INTO Territories (Name,PermissionType,ReportingToId) VALUES ('Testing','read_only','1234567890123456789');
Update
Specify the Id in the WHERE clause when executing an update in this table.
UPDATE Territories SET Name = 'Update' WHERE Id = '1234567890123456789';
Delete
Specify the Id in the WHERE clause when executing a delete in this table.
DELETE FROM Territories WHERE ID = '1234567890123456789';
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Represents the unique ID of the territory. |
| Name | String | False |
Represents the name of the territory. |
| ParentId | String | True |
Represents the unique ID of the parent territory, if any. |
| Managername | String | True |
Represents the name of the current territory's manager. |
| Managerid | String | False |
Represents the ID of the current territory's manager. |
| CreatedByName | String | True |
Represents the name of the user who created the current territory. |
| CreatedById | String | True |
Represents the ID of the user who created the current territory. |
| ModifiedByName | String | True |
Represents the name of the user who last modified the current territory. |
| ModifiedByid | String | True |
Represents the ID of the user who last modified the current territory. |
| CreatedAt | Datetime | True |
Represents the date and time at which the current territory was created. |
| ModifiedAt | Datetime | True |
Represents the date and time at which the current territory was last modified. |
| Description | String | False |
Represents the description of the territory, if any. |
| ApiName | String | True |
Represents the api name of the territory. |
| PermissionType | String | False |
Represents the type of permission for the territory. Possible values are read_only and read_write_delete. |
| AccountRuleCriteria | String | False |
Represents the criteria for account module territory rules (comparator, field, and value). |
| LeadRuleCriteria | String | False |
Represents the criteria for lead module territory rules (comparator, field, and value). |
| DealRuleCriteria | String | False |
Represents the criteria for deal module territory rules (comparator, field, and value). |
| ReportingToName | String | True |
Represents the name of the parent territory. |
| ReportingToId | String | False |
Represents the ID of the parent territory. |