Portals
Gets all the portals for the logged in user.
Select
The add-in 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 add-in.
- 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ViewId | String |