MyIssues
Lists all the issues created by you or assigned to you.
Select
This is a portal-level view.Columns that support the = operator:
- Id
- AssigneeZpuid
- SeverityId
- ClassificationId
- Flag
- IssueIds
- ViewId
Columns that support: ORDER
- CreatedTime
- LastUpdatedTime
- DueDate
SELECT * FROM MyIssues WHERE AssigneeZpuid = '460276000000076009' ORDER BY CreatedTime
Columns
| Name | Type | Description |
| Id [KEY] | Long | Unique identifier of the issue. |
| Name | String | Issue name. |
| Prefix | String | Prefix used for issue numbering. |
| Description | String | Issue description. |
| AssigneeZpuid | Long | Portal-specific ID of the user assigned to the issue. |
| AssigneeZuid | Long | Zoho user ID of the user assigned to the issue. |
| AssigneeFirstName | String | First name of the user assigned to the issue. |
| AssigneeLastName | String | Last name of the user assigned to the issue. |
| AssigneeName | String | Display name of the user assigned to the issue. |
| AssigneeEmail | String | Email address of the user assigned to the issue. |
| StatusId | Long | ID of the issue status. |
| StatusName | String | Status name of the issue. |
| StatusColor | String | Status color. |
| StatusColorHexCode | String | Status color hexcode. |
| IsClosedTypeStatus | Boolean | Closed Type of the status. |
| ProjectId | Long | Issue project ID. |
| ProjectName | String | Project name of the issue. |
| SeverityId | Long | Issue severity ID. |
| SeverityValue | String | Severity name of the issue. |
| ClassificationId | Long | Classification ID of the issue. |
| ClassificationValue | String | Classification name of the issue. |
| ModuleId | Long | Module ID associated with the issue. |
| ModuleValue | String | Module name of the issue. |
| ReproducibleId | Long | Reproducibility ID of the issue. |
| ReproducibleValue | String | Reproducibility value of the issue. |
| Flag | String | Issue flag.
The allowed values are internal, external. |
| DueDate | Datetime | Due date of the issue in ISO format. |
| CreatedByZuid | Long | Zoho user ID of the creator. |
| CreatedByZpuid | Long | Portal-specific user ID of the creator. |
| CreatedByFirstName | String | First name of the creator. |
| CreatedByLastName | String | Last name of the creator. |
| CreatedByName | String | Display name of the creator. |
| CreatedByEmail | String | Email address of the creator. |
| CreatedTime | Datetime | Created time of the issue in ISO format. |
| LastUpdatedTime | Datetime | Last updated time of the issue in ISO format. |
| Tags | String | Tags associated with the issue. |
| AssociatedTeamId | Long | ID of the team linked to the issue. |
| AssociatedTeamName | String | Name of the team linked to the issue. |
| ReleaseMilestoneId | Long | ID of the release phase associated with the issue. |
| ReleaseMilestoneValue | String | Name of the release phase associated with the issue. |
| AffectedMilestoneId | Long | ID of the affected phase associated with the issue. |
| AffectedMilestoneValue | String | Name of the affected phase associated with the issue. |
| AddedVia | String | Specifies how the issue is added. |
| IssueIds | String | The comma-separated IDs of specific issues to retrieve. |
| ViewId | String | The ID of a custom view to apply its saved filters and column settings. |