UserGroupSources
Query the sources (Users, Roles, Territories, UserGroups) of user groups.
View-Specific Information
Select
The 本製品 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.
使用できる値は次のとおりです。users, roles, groups, territories |
| Subordinates | Boolean | When type is 'roles' or 'territories', this field represents whether this source has subordinates. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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.
使用できる値は次のとおりです。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. |