Excel Add-In for Zoho Projects

Build 23.0.8839

TaskStatusHistory

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839