Portals
Gets all the portals for the logged in user.
Select
The connector 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 connector.
- Id and ViewId support the following operator: =.
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 |