Tasks

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
CreatedBy
MilestoneId
Priority
TasklistId
Owner
Status
Time
LastModifiedTime
ViewId

CreatedDate and LastModifiedTime support: ORDER

For example, the following query is processed server side:

SELECT * FROM Tasks WHERE MilestoneId = '12345600000123' AND Priority = 'High' ORDER BY CreatedDate

Insert

To create a new Task you can specify the following fields:

Name
Description
Owners
Duration
DurationType
EndDate
Priority
StartDate
TasklistId
Work
GroupNameAssociatedTeamsAnyTeam
RatePerHour
ReminderString
Recurrence
BudgetValue
BudgetThreshold

INSERT INTO Tasks (Name, Description, Duration, DurationType, Priority,  BudgetValue)
VALUES ('New Task #2', 'This is a test description', '5', 'hrs', 'High', '1000')

Update

To update a Task specify the Id field.

UPDATE Tasks SET Priority = 'Low' WHERE Id = '123456000000034003'

Delete

Tasks can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Tasks WHERE Id = '123456000000034003'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Task Id.
Name	String	False	Task Name.
Key	String	False	Task Key.
BillingType	String	False	Task Billing Type.
Completed	Boolean	False	Task Completed.
CreatedBy	String	False	Task Created By.
CreatedByEmail	String	False	Task Created By Email.
CreatedByZpuid	String	False	Task Created By Zpuid.
CreatedPerson	String	False	Task Created Person.
CreatedDate	Date	False	Task Created Date.
CreatedDateTime	Datetime	False	Task Created Date Time.
Description	String	False	Task Description.
Owners	String	False	Task Owners.
Duration	String	False	Task Duration.
DurationType	String	False	Task Duration Type. 使用できる値は次のとおりです。days, hrs
EndDate	Date	False	Task End Date.
EndDateTime	Datetime	False	Task End Date Time.
CommentAdded	Boolean	False	Task Comment Added.
DocsAssociated	Boolean	False	Task Docs Associated.
ForumAssociated	Boolean	False	Task Forum Associated.
RecurrenceSet	Boolean	False	Task Recurrence Set.
ReminderSet	Boolean	False	Task Reminder Set.
Parent	Boolean	False	Task Parent.
LastUpdatedDate	Date	False	Task Last Updated Date.
LastUpdatedDateTime	Datetime	False	Task Last Updated Date Time.
LinkSelfUrl	String	False	Task Link Self Url.
LinkTimesheetUrl	String	False	Task Link Timesheet Url.
LinkWebUrl	String	False	Task Link Web Url.
LogHoursBillableHours	String	False	Task Log Hours Billable Hours.
LogHoursNonBillableHours	String	False	Task Log Hours Non Billable Hours.
MilestoneId	String	False	Task Milestone Id.
OrderSequence	Integer	False	Task Order Sequence.
PercentComplete	String	False	Task Percent Complete.
Priority	String	False	Task Priority. 使用できる値は次のとおりです。none, low, medium, high
StartDate	Date	False	Task Start Date.
StartDateTime	Datetime	False	Task Start Date Time.
StatusColorCode	String	False	Task Status Color Code.
StatusName	String	False	Task Status Name.
StatusId	String	False	Task Status Id.
StatusType	String	False	Task Status Type.
Subtasks	Boolean	False	Task Subtasks.
TaskFollowers	String	False	Task Task Followers.
TaskFollowerSize	Integer	False	Task Task Follower Size.
TasklistId	String	False	Tasklist Id.
TasklistName	String	False	Tasklist Name.
Work	String	False	Task Work.
WorkForm	String	False	Task Work Form.
WorkType	String	False	Task Work Type. 使用できる値は次のとおりです。work_hrs_per_day
GroupNameAssociatedTeamsAnyTeam	String	False	Task Group Name Associated Teams Any Team.
GroupNameAssociatedTeamsCount	Integer	False	Task Group Name Associated Teams Count.
GroupNameIsTeamUnassigned	Boolean	False	Task Group Name Is Team Unassigned.
RatePerHour	String	False	Task Rate Per Hour.
ReminderString	String	False	Task Reminder String.
Recurrence	String	False	Task Recurrence.
BudgetValue	String	False	Task Budget Value.
BudgetThreshold	String	False	Task Budget Threshold.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Owner	String	Task Owner.
Status	String	Task Status. 使用できる値は次のとおりです。completed, notcompleted
Time	String	Task Time. 使用できる値は次のとおりです。overdue, today, tomorrow
LastModifiedTime	Datetime	Task Last Modified Time.
ViewId	String	Task View Id.