Excel Add-In for Zoho Projects

Build 23.0.8839

Portals

Gets all the portals for the logged in user.

Select

The 本製品 will use the Zoho Projects API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id and ViewId support the following operator: =.
For example, the following query is processed server side:
SELECT * FROM Portals WHERE Id = '20081021809'

Columns

Name Type ReadOnly Description
Id [KEY] String False

Portal Id.

Name String False

Portal Name.

CompanyName String False

Portal Company Name.

AvailableClients Integer False

Portal Available Clients.

AvailableUsers Integer False

Portal Available Users.

AvailableProjects Integer False

Portal Available Projects.

BugPlan String False

Portal Bug Plan.

BugPlural String False

Bug Plural.

BugSingular String False

Bug Singular.

CanAddTemplate Boolean False

Can Add Portal Template.

CanCreateProject Boolean False

Can Create Portal Project.

Default Boolean False

Default Portal.

ExtensionsAppSettings String False

Portal Extensions Locations App Settings.

ExtensionsAttachmentPicker String False

Portal Extensions Locations Attachment Picker.

ExtensionsBlueprintDuring String False

Portal Extensions Locations Blueprint During.

ExtensionsIssueTab String False

Portal Extensions Locations Issue Tab.

ExtensionsIssuedetailsRightpanel String False

Portal Extensions Locations Issue Details Right Panel.

ExtensionsProjectTab String False

Portal Extensions Locations Project Tab.

ExtensionsTaskTab String False

Portal Extensions Locations Task Tab.

ExtensionsTaskTransition String False

Portal Extensions Locations Task Transition.

ExtensionsTaskdetailsRightpanel String False

Portal Extensions Locations Task Details Right Panel.

ExtensionsTopBand String False

Portal Extensions Locations Top Band.

GmtTimeZone String False

Portal GMT Time Zone.

GmtTimeZoneOffset Integer False

Portal GMT Time Zone Offset.

MeetingEnabled Boolean False

Portal Meeting Enabled.

PeopleEnabled Boolean False

Portal People Enabled.

CrmPartner Boolean False

Portal CRM Partner.

DisplayProjectPrefix Boolean False

Portal Display Project Prefix.

DisplayTaskPrefix Boolean False

Portal Display Task Prefix.

NewPlan Boolean False

Portal New Plan.

SprintsIntegrated Boolean False

Portal Sprints Integrated.

TagsAvailable Boolean False

Portal Tags Available.

TimeLogRestricted Boolean False

Portal Time Log Restricted.

ProjectsModuleId String False

Portal Projects Module Id.

TasksModuleId String False

Portal Tasks Module Id.

ProjectUrl String False

Portal Project URL.

LocaleCode String False

Portal Locale Code.

LocaleCountry String False

Portal Locale Country.

Language String False

Portal Language.

LoginZpuid Long False

Portal Login ZPUID.

MaxClients Integer False

Portal Max Clients.

MaxUsers Integer False

Portal Max Users.

NewUserPlan Boolean False

Portal New User Plan.

PercentageCalculation String False

Portal Percentage Calculation.

Plan String False

Portal Plan.

ProfileId Long False

Portal Profile Id.

ProfileName String False

Portal Profile Name.

ProfileType Integer False

Portal Profile Type.

ActiveProjects Integer False

Portal Active Projects.

ProjectPrefix String False

Portal Project Prefix.

Role String False

Portal Role.

RoleId String False

Portal Role Id.

RoleName String False

Portal Role Name.

BusinessHoursEnd Integer False

Portal Business Hours End.

BusinessHoursStart Integer False

Portal Business Hours Start.

DateFormat String False

Portal Date Format.

DefaultCurrency String False

Portal Default Currency.

DefaultDependencyType String False

Portal Default Dependency Type.

BudgetPermission Boolean False

Portal Budget Permission.

Holidays String False

Portal Holidays.

BudgetEnabled Boolean False

Portal Budget Enabled.

LastSyncTime String False

Portal Last Sync Time.

StartDayOfWeek String False

Portal Start Day of Week.

TaskDateFormat String False

Portal Task Date Format.

TaskDurationType String False

Portal Task Duration Type.

TimeZone String False

Portal Time Zone.

EditTimeLogRestricted Boolean False

Portal Edit Time Log Restricted.

LogFutureTimeAllowed Boolean False

Portal Log Future Time Allowed.

LogPastTimeAllowed Boolean False

Portal Log Past Time Allowed.

DefaultBillingStatus String False

Portal Default billing Status.

TimesheetApprovalEnabled Boolean False

Portal Timesheet Approval Enabled.

WorkingDays String False

Portal Working Days.

SprintsProjectPermission Boolean False

Portal Sprints Project Permission.

StorageType String False

Portal Storage Type.

TrialEnabled Boolean False

Portal Trial Enabled.

LogHrRestrictedByWorkHr Boolean False

Portal Log Hr restricted by Work Hr.

Pseudo-Columns

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

Name Type Description
ViewId String

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