Fetches status history of tasks from the Portal.

Select

This is a portal-level view.

• LastModifiedTime supports: ORDER

You can use the below query to get all Task Layouts:

SELECT * FROM TaskStatusHistory ORDER BY LastModifiedTime

Columns

Name	Type	Description
Id [KEY]	String	Task Status History Id.
Name	String	Task Status History Name.
StatusId	String	Task Status History Status Id.
StatusName	String	Task Status History Status Name.
PreviousStatusId	String	Task Status History Previous Status Id.
PreviousStatusName	String	Task Status History Previous Status Name.
UpdatedStatusId	String	Task Status History Updated Status Id.
UpdatedStatusName	String	Task Status History Updated Status Name.
TransitionTimeMillis	String	Task Status History Transition Time Millis.
TransitionTimeDuration	String	Task Status History Transition Time Duration.
UpdatedBy	String	Task Status History Updated By.
UpdatedByName	String	Task Status History Updated By Name.
UpdatedByEmail	String	Task Status History Updated By Email.
UpdatedOn	Datetime	Task Status History Updated On.

Pseudo-Columns

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

Name	Type	Description
LastModifiedTime	Datetime	Task Status History Last Modified Time.