IssueAssociatedTasks
Fetches the details of the task associated with an issue.
View Specific Information
This view shows associations between Issues and Tasks.
Select
- IssueId supports the following operator: =.
SELECT * FROM IssueAssociatedTasks WHERE IssueId = '123439000000045005'
Columns
| Name | Type | Description |
| TaskId [KEY] | Long | Unique identifier of the task. |
| IssueId | Long | Issue Id. |
| Name | String | Title of the task. |
| Prefix | String | Prefix used for task numbering. |
| Description | String | Description of the task. |
| Priority | String | Priority level of the task.
The allowed values are none, low, medium, high. |
| Color | String | Color of the task. |
| BillingType | String | Billing type for the task.
The allowed values are none, billable, non_billable. |
| CompletionPercentage | Integer | Progress of the task as a percentage (0-100). |
| IsCompleted | Boolean | Indicates whether the task is marked as completed. |
| Depth | Integer | Level of the task in the hierarchy. |
| CreatedVia | String | Source of task creation. |
| StartDate | Datetime | Scheduled start date/time in ISO 8601 format. |
| EndDate | Datetime | Scheduled end date/time in ISO 8601 format. |
| DurationValue | Integer | Duration value of the task. |
| DurationType | String | Unit for the duration.
The allowed values are days, hours. |
| Sequence | Integer | Sequence number of the task in its list. |
| SubTaskSequence | Integer | Sequence number of the sub task in its list. |
| CreatedTime | Datetime | Timestamp of when the task was created. |
| LastModifiedTime | Datetime | Timestamp of the most recent update. |
| StatusId | Long | Identifier of the current task status. |
| StatusName | String | Status label. |
| StatusColor | String | Status color reference name. |
| StatusColorHexcode | String | HEX color code for the status. |
| StatusIsClosedType | Boolean | Indicates whether the status represents a closed state. |
| ProjectId | Long | Identifier of the project. |
| ProjectName | String | Name of the project. |
| MilestoneId | Long | Identifier of the phase associated with the task. |
| MilestoneName | String | Name of the phase. |
| TasklistId | Long | Identifier of the task list containing the task. |
| TasklistName | String | Name of the task list. |
| ParentTaskId | Long | Identifier of the parent task. |
| RootTaskId | Long | Identifier of the root task. |
| CreatedByZuid | Long | Zoho user ID of the creator. |
| CreatedByZpuid | Long | Portal-specific user ID of the creator. |
| CreatedByName | String | Display name of the creator. |
| CreatedByEmail | String | Email address of the creator. |
| CreatedByFirstName | String | First name of the creator. |
| CreatedByLastName | String | Last name of the creator. |
| UpdatedByZuid | Long | Updated By Zuid. |
| UpdatedByZpuid | Long | Updated By Zpuid. |
| UpdatedByName | String | Updated By Name. |
| UpdatedByEmail | String | Updated By Email. |
| UpdatedByFirstName | String | Updated By First Name. |
| UpdatedByLastName | String | Updated By Last Name. |
| Owners | String | An array of direct owner objects (for task creation or retrieval) |
| WorkType | String | Defines whether work is standard or flexible. |
| TotalWork | String | Planned total work time for the task. |
| WorkUnit | String | Unit of measurement for the work allocation. |
| CopyTaskDuration | Boolean | Indicates whether the task duration is copied as work. |
| RefreshBusinessHours | Boolean | Used to refresh business hours based on settings. |
| RecurrenceId | Long | Identifier of the recurrence. |
| RecurrenceFrequency | String | Frequency for recurring tasks.
The allowed values are none, daily, weekly, monthly, yearly. |
| RecurrenceInterval | Integer | Interval between the recurrence frequency. |
| RecurrenceEndAfterOccurrences | String | Maximum number of occurrences allowed. |
| RecurrenceSetToPreviousBusinessday | Boolean | Adjusts recurrences to the previous business day if needed. |
| RecurrenceRetainComments | Boolean | Indicates whether comments are carried forward. |
| RecurrenceRetainSubtasks | Boolean | Indicates whether subtasks are carried forward. |
| RecurrenceNextAfterClose | Boolean | Indicates whether the next recurrence is scheduled after task close. |
| RecurrenceTriggerType | String | Indicates when the next recurrence should be triggered.
The allowed values are on_schedule, on_complete, first_to_occur. |
| RecurrenceRetainConfigComments | Boolean | Indicates whether comments are retained in recurrence configuration. |
| RecurrenceRetainConfigBillingType | Boolean | Indicates whether billing type is retained in recurrence configuration. |
| RecurrenceRetainConfigFollowers | Boolean | Indicates whether followers are retained in recurrence configuration. |
| RecurrenceRetainConfigDescription | Boolean | Indicates whether description is retained in recurrence configuration. |
| RecurrenceRetainConfigSubtasks | Boolean | Indicates whether subtasks are retained in recurrence configuration. |
| RecurrenceRetainConfigTags | Boolean | Indicates whether tags are retained in recurrence configuration. |
| RecurrenceRetainConfigAttachments | Boolean | Indicates whether attachments are retained in recurrence configuration. |
| RecurrenceRetainConfigTeams | Boolean | Indicates whether teams are retained in recurrence configuration. |
| RecurrenceDateBasedName | String | Name identifier of the date-based recurrence schedule. |
| RecurrenceDateBasedRepetativeType | String | Repetition type for the date-based recurrence. |
| RecurrenceDateBasedScheduleDatetime | Datetime | Scheduled date and time for the date-based recurrence. |
| RecurrenceDateBasedTimeSpan | Integer | Time span interval for the date-based recurrence. |
| RecurrenceDateBasedEndsAfterType | String | Type of end condition for the date-based recurrence. |
| RecurrenceDateBasedEndsAfterValue | String | Value for the end condition of the date-based recurrence. |
| RecurrenceDateBasedSkipType | String | Skip type when recurrence falls on a non-business day. |
| RecurrenceDateBasedStatus | String | Status of the date-based recurrence schedule. |
| RecurrenceDateBasedTime | String | Time of day for the date-based recurrence. |
| RecurrenceDateBasedId | Long | Identifier of the date-based recurrence. |
| RecurrenceDateBasedSchedulerId | Long | Identifier of the scheduler for the date-based recurrence. |
| RecurrenceDateBasedLastScheduleTime | Datetime | Timestamp of the last scheduled recurrence. |
| RecurrenceDateBasedNextScheduleTime | Datetime | Timestamp of the next scheduled recurrence. |
| RecurrenceDateBasedNoOfTimesExecuted | Integer | Number of times the recurrence has been executed. |
| RecurrenceDateBasedExecutedCount | Integer | Count of executed recurrence instances. |
| RecurrenceDateBasedIsCompleted | Boolean | Indicates whether the date-based recurrence is completed. |
| RecurrenceDateBasedFieldName | String | Field name used for the date-based recurrence trigger. |
| RecurrenceDateBasedDaysOfWeek | String | Days of the week for the date-based recurrence. |
| ReminderNotifyUsers | String | List of users or teams notified by the task reminder. |
| ReminderCriteria | String | Criteria for setting the task reminder.
The allowed values are none, daily, on, before, after. |
| ReminderTaskReminderId | Long | Unique identifier of the task reminder. |
| ReminderTime | String | Time for sending the task reminder. |
| ReminderNextRuntime | String | Next scheduled time for the task reminder. |
| BudgetInfoBudget | String | Budget allocated for the task. |
| BudgetInfoThreshold | String | Budget threshold for warnings. |
| BudgetInfoCurrencyCode | String | Currency used for budgeting. |
| BudgetInfoHourlyBudget | String | Hourly budget of the task. |
| BudgetInfoHourlyBudgetThreshold | String | Threshold for hourly budget warnings. |
| BudgetInfoRevenueBudget | Double | Revenue target for the task. |
| BudgetInfoCostRatePerHour | Double | Internal cost per hour. |
| BudgetInfoRatePerHour | Double | Billable rate per hour. |
| CostBudgetPlannedCost | Double | Planned cost of the task. |
| CostBudgetActualCost | Double | Actual cost of the task. |
| CostBudgetForecastedCost | Double | Predicted cost to completion. |
| CostBudgetBalance | Double | Remaining cost budget. |
| HourlyBudgetActualHours | String | Logged actual hours. |
| HourlyBudgetPlannedHours | String | Planned hours. |
| HourlyBudgetDifference | String | Difference between actual and planned hours. |
| HourlyBudgetForecastedHours | String | Forecasted hours. |
| RevenueBudgetPlannedRevenue | Double | Planned revenue for the task. |
| RevenueBudgetActualRevenue | Double | Actual revenue for the task. |
| RevenueBudgetForecastedRevenue | Double | Predicted revenue to completion. |
| LogHoursBillableHours | String | Hours logged as billable. |
| LogHoursNonBillableHours | String | Hours logged as non-billable. |
| LogHoursTotalHours | String | Total hours logged. |
| HasReminder | Boolean | Indicates whether the task has a reminder. |
| HasRecurrence | Boolean | Indicates whether the task has a recurrence. |
| HasComments | Boolean | Indicates whether the task has comments. |
| HasAttachments | Boolean | Indicates whether the task has attachments. |
| HasForums | Boolean | Indicates whether the task has associated forums. |
| HasSubtasks | Boolean | Indicates whether the task has subtasks. |
| HasBugs | Boolean | Indicates whether the task has bugs. |
| HasParents | Boolean | Indicates whether the task has parents. |
| Tags | String | List of tags associated with the task. |
| Teams | String | List of teams associated with the task. |