Excel Add-In for Zoho Projects

Build 26.0.9770

ProjectStatuses

Retrieves the list of global statuses configured for project module.

Select

Columns that support '=' operator server side:

  • SearchTerm
  • StatusIds
  • StatusNames
You can use the below query to get all Project Statuses:
SELECT * FROM ProjectStatuses

Following query can be processed server side:

SELECT * from ProjectStatuses where StatusIds='[460276000000005092,460276000000005095]'

Columns

Name Type Description
Id [KEY] Long Status Id.
Name String Status Name.
Color String Status Sequence.
ColorCode String Status Color Code.
SearchTerm String Keyword to filter statuses by name.
StatusIds String An array of status IDs to retrieve specific statuses.
StatusNames String An array of status names to retrieve specific statuses.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770