People
Retrieve People on Basecamp 3.
ビュー固有の情報
Select
Retrieve all People visible to the current user, list people by Project, or specify an Id to get more information. Id and ProjectId are the columns supported by Basecamp as search criteria.
SELECT * FROM People WHERE Id = '123456789' SELECT * FROM People WHERE ProjectId = '5168618'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The unique identifier for the person. | |
| Name | String | The name of the person. | |
| Owner | Boolean | Boolean value to show if the current person is the account owner. | |
| Admin | Boolean | Boolean value to show if the current person is an admin or not. | |
| Title | String | The title of the person. | |
| Bio | String | Bio description of the person. | |
| CreatedAt | Datetime | The date and time when the record was created. | |
| UpdatedAt | Datetime | The date and time when the record was last updated. | |
| EmailAddress | String | The email address of the person. | |
| AttachableSgid | String | The attachable Set Group ID. | |
| PersonableType | String | Type of the person. | |
| TimeZone | String | Human readable timezone for the user. | |
| CompanyId | Long | Id of users company. | |
| CompanyName | String | Name of users company. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ProjectId | Long | Use filter to retrieve active people on the project with the given ID. |