Table: clickup_task_assignee
Obtain information about assignees of a specific task.
You MUST specify a task_id
in the WHERE or JOIN clause.
Examples
Get assignees for a specific task
select id, username, email, color, profile_picture, initialsfrom clickup_task_assigneewhere task_id = '4g9milk'
List assignees for a selection of tasks
with some_tasks as ( select t.id from clickup_task t where t.list_id = 'xczx34' order by id desc limit 10)select id, username, email, color, profile_picture, initials, task_idfrom clickup_task_assignee a left join some_tasks on a.task_id = some_tasks.id
Schema for clickup_task_assignee
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
color | text | Color associated with the task assignee. | |
text | Email address for the task assignee. | ||
id | bigint | Identifier for the task assignee. | |
initials | text | The initials of the task assignee. | |
profile_picture | text | URL for the profile picture of the task assignee. | |
task_id | text | = | Unique identifier for the task. |
username | text | Username for the task assignee. |