MyBugs
Lists all the bugs created by you or assigned to you.
Select
This is a portal-level view.- StatusType, Owner, ViewType and ViewType support the following operator: =.
- CreatedDate and LastModifiedTime support: ORDER
SELECT * FROM MyBugs WHERE Owner = '12345021738' AND ViewType = 'owned' AND StatusType = 'open' ORDER BY CreatedDate
Columns
| Name | Type | Description |
| Id [KEY] | String | Bug Id. |
| Key | String | Bug Key. |
| Title | String | Bug Title. |
| AssigneeId | String | Bug Assignee Id. |
| AssigneeName | String | Bug Assignee Name. |
| AssigneeZpuid | String | Bug Assignee ZPUID. |
| AttachmentCount | String | Bug Attachment Count. |
| BugPrefix | String | Bug Prefix. |
| ClassificationId | Long | Bug Classification Id. |
| ClassificationType | String | Bug Classification Type. |
| Closed | Boolean | Bug Closed. |
| CommentCount | String | Bug Comment Count. |
| CreatedDate | Date | Bug Created Date. |
| CreatedDateTime | Datetime | Bug Created Date Time. |
| Description | String | Bug Description. |
| DueDate | Date | Bug Due Date. |
| DueDateTime | Date | Bug Due Date Time. |
| Flag | String | Bug Flag. |
| LinkSelfUrl | String | Bug Link Self Url. |
| LinkTimesheetUrl | String | Bug Link Timesheet Url. |
| ModuleId | Long | Bug Module Id. |
| ModuleName | String | Bug Module Name. |
| ProjectId | Long | Bug Project Id. |
| ProjectIdString | String | Bug Project Id String. |
| ProjectName | String | Bug Project Name. |
| ReportedPerson | String | Bug Reported Person. |
| ReporterId | String | Bug Reporter Id. |
| ReproducibleId | Long | Bug Reproducible Id. |
| ReproducibleType | String | Bug Reproducible Type. |
| SeverityId | Long | Bug Severity Id. |
| SeverityType | String | Bug Severity Type. |
| StatusId | Long | Bug Status Id. |
| StatusType | String | Bug Status Type.
使用できる値は次のとおりです。open, closed |
| UpdatedDate | Date | Bug Updated Date. |
| UpdatedDateTime | Datetime | Bug Updated Date Time. |
| UpdatedTimeLong | Long | Bug Updated Time Long. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Owner | String | Bug Owner. |
| ViewType | String | Bug View Type.
使用できる値は次のとおりです。reported, owned |
| LastModifiedTime | Datetime | Bug Last Modified Time. |