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

For example, the following query is processed server side:

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.