Issues
Gets all the issues in the given project.
Select
Columns that support the = operator:
- Id
- AssigneeZpuid
- SeverityId
- ClassificationId
- Flag
- IssueIds
- ViewId
Columns that support the IN operator:
- AssigneeZpuid
- SeverityId
- ClassificationId
- Flag
Columns that support server-side ORDER BY:
- DueDate
- CreatedTime
- LastUpdatedTime
SELECT * FROM Issues WHERE AssigneeZpuid = '460276000000076009'
Insert
To create a new Issue, you can specify the following fields:
- Name
- AssigneeZpuid
- StatusId
- Description
- SeverityId
- ClassificationId
- ModuleId
- ReproducibleId
- DueDate
- Flag
- Tags
- AssociatedTeamId
- ReleaseMilestoneId
- AffectedMilestoneId
- ReminderType
- ReminderCustomDate
- ReminderDaysBefore
- ReminderTime
- ReminderNotifyUsers
For example, the following query creates a new issue:
INSERT INTO Issues (Name, Description, AssigneeZpuid, flag, ClassificationId, DueDate, ModuleId, SeverityId, ReproducibleId)
VALUES ('SQL Inserted Bug #5', 'Test Description', '12341249448', 'Internal', '123456000000031015', '2022-03-20', '123456000000031145', '123456000000031149', '123456000000031053')
Update
You can use the below query to update a issue:
UPDATE Issues SET Name = 'SQL Inserted Bug #5', Description = 'Another Test Description' WHERE Id = '165818000000042126'
Delete
Issues can be deleted by providing the Id and issuing a DELETE statement.
DELETE FROM Issues WHERE Id = '123456000000042126'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Long | True |
Unique identifier of the issue. |
| Name | String | False |
Issue name. |
| Prefix | String | True |
Prefix used for issue numbering. |
| Description | String | False |
Issue description. |
| AssigneeZpuid | Long | False |
Portal-specific ID of the user assigned to the issue. |
| AssigneeZuid | Long | True |
Zoho user ID of the user assigned to the issue. |
| AssigneeFirstName | String | True |
First name of the user assigned to the issue. |
| AssigneeLastName | String | True |
Last name of the user assigned to the issue. |
| AssigneeName | String | True |
Display name of the user assigned to the issue. |
| AssigneeEmail | String | True |
Email address of the user assigned to the issue. |
| StatusId | Long | False |
ID of the issue status. |
| StatusName | String | True |
Status name of the issue. |
| StatusColor | String | True |
Status color. |
| StatusColorHexCode | String | True |
Status color hexcode. |
| IsClosedTypeStatus | Boolean | True |
Closed Type of the status. |
| ProjectId | Long | True |
Issue project ID. |
| ProjectName | String | True |
Project name of the issue. |
| SeverityId | Long | False |
Issue severity ID. |
| SeverityValue | String | True |
Severity name of the issue. |
| ClassificationId | Long | False |
Classification ID of the issue. |
| ClassificationValue | String | True |
Classification name of the issue. |
| ModuleId | Long | False |
Module ID associated with the issue. |
| ModuleValue | String | True |
Module name of the issue. |
| ReproducibleId | Long | False |
Reproducibility ID of the issue. |
| ReproducibleValue | String | True |
Reproducibility value of the issue. |
| Flag | String | False |
Issue flag. The allowed values are internal, external. |
| DueDate | Datetime | False |
Due date of the issue in ISO format. |
| CreatedByZuid | Long | True |
Zoho user ID of the creator. |
| CreatedByZpuid | Long | True |
Portal-specific user ID of the creator. |
| CreatedByFirstName | String | True |
First name of the creator. |
| CreatedByLastName | String | True |
Last name of the creator. |
| CreatedByName | String | True |
Display name of the creator. |
| CreatedByEmail | String | True |
Email address of the creator. |
| CreatedTime | Datetime | True |
Created time of the issue in ISO format. |
| LastUpdatedTime | Datetime | True |
Last updated time of the issue in ISO format. |
| Tags | String | False |
Tags associated with the issue. |
| AssociatedTeamId | Long | False |
ID of the team linked to the issue. |
| AssociatedTeamName | String | True |
Name of the team linked to the issue. |
| ReleaseMilestoneId | Long | False |
ID of the release phase associated with the issue. |
| ReleaseMilestoneValue | String | True |
Name of the release phase associated with the issue. |
| AffectedMilestoneId | Long | False |
ID of the affected phase associated with the issue. |
| AffectedMilestoneValue | String | True |
Name of the affected phase associated with the issue. |
| AddedVia | String | True |
Specifies how the issue is added. |
| IssueIds | String | True |
The comma-separated IDs of specific issues to retrieve. |
| ViewId | String | True |
The ID of a custom view to apply its saved filters and column settings. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ReminderType | String |
Specifies reminder trigger type. The allowed values are daily, on_due_date, before_due_date, custom_date. |
| ReminderCustomDate | Datetime |
Reminder date details in ISO format. |
| ReminderDaysBefore | Integer |
Number of days before the due date to send the reminder. |
| ReminderTime | String |
The time of day to send the reminder. |
| ReminderNotifyUsers | String |
IDs of users to notify when the reminder is triggered. |