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.
The allowed values are open, closed. |
| UpdatedDate | Date | Bug Updated Date. |
| UpdatedDateTime | Datetime | Bug Updated Date Time. |
| UpdatedTimeLong | Long | Bug Updated Time Long. |
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 |
| Owner | String | Bug Owner. |
| ViewType | String | Bug View Type.
The allowed values are reported, owned. |
| LastModifiedTime | Datetime | Bug Last Modified Time. |