UserGroupSources
Query the sources (Users, Roles, Territories, UserGroups) of user groups.
View-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following columns and operators.
- UserGroupId supports the '=' operator.
- Type supports the '=' operator.
- UserType supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM UserGroupSources WHERE UserGroupId = '1170218000000627002'; SELECT * FROM UserGroupSources WHERE Type = 'groups'; SELECT * FROM UserGroupSources WHERE UserType = 'inactive' AND Type = 'users';
Please note that to filter based on Type 'user_groups', you must supply the value of the filter as 'groups'.
Columns
| Name | Type | Description |
| UserGroupId [KEY] | String | A unique numeric identifier for the user group. |
| SourceId [KEY] | String | The ID of the source. |
| SourceName | String | The name of the source. |
| Type | String | The type of source.
The allowed values are users, roles, groups, territories. |
| Subordinates | Boolean | When type is 'roles' or 'territories', this field represents whether this source has subordinates. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UserType | String | To get the details of the sources of type 'Users' of a group by their user type. The possible values are active, inactive, and deleted.
The allowed values are active, inactive, deleted. |
| DeleteSource | Boolean | When updating the sources of a UserGroup, this field can be used to delete a source from the UserGroup. Please note that this field should be used for only those sources which you want to delete. |