Fetches status history of tasks from the Portal.

Select

This is a portal-level view. You can use the below query to get all Task Status History:

SELECT * FROM TaskStatusHistory

Columns

Name	Type	Description
Id	Long	Task Status History Id.
Name	String	Task Status History Name.
StatusId	Long	Task Status History Status Id.
StatusName	String	Task Status History Status Name.
StatusType	String	Task Status History Status Type.
ProjectId	Long	Task Status History Project Id.
PreviousStatusId	Long	Task Status History Previous Status Id.
PreviousStatusName	String	Task Status History Previous Status Name.
PreviousStatusType	String	Task Status History Previous Status Type.
UpdatedStatusId	Long	Task Status History Updated Status Id.
UpdatedStatusName	String	Task Status History Updated Status Name.
UpdatedStatusType	String	Task Status History Updated Status Type.
TransitionTimeMillis	Long	Task Status History Transition Time Millis.
TransitionTimeDuration	String	Task Status History Transition Time Duration.
UpdatedById	Long	Task Status History Updated By Id.
UpdatedByName	String	Task Status History Updated By Name.
UpdatedByEmail	String	Task Status History Updated By Email.
UpdatedByZpId	Long	Task Status History Updated By ZpId.
UpdatedOn	Datetime	Task Status History Updated On.
LastModifiedTime	Long	Task Status History Last Modified Time.