Projects
Get all projects in the organization that the authenticated user has access to and details of the specific project.
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Unique identifier of the project. | |
CapabilitiesProcessTemplateName | String | False |
Process template capabilities this project has. | |
CapabilitiesProcessTemplateTypeId | String | False |
Process template capabilities this project has. | |
CapabilitiesVersionControlType | String | False |
Version control capabilities this project has. | |
CapabilitiesVersionControlGitEnabled | Boolean | False |
Version control capabilities this project has. | |
CapabilitiesVersionControlTfvcEnabled | Boolean | False |
Version control capabilities this project has. | |
DefaultTeamId | String | False |
Team (identity) GUID. | |
DefaultTeamName | String | False |
The name of the default team. | |
DefaultTeamUrl | String | False |
The URL of the team. | |
DefaultTeamImageUrl | String | False |
URL to default team identity image. | |
Description | String | False |
The description of the project. | |
LastUpdateTime | Datetime | False |
The timestamp at which the project was last updated. | |
Links | String | True |
Aggregate of the reference links. | |
Name | String | False |
The name of the project. | |
Revision | Integer | False |
The revision of the project. | |
State | String | False |
The current state of the project. | |
Url | String | False |
URL to the full version of the object. | |
Visibility | String | False |
Indicates whom the project is visible to. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
Name | Type | Description |
GetDefaultTeamImageUrl | Boolean |
If set, returns of the default team image URL. |
IncludeCapabilities | Boolean |
Include capabilities (such as source control) in the team project result (default: false). |