Phases

Gets all the phases (milestones) in the given project.

Select

Id supports '=' operator
Name supports '=,!=,CONTAINS' operators
Flag supports '=,!=,CONTAINS' operators
StartDate supports '=,!=,>,>=,<,<=' operators
EndDate supports '=,!=,>,>=,<,<=' operators
ViewId supports '=' operator
MilestoneIds supports '=' operator

StartDate, EndDate, CreatedTime, and LastModifiedTime columns support ORDER BY server side. For example, the following query is processed server side:

SELECT * FROM Phases WHERE Id = '123456000000043771'

Insert

Name field is required when creating a new Phase.

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

Name
Flag
StartDate
EndDate
OwnerZpuid
StatusId
ProjectId
Tags

To create a new Phase you can use the below query:

INSERT INTO Phases (name, StartDate, EndDate, OwnerZpuid, flag) 
VALUES ('New Milestone name', '2022-03-01', '2022-03-10', '1234567890', 'internal')

Update

To update a Phase specify the Id field.

UPDATE Phases SET Name = 'Updated Name', Flag = 'external', StartDate = '2022-02-01',EndDate = '2022-03-01' WHERE Id = '123456000000043021'

Delete

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

DELETE FROM Phases WHERE Id = '123456000000043021'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Phase Id.
Name	String	False	Phase Name.
Flag	String	False	Phase Flag. The allowed values are internal, external.
StartDate	Date	False	Phase Start Date.
EndDate	Date	False	Phase End Date.
CreatedTime	Datetime	True	Phase Created Time.
OwnerFirstName	String	True	Phase Owner First Name.
OwnerLastName	String	True	Phase Owner Last Name.
OwnerName	String	True	Phase Owner Name.
OwnerEmail	String	True	Phase Owner Email.
OwnerZpuid	Long	False	Phase Owner Zpuid.
OwnerZuid	Long	True	Phase Owner Zuid.
StatusId	Long	False	Phase Status Detail Id.
StatusName	String	True	Phase Status Detail Name.
StatusColor	String	True	Phase Status Detail Color.
StatusColorHexCode	String	True	Phase Status Detail Color HexCode.
StatusIsClosedType	Boolean	True	Indicates if status is closed.
Sequence	Integer	True	Phase Sequence.
ProjectId	Long	True	Project Id.
ProjectName	String	True	Project Name.
LastModifiedTime	Datetime	True	Phase Last Modified Time.
CreatedByFirstName	String	True	Phase Created By First Name.
CreatedByLastName	String	True	Phase Created By Last Name.
CreatedByName	String	True	Phase Created By Name.
CreatedByEmail	String	True	Phase Created By Email.
CreatedByZuid	Long	True	Phase Created By Zuid.
CreatedByZpuid	Long	True	Phase Created By Zpuid.
Color	String	False	The hex color code to be used for the phase's Gantt bar.
Tags	String	False	Phase Tags.
ViewId	Long	True	Identifier of a custom view to filter phases.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
PhaseIds	String	The comma-separated phase IDs to retrieve specific records.