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.