Windsor brings all your Freshdesk data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Freshdesk Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| agents__available | BOOLEAN | agents.available | agents.available | agents |
| agents__available_since | TEXT | agents.available_since | agents.available_since | agents |
| agents__contact | OBJECT | agents.contact | agents.contact | agents |
| agents__created_at | TEXT | agents.created_at | agents.created_at | agents |
| agents__id | NUMERIC | agents.id | agents.id | agents |
| agents__last_active_at | TEXT | agents.last_active_at | agents.last_active_at | agents |
| agents__occasional | BOOLEAN | agents.occasional | agents.occasional | agents |
| agents__signature | TEXT | agents.signature | agents.signature | agents |
| agents__ticket_scope | TEXT | agents.ticket_scope | agents.ticket_scope | agents |
| agents__type | TEXT | agents.type | agents.type | agents |
| agents__updated_at | TEXT | agents.updated_at | agents.updated_at | agents |
| business_hours__created_at | TEXT | business_hours.created_at | business_hours.created_at | business_hours |
| business_hours__description | TEXT | business_hours.description | business_hours.description | business_hours |
| business_hours__id | NUMERIC | business_hours.id | business_hours.id | business_hours |
| business_hours__is_default | BOOLEAN | business_hours.is_default | business_hours.is_default | business_hours |
| business_hours__name | TEXT | business_hours.name | business_hours.name | business_hours |
| business_hours__time_zone | TEXT | business_hours.time_zone | business_hours.time_zone | business_hours |
| business_hours__updated_at | TEXT | business_hours.updated_at | business_hours.updated_at | business_hours |
| business_hours__working_hours | OBJECT | business_hours.working_hours | business_hours.working_hours | business_hours |
| canned_response_folders__created_at | TEXT | canned_response_folders.created_at | canned_response_folders.created_at | canned_response_folders |
| canned_response_folders__id | NUMERIC | canned_response_folders.id | canned_response_folders.id | canned_response_folders |
| canned_response_folders__name | TEXT | canned_response_folders.name | canned_response_folders.name | canned_response_folders |
| canned_response_folders__personal | BOOLEAN | canned_response_folders.personal | canned_response_folders.personal | canned_response_folders |
| canned_response_folders__responses_count | NUMERIC | canned_response_folders.responses_count | canned_response_folders.responses_count | canned_response_folders |
| canned_response_folders__updated_at | TEXT | canned_response_folders.updated_at | canned_response_folders.updated_at | canned_response_folders |
| canned_responses__attachments | OBJECT | canned_responses.attachments | canned_responses.attachments | canned_responses |
| canned_responses__content | TEXT | canned_responses.content | canned_responses.content | canned_responses |
| canned_responses__content_html | TEXT | canned_responses.content_html | canned_responses.content_html | canned_responses |
| canned_responses__created_at | TEXT | canned_responses.created_at | canned_responses.created_at | canned_responses |
| canned_responses__folder_id | NUMERIC | canned_responses.folder_id | canned_responses.folder_id | canned_responses |
| canned_responses__id | NUMERIC | canned_responses.id | canned_responses.id | canned_responses |
| canned_responses__title | TEXT | canned_responses.title | canned_responses.title | canned_responses |
| canned_responses__updated_at | TEXT | canned_responses.updated_at | canned_responses.updated_at | canned_responses |
| companies__account_tier | TEXT | companies.account_tier | companies.account_tier | companies |
| companies__created_at | TEXT | companies.created_at | companies.created_at | companies |
| companies__custom_fields | OBJECT | companies.custom_fields | companies.custom_fields | companies |
| companies__description | TEXT | companies.description | companies.description | companies |
| companies__domains | OBJECT | companies.domains | companies.domains | companies |
| companies__health_score | TEXT | companies.health_score | companies.health_score | companies |
| companies__id | TEXT | companies.id | companies.id | companies |
| companies__industry | TEXT | companies.industry | companies.industry | companies |
| companies__name | TEXT | companies.name | companies.name | companies |
| companies__note | TEXT | companies.note | companies.note | companies |
| companies__renewal_date | DATE | companies.renewal_date | companies.renewal_date | companies |
| companies__updated_at | TEXT | companies.updated_at | companies.updated_at | companies |
| contacts__active | BOOLEAN | contacts.active | contacts.active | contacts |
| contacts__address | TEXT | contacts.address | contacts.address | contacts |
| contacts__company_id | NUMERIC | contacts.company_id | contacts.company_id | contacts |
| contacts__created_at | TEXT | contacts.created_at | contacts.created_at | contacts |
| contacts__csat_rating | NUMERIC | contacts.csat_rating | contacts.csat_rating | contacts |
| contacts__custom_fields | OBJECT | contacts.custom_fields | contacts.custom_fields | contacts |
| contacts__description | TEXT | contacts.description | contacts.description | contacts |
| contacts__email | TEXT | contacts.email | contacts.email | contacts |
| contacts__facebook_id | NUMERIC | contacts.facebook_id | contacts.facebook_id | contacts |
| contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
| contacts__job_title | TEXT | contacts.job_title | contacts.job_title | contacts |
| contacts__language | TEXT | contacts.language | contacts.language | contacts |
| contacts__mobile | TEXT | contacts.mobile | contacts.mobile | contacts |
| contacts__name | TEXT | contacts.name | contacts.name | contacts |
| contacts__phone | TEXT | contacts.phone | contacts.phone | contacts |
| contacts__preferred_source | TEXT | contacts.preferred_source | contacts.preferred_source | contacts |
| contacts__time_zone | TEXT | contacts.time_zone | contacts.time_zone | contacts |
| contacts__twitter_id | TEXT | contacts.twitter_id | contacts.twitter_id | contacts |
| contacts__unique_external_id | TEXT | contacts.unique_external_id | contacts.unique_external_id | contacts |
| contacts__updated_at | TEXT | contacts.updated_at | contacts.updated_at | contacts |
| conversations__attachments | OBJECT | conversations.attachments | conversations.attachments | conversations |
| conversations__bcc_emails | OBJECT | conversations.bcc_emails | conversations.bcc_emails | conversations |
| conversations__body | TEXT | conversations.body | conversations.body | conversations |
| conversations__body_text | TEXT | conversations.body_text | conversations.body_text | conversations |
| conversations__category | NUMERIC | conversations.category | conversations.category | conversations |
| conversations__cc_emails | OBJECT | conversations.cc_emails | conversations.cc_emails | conversations |
| conversations__created_at | TEXT | conversations.created_at | conversations.created_at | conversations |
| conversations__from_email | TEXT | conversations.from_email | conversations.from_email | conversations |
| conversations__id | NUMERIC | conversations.id | conversations.id | conversations |
| conversations__incoming | BOOLEAN | conversations.incoming | conversations.incoming | conversations |
| conversations__private | BOOLEAN | conversations.private | conversations.private | conversations |
| conversations__source | NUMERIC | conversations.source | conversations.source | conversations |
| conversations__source_additional_info | OBJECT | conversations.source_additional_info | conversations.source_additional_info | conversations |
| conversations__support_email | TEXT | conversations.support_email | conversations.support_email | conversations |
| conversations__ticket_id | NUMERIC | conversations.ticket_id | conversations.ticket_id | conversations |
| conversations__to_emails | OBJECT | conversations.to_emails | conversations.to_emails | conversations |
| conversations__updated_at | TEXT | conversations.updated_at | conversations.updated_at | conversations |
| conversations__user_id | NUMERIC | conversations.user_id | conversations.user_id | conversations |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| discussion_categories__created_at | TEXT | discussion_categories.created_at | discussion_categories.created_at | discussion_categories |
| discussion_categories__description | TEXT | discussion_categories.description | discussion_categories.description | discussion_categories |
| discussion_categories__id | NUMERIC | discussion_categories.id | discussion_categories.id | discussion_categories |
| discussion_categories__name | TEXT | discussion_categories.name | discussion_categories.name | discussion_categories |
| discussion_categories__updated_at | TEXT | discussion_categories.updated_at | discussion_categories.updated_at | discussion_categories |
| discussion_comments__answer | BOOLEAN | discussion_comments.answer | discussion_comments.answer | discussion_comments |
| discussion_comments__body | TEXT | discussion_comments.body | discussion_comments.body | discussion_comments |
| discussion_comments__created_at | TEXT | discussion_comments.created_at | discussion_comments.created_at | discussion_comments |
| discussion_comments__forum_id | NUMERIC | discussion_comments.forum_id | discussion_comments.forum_id | discussion_comments |
| discussion_comments__id | NUMERIC | discussion_comments.id | discussion_comments.id | discussion_comments |
| discussion_comments__published | BOOLEAN | discussion_comments.published | discussion_comments.published | discussion_comments |
| discussion_comments__spam | BOOLEAN | discussion_comments.spam | discussion_comments.spam | discussion_comments |
| discussion_comments__topic_id | NUMERIC | discussion_comments.topic_id | discussion_comments.topic_id | discussion_comments |
| discussion_comments__trash | BOOLEAN | discussion_comments.trash | discussion_comments.trash | discussion_comments |
| discussion_comments__updated_at | TEXT | discussion_comments.updated_at | discussion_comments.updated_at | discussion_comments |
| discussion_comments__user_id | NUMERIC | discussion_comments.user_id | discussion_comments.user_id | discussion_comments |
| discussion_forums__company_ids | OBJECT | discussion_forums.company_ids | discussion_forums.company_ids | discussion_forums |
| discussion_forums__description | TEXT | discussion_forums.description | discussion_forums.description | discussion_forums |
| discussion_forums__forum_category_id | NUMERIC | discussion_forums.forum_category_id | discussion_forums.forum_category_id | discussion_forums |
| discussion_forums__forum_type | NUMERIC | discussion_forums.forum_type | discussion_forums.forum_type | discussion_forums |
| discussion_forums__forum_visibility | NUMERIC | discussion_forums.forum_visibility | discussion_forums.forum_visibility | discussion_forums |
| discussion_forums__id | NUMERIC | discussion_forums.id | discussion_forums.id | discussion_forums |
| discussion_forums__name | TEXT | discussion_forums.name | discussion_forums.name | discussion_forums |
| discussion_forums__position | NUMERIC | discussion_forums.position | discussion_forums.position | discussion_forums |
| discussion_forums__posts_count | NUMERIC | discussion_forums.posts_count | discussion_forums.posts_count | discussion_forums |
| discussion_forums__topics_count | NUMERIC | discussion_forums.topics_count | discussion_forums.topics_count | discussion_forums |
| discussion_topics__created_at | TEXT | discussion_topics.created_at | discussion_topics.created_at | discussion_topics |
| discussion_topics__forum_id | NUMERIC | discussion_topics.forum_id | discussion_topics.forum_id | discussion_topics |
| discussion_topics__hits | NUMERIC | discussion_topics.hits | discussion_topics.hits | discussion_topics |
| discussion_topics__id | NUMERIC | discussion_topics.id | discussion_topics.id | discussion_topics |
| discussion_topics__locked | BOOLEAN | discussion_topics.locked | discussion_topics.locked | discussion_topics |
| discussion_topics__merged_topic_id | NUMERIC | discussion_topics.merged_topic_id | discussion_topics.merged_topic_id | discussion_topics |
| discussion_topics__message | TEXT | discussion_topics.message | discussion_topics.message | discussion_topics |
| discussion_topics__posts_count | NUMERIC | discussion_topics.posts_count | discussion_topics.posts_count | discussion_topics |
| discussion_topics__replied_by | NUMERIC | discussion_topics.replied_by | discussion_topics.replied_by | discussion_topics |
| discussion_topics__stamp_type | NUMERIC | discussion_topics.stamp_type | discussion_topics.stamp_type | discussion_topics |
| discussion_topics__sticky | BOOLEAN | discussion_topics.sticky | discussion_topics.sticky | discussion_topics |
| discussion_topics__title | TEXT | discussion_topics.title | discussion_topics.title | discussion_topics |
| discussion_topics__updated_at | TEXT | discussion_topics.updated_at | discussion_topics.updated_at | discussion_topics |
| discussion_topics__user_id | NUMERIC | discussion_topics.user_id | discussion_topics.user_id | discussion_topics |
| discussion_topics__user_votes | NUMERIC | discussion_topics.user_votes | discussion_topics.user_votes | discussion_topics |
| email_configs__active | BOOLEAN | email_configs.active | email_configs.active | email_configs |
| email_configs__created_at | TEXT | email_configs.created_at | email_configs.created_at | email_configs |
| email_configs__group_id | NUMERIC | email_configs.group_id | email_configs.group_id | email_configs |
| email_configs__id | NUMERIC | email_configs.id | email_configs.id | email_configs |
| email_configs__name | TEXT | email_configs.name | email_configs.name | email_configs |
| email_configs__primary_role | BOOLEAN | email_configs.primary_role | email_configs.primary_role | email_configs |
| email_configs__product_id | NUMERIC | email_configs.product_id | email_configs.product_id | email_configs |
| email_configs__reply_email | TEXT | email_configs.reply_email | email_configs.reply_email | email_configs |
| email_configs__to_email | TEXT | email_configs.to_email | email_configs.to_email | email_configs |
| email_configs__updated_at | TEXT | email_configs.updated_at | email_configs.updated_at | email_configs |
| email_mailboxes__access_type | TEXT | email_mailboxes.access_type | email_mailboxes.access_type | email_mailboxes |
| email_mailboxes__authentication | TEXT | email_mailboxes.authentication | email_mailboxes.authentication | email_mailboxes |
| email_mailboxes__custom_mailbox | TEXT | email_mailboxes.custom_mailbox | email_mailboxes.custom_mailbox | email_mailboxes |
| email_mailboxes__default_reply_email | BOOLEAN | email_mailboxes.default_reply_email | email_mailboxes.default_reply_email | email_mailboxes |
| email_mailboxes__delete_from_server | BOOLEAN | email_mailboxes.delete_from_server | email_mailboxes.delete_from_server | email_mailboxes |
| email_mailboxes__group_id | NUMERIC | email_mailboxes.group_id | email_mailboxes.group_id | email_mailboxes |
| email_mailboxes__id | NUMERIC | email_mailboxes.id | email_mailboxes.id | email_mailboxes |
| email_mailboxes__incoming | TEXT | email_mailboxes.incoming | email_mailboxes.incoming | email_mailboxes |
| email_mailboxes__mail_server | TEXT | email_mailboxes.mail_server | email_mailboxes.mail_server | email_mailboxes |
| email_mailboxes__mailbox_type | TEXT | email_mailboxes.mailbox_type | email_mailboxes.mailbox_type | email_mailboxes |
| email_mailboxes__name | TEXT | email_mailboxes.name | email_mailboxes.name | email_mailboxes |
| email_mailboxes__password | TEXT | email_mailboxes.password | email_mailboxes.password | email_mailboxes |
| email_mailboxes__port | NUMERIC | email_mailboxes.port | email_mailboxes.port | email_mailboxes |
| email_mailboxes__product_id | NUMERIC | email_mailboxes.product_id | email_mailboxes.product_id | email_mailboxes |
| email_mailboxes__support_email | TEXT | email_mailboxes.support_email | email_mailboxes.support_email | email_mailboxes |
| email_mailboxes__use_ssl | BOOLEAN | email_mailboxes.use_ssl | email_mailboxes.use_ssl | email_mailboxes |
| email_mailboxes__username | TEXT | email_mailboxes.username | email_mailboxes.username | email_mailboxes |
| groups__auto_ticket_assign | NUMERIC | groups.auto_ticket_assign | groups.auto_ticket_assign | groups |
| groups__business_hour_id | NUMERIC | groups.business_hour_id | groups.business_hour_id | groups |
| groups__created_at | TEXT | groups.created_at | groups.created_at | groups |
| groups__description | TEXT | groups.description | groups.description | groups |
| groups__escalate_to | NUMERIC | groups.escalate_to | groups.escalate_to | groups |
| groups__group_type | TEXT | groups.group_type | groups.group_type | groups |
| groups__id | NUMERIC | groups.id | groups.id | groups |
| groups__name | TEXT | groups.name | groups.name | groups |
| groups__unassigned_for | TEXT | groups.unassigned_for | groups.unassigned_for | groups |
| groups__updated_at | TEXT | groups.updated_at | groups.updated_at | groups |
| products__created_at | TEXT | products.created_at | products.created_at | products |
| products__description | TEXT | products.description | products.description | products |
| products__id | NUMERIC | products.id | products.id | products |
| products__name | TEXT | products.name | products.name | products |
| products__updated_at | TEXT | products.updated_at | products.updated_at | products |
| roles__created_at | TEXT | roles.created_at | roles.created_at | roles |
| roles__default | BOOLEAN | roles.default | roles.default | roles |
| roles__description | TEXT | roles.description | roles.description | roles |
| roles__id | NUMERIC | roles.id | roles.id | roles |
| roles__name | TEXT | roles.name | roles.name | roles |
| roles__updated_at | TEXT | roles.updated_at | roles.updated_at | roles |
| satisfaction_ratings__agent_id | NUMERIC | satisfaction_ratings.agent_id | satisfaction_ratings.agent_id | satisfaction_ratings |
| satisfaction_ratings__created_at | TEXT | satisfaction_ratings.created_at | satisfaction_ratings.created_at | satisfaction_ratings |
| satisfaction_ratings__feedback | TEXT | satisfaction_ratings.feedback | satisfaction_ratings.feedback | satisfaction_ratings |
| satisfaction_ratings__group_id | NUMERIC | satisfaction_ratings.group_id | satisfaction_ratings.group_id | satisfaction_ratings |
| satisfaction_ratings__id | NUMERIC | satisfaction_ratings.id | satisfaction_ratings.id | satisfaction_ratings |
| satisfaction_ratings__ratings | OBJECT | satisfaction_ratings.ratings | satisfaction_ratings.ratings | satisfaction_ratings |
| satisfaction_ratings__survey_id | NUMERIC | satisfaction_ratings.survey_id | satisfaction_ratings.survey_id | satisfaction_ratings |
| satisfaction_ratings__ticket_id | NUMERIC | satisfaction_ratings.ticket_id | satisfaction_ratings.ticket_id | satisfaction_ratings |
| satisfaction_ratings__updated_at | TEXT | satisfaction_ratings.updated_at | satisfaction_ratings.updated_at | satisfaction_ratings |
| satisfaction_ratings__user_id | NUMERIC | satisfaction_ratings.user_id | satisfaction_ratings.user_id | satisfaction_ratings |
| scenario_automations__actions | OBJECT | scenario_automations.actions | scenario_automations.actions | scenario_automations |
| scenario_automations__created_at | TEXT | scenario_automations.created_at | scenario_automations.created_at | scenario_automations |
| scenario_automations__description | TEXT | scenario_automations.description | scenario_automations.description | scenario_automations |
| scenario_automations__id | NUMERIC | scenario_automations.id | scenario_automations.id | scenario_automations |
| scenario_automations__name | TEXT | scenario_automations.name | scenario_automations.name | scenario_automations |
| scenario_automations__private | BOOLEAN | scenario_automations.private | scenario_automations.private | scenario_automations |
| scenario_automations__updated_at | TEXT | scenario_automations.updated_at | scenario_automations.updated_at | scenario_automations |
| settings__portal_languages | OBJECT | settings.portal_languages | settings.portal_languages | settings |
| settings__primary_language | TEXT | settings.primary_language | settings.primary_language | settings |
| settings__supported_languages | OBJECT | settings.supported_languages | settings.supported_languages | settings |
| skills__agents | OBJECT | skills.agents | skills.agents | skills |
| skills__conditions | OBJECT | skills.conditions | skills.conditions | skills |
| skills__created_at | TEXT | skills.created_at | skills.created_at | skills |
| skills__id | NUMERIC | skills.id | skills.id | skills |
| skills__match_type | TEXT | skills.match_type | skills.match_type | skills |
| skills__name | TEXT | skills.name | skills.name | skills |
| skills__rank | NUMERIC | skills.rank | skills.rank | skills |
| skills__updated_at | TEXT | skills.updated_at | skills.updated_at | skills |
| sla_policies__active | BOOLEAN | sla_policies.active | sla_policies.active | sla_policies |
| sla_policies__applicable_to | OBJECT | sla_policies.applicable_to | sla_policies.applicable_to | sla_policies |
| sla_policies__description | TEXT | sla_policies.description | sla_policies.description | sla_policies |
| sla_policies__escalation | OBJECT | sla_policies.escalation | sla_policies.escalation | sla_policies |
| sla_policies__id | NUMERIC | sla_policies.id | sla_policies.id | sla_policies |
| sla_policies__is_default | BOOLEAN | sla_policies.is_default | sla_policies.is_default | sla_policies |
| sla_policies__name | TEXT | sla_policies.name | sla_policies.name | sla_policies |
| sla_policies__position | NUMERIC | sla_policies.position | sla_policies.position | sla_policies |
| sla_policies__sla_target | OBJECT | sla_policies.sla_target | sla_policies.sla_target | sla_policies |
| solution_articles__agent_id | NUMERIC | solution_articles.agent_id | solution_articles.agent_id | solution_articles |
| solution_articles__category_id | NUMERIC | solution_articles.category_id | solution_articles.category_id | solution_articles |
| solution_articles__created_at | TEXT | solution_articles.created_at | solution_articles.created_at | solution_articles |
| solution_articles__description | TEXT | solution_articles.description | solution_articles.description | solution_articles |
| solution_articles__description_text | TEXT | solution_articles.description_text | solution_articles.description_text | solution_articles |
| solution_articles__folder_id | NUMERIC | solution_articles.folder_id | solution_articles.folder_id | solution_articles |
| solution_articles__hits | NUMERIC | solution_articles.hits | solution_articles.hits | solution_articles |
| solution_articles__id | NUMERIC | solution_articles.id | solution_articles.id | solution_articles |
| solution_articles__seo_data | OBJECT | solution_articles.seo_data | solution_articles.seo_data | solution_articles |
| solution_articles__status | NUMERIC | solution_articles.status | solution_articles.status | solution_articles |
| solution_articles__tags | OBJECT | solution_articles.tags | solution_articles.tags | solution_articles |
| solution_articles__thumbs_down | NUMERIC | solution_articles.thumbs_down | solution_articles.thumbs_down | solution_articles |
| solution_articles__thumbs_up | NUMERIC | solution_articles.thumbs_up | solution_articles.thumbs_up | solution_articles |
| solution_articles__title | TEXT | solution_articles.title | solution_articles.title | solution_articles |
| solution_articles__updated_at | TEXT | solution_articles.updated_at | solution_articles.updated_at | solution_articles |
| solution_categories__created_at | TEXT | solution_categories.created_at | solution_categories.created_at | solution_categories |
| solution_categories__description | TEXT | solution_categories.description | solution_categories.description | solution_categories |
| solution_categories__id | NUMERIC | solution_categories.id | solution_categories.id | solution_categories |
| solution_categories__name | TEXT | solution_categories.name | solution_categories.name | solution_categories |
| solution_categories__updated_at | TEXT | solution_categories.updated_at | solution_categories.updated_at | solution_categories |
| solution_categories__visible_in_portals | OBJECT | solution_categories.visible_in_portals | solution_categories.visible_in_portals | solution_categories |
| solution_folders__company_ids | OBJECT | solution_folders.company_ids | solution_folders.company_ids | solution_folders |
| solution_folders__company_segment_ids | OBJECT | solution_folders.company_segment_ids | solution_folders.company_segment_ids | solution_folders |
| solution_folders__contact_segment_ids | OBJECT | solution_folders.contact_segment_ids | solution_folders.contact_segment_ids | solution_folders |
| solution_folders__created_at | TEXT | solution_folders.created_at | solution_folders.created_at | solution_folders |
| solution_folders__description | TEXT | solution_folders.description | solution_folders.description | solution_folders |
| solution_folders__id | NUMERIC | solution_folders.id | solution_folders.id | solution_folders |
| solution_folders__name | TEXT | solution_folders.name | solution_folders.name | solution_folders |
| solution_folders__updated_at | TEXT | solution_folders.updated_at | solution_folders.updated_at | solution_folders |
| solution_folders__visibility | NUMERIC | solution_folders.visibility | solution_folders.visibility | solution_folders |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| surveys__active | BOOLEAN | surveys.active | surveys.active | surveys |
| surveys__created_at | TEXT | surveys.created_at | surveys.created_at | surveys |
| surveys__id | NUMERIC | surveys.id | surveys.id | surveys |
| surveys__questions | OBJECT | surveys.questions | surveys.questions | surveys |
| surveys__title | TEXT | surveys.title | surveys.title | surveys |
| surveys__updated_at | TEXT | surveys.updated_at | surveys.updated_at | surveys |
| ticket_fields__choices | OBJECT | ticket_fields.choices | ticket_fields.choices | ticket_fields |
| ticket_fields__created_at | TEXT | ticket_fields.created_at | ticket_fields.created_at | ticket_fields |
| ticket_fields__customers_can_edit | BOOLEAN | ticket_fields.customers_can_edit | ticket_fields.customers_can_edit | ticket_fields |
| ticket_fields__default | BOOLEAN | ticket_fields.default | ticket_fields.default | ticket_fields |
| ticket_fields__dependent_fields | TEXT | ticket_fields.dependent_fields | ticket_fields.dependent_fields | ticket_fields |
| ticket_fields__description | TEXT | ticket_fields.description | ticket_fields.description | ticket_fields |
| ticket_fields__displayed_to_customers | BOOLEAN | ticket_fields.displayed_to_customers | ticket_fields.displayed_to_customers | ticket_fields |
| ticket_fields__field_update_in_progress | BOOLEAN | ticket_fields.field_update_in_progress | ticket_fields.field_update_in_progress | ticket_fields |
| ticket_fields__id | NUMERIC | ticket_fields.id | ticket_fields.id | ticket_fields |
| ticket_fields__is_fsm | BOOLEAN | ticket_fields.is_fsm | ticket_fields.is_fsm | ticket_fields |
| ticket_fields__label | TEXT | ticket_fields.label | ticket_fields.label | ticket_fields |
| ticket_fields__label_for_customers | TEXT | ticket_fields.label_for_customers | ticket_fields.label_for_customers | ticket_fields |
| ticket_fields__name | TEXT | ticket_fields.name | ticket_fields.name | ticket_fields |
| ticket_fields__portal_cc | BOOLEAN | ticket_fields.portal_cc | ticket_fields.portal_cc | ticket_fields |
| ticket_fields__portal_cc_to | TEXT | ticket_fields.portal_cc_to | ticket_fields.portal_cc_to | ticket_fields |
| ticket_fields__position | NUMERIC | ticket_fields.position | ticket_fields.position | ticket_fields |
| ticket_fields__required_for_agents | BOOLEAN | ticket_fields.required_for_agents | ticket_fields.required_for_agents | ticket_fields |
| ticket_fields__required_for_closure | BOOLEAN | ticket_fields.required_for_closure | ticket_fields.required_for_closure | ticket_fields |
| ticket_fields__required_for_customers | BOOLEAN | ticket_fields.required_for_customers | ticket_fields.required_for_customers | ticket_fields |
| ticket_fields__type | TEXT | ticket_fields.type | ticket_fields.type | ticket_fields |
| ticket_fields__updated_at | TEXT | ticket_fields.updated_at | ticket_fields.updated_at | ticket_fields |
| tickets__associated_tickets_count | NUMERIC | tickets.associated_tickets_count | tickets.associated_tickets_count | tickets |
| tickets__association_type | NUMERIC | tickets.association_type | tickets.association_type | tickets |
| tickets__cc_emails | OBJECT | tickets.cc_emails | tickets.cc_emails | tickets |
| tickets__company_id | NUMERIC | tickets.company_id | tickets.company_id | tickets |
| tickets__created_at | TEXT | tickets.created_at | tickets.created_at | tickets |
| tickets__custom_fields | OBJECT | tickets.custom_fields | tickets.custom_fields | tickets |
| tickets__description | TEXT | tickets.description | tickets.description | tickets |
| tickets__description_text | TEXT | tickets.description_text | tickets.description_text | tickets |
| tickets__due_by | TEXT | tickets.due_by | tickets.due_by | tickets |
| tickets__email_config_id | NUMERIC | tickets.email_config_id | tickets.email_config_id | tickets |
| tickets__fr_due_by | TEXT | tickets.fr_due_by | tickets.fr_due_by | tickets |
| tickets__fr_escalated | BOOLEAN | tickets.fr_escalated | tickets.fr_escalated | tickets |
| tickets__fwd_emails | OBJECT | tickets.fwd_emails | tickets.fwd_emails | tickets |
| tickets__group_id | NUMERIC | tickets.group_id | tickets.group_id | tickets |
| tickets__id | NUMERIC | tickets.id | tickets.id | tickets |
| tickets__is_escalated | BOOLEAN | tickets.is_escalated | tickets.is_escalated | tickets |
| tickets__nr_due_by | TEXT | tickets.nr_due_by | tickets.nr_due_by | tickets |
| tickets__nr_escalated | BOOLEAN | tickets.nr_escalated | tickets.nr_escalated | tickets |
| tickets__priority | NUMERIC | tickets.priority | tickets.priority | tickets |
| tickets__product_id | NUMERIC | tickets.product_id | tickets.product_id | tickets |
| tickets__reply_cc_emails | OBJECT | tickets.reply_cc_emails | tickets.reply_cc_emails | tickets |
| tickets__requester | OBJECT | tickets.requester | tickets.requester | tickets |
| tickets__requester_id | NUMERIC | tickets.requester_id | tickets.requester_id | tickets |
| tickets__responder_id | NUMERIC | tickets.responder_id | tickets.responder_id | tickets |
| tickets__source | NUMERIC | tickets.source | tickets.source | tickets |
| tickets__spam | BOOLEAN | tickets.spam | tickets.spam | tickets |
| tickets__stats | OBJECT | tickets.stats | tickets.stats | tickets |
| tickets__status | NUMERIC | tickets.status | tickets.status | tickets |
| tickets__subject | TEXT | tickets.subject | tickets.subject | tickets |
| tickets__tags | OBJECT | tickets.tags | tickets.tags | tickets |
| tickets__ticket_cc_emails | OBJECT | tickets.ticket_cc_emails | tickets.ticket_cc_emails | tickets |
| tickets__to_emails | OBJECT | tickets.to_emails | tickets.to_emails | tickets |
| tickets__type | TEXT | tickets.type | tickets.type | tickets |
| tickets__updated_at | TEXT | tickets.updated_at | tickets.updated_at | tickets |
| time_entries__agent_id | NUMERIC | time_entries.agent_id | time_entries.agent_id | time_entries |
| time_entries__billable | BOOLEAN | time_entries.billable | time_entries.billable | time_entries |
| time_entries__company_id | NUMERIC | time_entries.company_id | time_entries.company_id | time_entries |
| time_entries__created_at | DATE | time_entries.created_at | time_entries.created_at | time_entries |
| time_entries__executed_at | DATE | time_entries.executed_at | time_entries.executed_at | time_entries |
| time_entries__id | TEXT | time_entries.id | time_entries.id | time_entries |
| time_entries__note | TEXT | time_entries.note | time_entries.note | time_entries |
| time_entries__start_time | TEXT | time_entries.start_time | time_entries.start_time | time_entries |
| time_entries__ticket_id | NUMERIC | time_entries.ticket_id | time_entries.ticket_id | time_entries |
| time_entries__time_spent | TEXT | time_entries.time_spent | time_entries.time_spent | time_entries |
| time_entries__timer_running | BOOLEAN | time_entries.timer_running | time_entries.timer_running | time_entries |
| time_entries__updated_at | TEXT | time_entries.updated_at | time_entries.updated_at | time_entries |
| today | DATE | Today | Today's date |