Bugs
Gets all the tasks in the given project. It fetches only the main tasks and not the subtasks.
Select
Columns that support the = operator:- Id
- CreatedTime
- Flag
- StatusType
- CustomViewId
Columns that support the = and IN operator:
- AssigneeId
- ClassificationId
- EscalationLevel
- ModuleId
- SeverityId
- StatusId
- ReporterId
- MilestoneId
- AffectedMilestoneId
For example, the following query is processed server side:
SELECT * FROM Bugs WHERE ReporterId IN ('12341021738') AND AssigneeId IN ('12341021738') AND ClassificationId IN ('123456000000030015') AND EscalationLevel IN ('0') AND Flag = 'Internal' AND ModuleId IN ('123456000000030145') AND SeverityId IN ('123456000000030151') AND StatusId IN ('123456000000030083')
Insert
To create a new Bug, you can specify the following fields:
- Title
- AssigneeId
- ClassificationId
- Description
- DueDate
- Flag
- ModuleId
- ReproducibleId
- SeverityId
- HourlyRate
- BugFollowers
- MilestoneId
To create a new Bug, specify the following fields:
INSERT INTO Bugs (Title, Description, AssigneeId, flag, ClassificationId, DueDate, ModuleId, SeverityId, ReproducibleId, HourlyRate, CustomField1) VALUES ('SQL Inserted Bug #5', 'Test Description', '12341249448', 'Internal', '123456000000031015', '2022-03-20', '123456000000031145', '123456000000031149', '123456000000031053', '2', 'TestCustomField')
Update
You can use the below query to update a bug:
UPDATE Bugs SET Title = 'SQL Inserted Bug #5', Description = 'Another Test Description', AssigneeId = '20081249448', ClassificationId = '165818000000031015', DueDate = '2022-03-20', ModuleId = '165818000000031145', SeverityId = '165818000000031149', ReproducibleId = '165818000000031053', HourlyRate = '2', cf1 = 'Custom Field Edited #1' WHERE Id = '165818000000042126'
Delete
Bugs can be deleted by providing the Id and issuing a DELETE statement.
DELETE FROM Bugs WHERE Id = '123456000000042126'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Bug Id. |
Key | String | False |
Bug Key. |
Title | String | False |
Bug Title. |
AssigneeId | String | False |
Bug Assignee Id. |
AssigneeName | String | False |
Bug Assignee Name. |
AssigneeZpuid | String | False |
Bug Assignee ZPUID. |
AttachmentCount | String | False |
Bug Attachment Count. |
BugNumber | String | False |
Bug Number. |
BugPrefix | String | False |
Bug Prefix. |
ClassificationId | Long | False |
Bug Classification Id. |
ClassificationType | String | False |
Bug Classification Type. |
Closed | Boolean | False |
Bug Closed. |
CommentCount | String | False |
Bug Comment Count. |
CreatedTime | Date | False |
Bug Created Time. |
CreatedDateTime | Datetime | False |
Bug Created Date Time. |
Description | String | False |
Bug Description. |
DueDate | Date | False |
Bug Due Date. |
DueDateTime | Datetime | False |
Bug Due Date Time. |
EscalationLevel | String | False |
Bug Escalation Level. |
Flag | String | False |
Bug Flag. 使用できる値は次のとおりです。internal, external |
LinkSelfUrl | String | False |
Bug Link Self Url. |
LinkTimesheetUrl | String | False |
Bug Link Timesheet Url. |
LinkWebUrl | String | False |
Bug Link Web Url. |
ModuleId | Long | False |
Bug Module Id. |
ModuleName | String | False |
Bug Module Name. |
ReportedPerson | String | False |
Bug Reported Person. |
ReporterEmail | String | False |
Bug Reporter Email. |
ReporterId | String | False |
Bug Reporter Id. |
ReporterNonZuser | String | False |
Bug Reporter Non User. |
ReproducibleId | Long | False |
Bug Reproducible Id. |
ReproducibleType | String | False |
Bug Reproducible Type. |
SeverityId | Long | False |
Bug Severity Id. |
SeverityType | String | False |
Bug Severity Type. |
StatusColorcode | String | False |
Bug Status Color Code. |
StatusId | String | False |
Bug Status Id. |
StatusType | String | False |
Bug Status Type. 使用できる値は次のとおりです。open, closed |
UpdatedDate | Date | False |
Bug Updated Date. |
UpdatedDateTime | Datetime | False |
Bug Updated Date Time. |
GroupNameAssociatedTeamsAnyTeam | String | False |
Bug Group Name Associated Teams by Any Team. |
GroupNameAssociatedTeamsCount | Integer | False |
Bug Group Name Associated Teams Count. |
GroupNameIsTeamUnassigned | Boolean | False |
Bug Group Name Is Team Unassigned. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
HourlyRate | String |
Bug Hourly Rate. |
BugFollowers | String |
Bug Bug Followers. |
CustomViewId | String |
Bug Custom View Id. |
MilestoneId | String |
Bug Milestone Id. |
AffectedMilestoneId | String |
Bug Affected Milestone Id. |