freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_vendor
Table: freshservice_ticket_task
Allows for obtaining information on tasks associated to a specific Ticket.
You MUST specify a ticket_id
in the WHERE
or JOIN
clause.
Examples
List all tasks on a specific Ticket
select *from freshservice_ticket_taskwhere ticket_id = 2010101010;
Schema for freshservice_ticket_task
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
agent_id | bigint | ID of the agent to whom the task is assigned. | |
closed_at | timestamp with time zone | Timestamp when the task was closed. | |
created_at | timestamp with time zone | Timestamp when the task was created. | |
description | text | Description of the task. | |
due_date | timestamp with time zone | Timestamp that denotes the due date of the task. | |
group_id | bigint | ID of the group to which the task is assigned. | |
id | bigint | ID of the task. | |
notify_before | bigint | Time in seconds before which notification is sent prior to due date. | |
status | bigint | Status of the task. | |
status_desc | text | Description of the task status. | |
ticket_id | bigint | = | ID of the ticket the task belongs to. |
title | text | Title of the task. | |
updated_at | timestamp with time zone | Timestamp when the task was updated. |