Excel Add-In for Zoho Projects

Build 23.0.8839

MyBugs

Lists all the bugs created by you or assigned to you.

Select

This is a portal-level view.
  • StatusType, Owner, ViewType and ViewType support the following operator: =.
  • CreatedDate and LastModifiedTime support: ORDER
For example, the following query is processed server side:
SELECT * FROM MyBugs WHERE Owner = '12345021738' AND ViewType = 'owned' AND StatusType = 'open' ORDER BY CreatedDate

Columns

Name Type Description
Id [KEY] String Bug Id.
Key String Bug Key.
Title String Bug Title.
AssigneeId String Bug Assignee Id.
AssigneeName String Bug Assignee Name.
AssigneeZpuid String Bug Assignee ZPUID.
AttachmentCount String Bug Attachment Count.
BugPrefix String Bug Prefix.
ClassificationId Long Bug Classification Id.
ClassificationType String Bug Classification Type.
Closed Boolean Bug Closed.
CommentCount String Bug Comment Count.
CreatedDate Date Bug Created Date.
CreatedDateTime Datetime Bug Created Date Time.
Description String Bug Description.
DueDate Date Bug Due Date.
DueDateTime Date Bug Due Date Time.
Flag String Bug Flag.
LinkSelfUrl String Bug Link Self Url.
LinkTimesheetUrl String Bug Link Timesheet Url.
ModuleId Long Bug Module Id.
ModuleName String Bug Module Name.
ProjectId Long Bug Project Id.
ProjectIdString String Bug Project Id String.
ProjectName String Bug Project Name.
ReportedPerson String Bug Reported Person.
ReporterId String Bug Reporter Id.
ReproducibleId Long Bug Reproducible Id.
ReproducibleType String Bug Reproducible Type.
SeverityId Long Bug Severity Id.
SeverityType String Bug Severity Type.
StatusId Long Bug Status Id.
StatusType String Bug Status Type.

使用できる値は次のとおりです。open, closed

UpdatedDate Date Bug Updated Date.
UpdatedDateTime Datetime Bug Updated Date Time.
UpdatedTimeLong Long Bug Updated Time Long.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Owner String Bug Owner.
ViewType String Bug View Type.

使用できる値は次のとおりです。reported, owned

LastModifiedTime Datetime Bug Last Modified Time.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839