テーブル
本製品 はZoho Projects のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。
一般的には、Zoho Projects テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。
CData JDBC Driver for Zoho Projects テーブル
| Name | Description |
| BugAssociatedTasks | Fetches the details of the task associated with a bug. |
| BugComments | Fetch comments for the bug. |
| BugEntityProperties | Retrieves the data stored against an entity. The argument of this method should be the key that was used when the same data was stored. |
| BugFollowers | Get list of followers for the bug. |
| Bugs | Gets all the tasks in the given project. It fetches only the main tasks and not the subtasks. |
| BugTimelogs | Gets the time logs under a specific bug. |
| Contacts | Fetches all client contacts from a portal. |
| Events | Fetches all the tags present in a specific portal. |
| ForumCategories | Gets all the forum categories. |
| ForumComments | Gets all the forum comments. |
| Forums | Gets all the forums in the given project. |
| Milestones | Gets list of project layouts. |
| PortalClients | Returns the list of client companies in the portal. |
| Portals | Gets all the portals for the logged in user. |
| ProjectEntityProperties | Retrieves the data stored against an entity. The argument of this method should be the key that was used when the same data was stored. |
| ProjectGroups | Gets all the groups for the specified project. |
| Projects | Gets all the projects for the logged in user. |
| ProjectUsers | Gets the details of all the users in a specific project. |
| Statuses | Gets the statuses for the given project. |
| Tags | Fetches all the tags present in a specific portal. |
| TaskActivities | Retrieve details of who modified a specific task and when. |
| TaskComments | Get all the task comments. |
| TaskCustomfields | Usage information for the operation TaskCustomfields.rsd. |
| TaskEntityProperties | Retrieves the data stored against an entity. The argument of this method should be the key that was used when the same data was stored. |
| Tasklists | Get all the task lists in the given project. |
| Tasks | Gets all the tasks in the given project. It fetches only the main tasks and not the subtasks. |
| TaskSubtasks | View all the subtasks of the given task. |
| TaskTimelogs | Gets the time logs under a specific task. |
| Teams | Fetch the team details from the portal. |
| TeamUsers | Fetch details of a particular team. |
| Users | Gets the details of all the users in a specific project. |