JDBC Driver for Zoho Projects

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Zoho Projects Views

Name Description
Activities List all the recent activities of the project.
BugActivities Gets all the activities for the given bug.
BugAttachments Get details of attachments for a bug.
BugCustomFields Gets all the custom fields in the given project.
BugResolution Get bug's resolution.
Clients Returns the list of client companies associated with a specific project ID.
Documents List all the recent activities of the project.
MyBugs Lists all the bugs created by you or assigned to you.
MyMilestones Get all the milestones assigned to a particular user in the given project.
MyTasks Gets all your tasks in the portal.
MyTimelogs Gets the time logs under a specific bug.
ProjectCustomFields Gets all the project custom fields.
ProjectCustomStatus Gets list of all project custom status.
ProjectLayouts Gets list of project layouts.
Timelogs Gets the time logs under a specific bug.
TaskAttachments Retrieve details of attachments associated to the task.
TaskLayouts View the list of all the task layouts available in your portal.
TaskStatusHistory Fetches status history of tasks from the Portal.
Timelogs Gets the time logs under a specific bug.
TimesheetCustomFields Fetch all timesheet custom fields across the project.
PortalUsersRemaining Gets the details of all users in a specific portal.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462