Freshdesk Field Reference


Fields

IDTypeNameDescriptionReport
agents__availableBOOLEANagents.availableagents.availableagents
agents__available_sinceTEXTagents.available_sinceagents.available_sinceagents
agents__contactOBJECTagents.contactagents.contactagents
agents__created_atTEXTagents.created_atagents.created_atagents
agents__idNUMERICagents.idagents.idagents
agents__last_active_atTEXTagents.last_active_atagents.last_active_atagents
agents__occasionalBOOLEANagents.occasionalagents.occasionalagents
agents__signatureTEXTagents.signatureagents.signatureagents
agents__ticket_scopeTEXTagents.ticket_scopeagents.ticket_scopeagents
agents__typeTEXTagents.typeagents.typeagents
agents__updated_atTEXTagents.updated_atagents.updated_atagents
business_hours__created_atTEXTbusiness_hours.created_atbusiness_hours.created_atbusiness_hours
business_hours__descriptionTEXTbusiness_hours.descriptionbusiness_hours.descriptionbusiness_hours
business_hours__idNUMERICbusiness_hours.idbusiness_hours.idbusiness_hours
business_hours__is_defaultBOOLEANbusiness_hours.is_defaultbusiness_hours.is_defaultbusiness_hours
business_hours__nameTEXTbusiness_hours.namebusiness_hours.namebusiness_hours
business_hours__time_zoneTEXTbusiness_hours.time_zonebusiness_hours.time_zonebusiness_hours
business_hours__updated_atTEXTbusiness_hours.updated_atbusiness_hours.updated_atbusiness_hours
business_hours__working_hoursOBJECTbusiness_hours.working_hoursbusiness_hours.working_hoursbusiness_hours
canned_response_folders__created_atTEXTcanned_response_folders.created_atcanned_response_folders.created_atcanned_response_folders
canned_response_folders__idNUMERICcanned_response_folders.idcanned_response_folders.idcanned_response_folders
canned_response_folders__nameTEXTcanned_response_folders.namecanned_response_folders.namecanned_response_folders
canned_response_folders__personalBOOLEANcanned_response_folders.personalcanned_response_folders.personalcanned_response_folders
canned_response_folders__responses_countNUMERICcanned_response_folders.responses_countcanned_response_folders.responses_countcanned_response_folders
canned_response_folders__updated_atTEXTcanned_response_folders.updated_atcanned_response_folders.updated_atcanned_response_folders
canned_responses__attachmentsOBJECTcanned_responses.attachmentscanned_responses.attachmentscanned_responses
canned_responses__contentTEXTcanned_responses.contentcanned_responses.contentcanned_responses
canned_responses__content_htmlTEXTcanned_responses.content_htmlcanned_responses.content_htmlcanned_responses
canned_responses__created_atTEXTcanned_responses.created_atcanned_responses.created_atcanned_responses
canned_responses__folder_idNUMERICcanned_responses.folder_idcanned_responses.folder_idcanned_responses
canned_responses__idNUMERICcanned_responses.idcanned_responses.idcanned_responses
canned_responses__titleTEXTcanned_responses.titlecanned_responses.titlecanned_responses
canned_responses__updated_atTEXTcanned_responses.updated_atcanned_responses.updated_atcanned_responses
companies__account_tierTEXTcompanies.account_tiercompanies.account_tiercompanies
companies__created_atTEXTcompanies.created_atcompanies.created_atcompanies
companies__custom_fieldsOBJECTcompanies.custom_fieldscompanies.custom_fieldscompanies
companies__descriptionTEXTcompanies.descriptioncompanies.descriptioncompanies
companies__domainsOBJECTcompanies.domainscompanies.domainscompanies
companies__health_scoreTEXTcompanies.health_scorecompanies.health_scorecompanies
companies__idTEXTcompanies.idcompanies.idcompanies
companies__industryTEXTcompanies.industrycompanies.industrycompanies
companies__nameTEXTcompanies.namecompanies.namecompanies
companies__noteTEXTcompanies.notecompanies.notecompanies
companies__renewal_dateDATEcompanies.renewal_datecompanies.renewal_datecompanies
companies__updated_atTEXTcompanies.updated_atcompanies.updated_atcompanies
contacts__activeBOOLEANcontacts.activecontacts.activecontacts
contacts__addressTEXTcontacts.addresscontacts.addresscontacts
contacts__company_idNUMERICcontacts.company_idcontacts.company_idcontacts
contacts__created_atTEXTcontacts.created_atcontacts.created_atcontacts
contacts__csat_ratingNUMERICcontacts.csat_ratingcontacts.csat_ratingcontacts
contacts__custom_fieldsOBJECTcontacts.custom_fieldscontacts.custom_fieldscontacts
contacts__descriptionTEXTcontacts.descriptioncontacts.descriptioncontacts
contacts__emailTEXTcontacts.emailcontacts.emailcontacts
contacts__facebook_idNUMERICcontacts.facebook_idcontacts.facebook_idcontacts
contacts__idNUMERICcontacts.idcontacts.idcontacts
contacts__job_titleTEXTcontacts.job_titlecontacts.job_titlecontacts
contacts__languageTEXTcontacts.languagecontacts.languagecontacts
contacts__mobileTEXTcontacts.mobilecontacts.mobilecontacts
contacts__nameTEXTcontacts.namecontacts.namecontacts
contacts__phoneTEXTcontacts.phonecontacts.phonecontacts
contacts__preferred_sourceTEXTcontacts.preferred_sourcecontacts.preferred_sourcecontacts
contacts__time_zoneTEXTcontacts.time_zonecontacts.time_zonecontacts
contacts__twitter_idTEXTcontacts.twitter_idcontacts.twitter_idcontacts
contacts__unique_external_idTEXTcontacts.unique_external_idcontacts.unique_external_idcontacts
contacts__updated_atTEXTcontacts.updated_atcontacts.updated_atcontacts
conversations__attachmentsOBJECTconversations.attachmentsconversations.attachmentsconversations
conversations__bcc_emailsOBJECTconversations.bcc_emailsconversations.bcc_emailsconversations
conversations__bodyTEXTconversations.bodyconversations.bodyconversations
conversations__body_textTEXTconversations.body_textconversations.body_textconversations
conversations__categoryNUMERICconversations.categoryconversations.categoryconversations
conversations__cc_emailsOBJECTconversations.cc_emailsconversations.cc_emailsconversations
conversations__created_atTEXTconversations.created_atconversations.created_atconversations
conversations__from_emailTEXTconversations.from_emailconversations.from_emailconversations
conversations__idNUMERICconversations.idconversations.idconversations
conversations__incomingBOOLEANconversations.incomingconversations.incomingconversations
conversations__privateBOOLEANconversations.privateconversations.privateconversations
conversations__sourceNUMERICconversations.sourceconversations.sourceconversations
conversations__source_additional_infoOBJECTconversations.source_additional_infoconversations.source_additional_infoconversations
conversations__support_emailTEXTconversations.support_emailconversations.support_emailconversations
conversations__ticket_idNUMERICconversations.ticket_idconversations.ticket_idconversations
conversations__to_emailsOBJECTconversations.to_emailsconversations.to_emailsconversations
conversations__updated_atTEXTconversations.updated_atconversations.updated_atconversations
conversations__user_idNUMERICconversations.user_idconversations.user_idconversations
datasourceTEXTData SourceThe name of the Windsor connector returning the row
discussion_categories__created_atTEXTdiscussion_categories.created_atdiscussion_categories.created_atdiscussion_categories
discussion_categories__descriptionTEXTdiscussion_categories.descriptiondiscussion_categories.descriptiondiscussion_categories
discussion_categories__idNUMERICdiscussion_categories.iddiscussion_categories.iddiscussion_categories
discussion_categories__nameTEXTdiscussion_categories.namediscussion_categories.namediscussion_categories
discussion_categories__updated_atTEXTdiscussion_categories.updated_atdiscussion_categories.updated_atdiscussion_categories
discussion_comments__answerBOOLEANdiscussion_comments.answerdiscussion_comments.answerdiscussion_comments
discussion_comments__bodyTEXTdiscussion_comments.bodydiscussion_comments.bodydiscussion_comments
discussion_comments__created_atTEXTdiscussion_comments.created_atdiscussion_comments.created_atdiscussion_comments
discussion_comments__forum_idNUMERICdiscussion_comments.forum_iddiscussion_comments.forum_iddiscussion_comments
discussion_comments__idNUMERICdiscussion_comments.iddiscussion_comments.iddiscussion_comments
discussion_comments__publishedBOOLEANdiscussion_comments.publisheddiscussion_comments.publisheddiscussion_comments
discussion_comments__spamBOOLEANdiscussion_comments.spamdiscussion_comments.spamdiscussion_comments
discussion_comments__topic_idNUMERICdiscussion_comments.topic_iddiscussion_comments.topic_iddiscussion_comments
discussion_comments__trashBOOLEANdiscussion_comments.trashdiscussion_comments.trashdiscussion_comments
discussion_comments__updated_atTEXTdiscussion_comments.updated_atdiscussion_comments.updated_atdiscussion_comments
discussion_comments__user_idNUMERICdiscussion_comments.user_iddiscussion_comments.user_iddiscussion_comments
discussion_forums__company_idsOBJECTdiscussion_forums.company_idsdiscussion_forums.company_idsdiscussion_forums
discussion_forums__descriptionTEXTdiscussion_forums.descriptiondiscussion_forums.descriptiondiscussion_forums
discussion_forums__forum_category_idNUMERICdiscussion_forums.forum_category_iddiscussion_forums.forum_category_iddiscussion_forums
discussion_forums__forum_typeNUMERICdiscussion_forums.forum_typediscussion_forums.forum_typediscussion_forums
discussion_forums__forum_visibilityNUMERICdiscussion_forums.forum_visibilitydiscussion_forums.forum_visibilitydiscussion_forums
discussion_forums__idNUMERICdiscussion_forums.iddiscussion_forums.iddiscussion_forums
discussion_forums__nameTEXTdiscussion_forums.namediscussion_forums.namediscussion_forums
discussion_forums__positionNUMERICdiscussion_forums.positiondiscussion_forums.positiondiscussion_forums
discussion_forums__posts_countNUMERICdiscussion_forums.posts_countdiscussion_forums.posts_countdiscussion_forums
discussion_forums__topics_countNUMERICdiscussion_forums.topics_countdiscussion_forums.topics_countdiscussion_forums
discussion_topics__created_atTEXTdiscussion_topics.created_atdiscussion_topics.created_atdiscussion_topics
discussion_topics__forum_idNUMERICdiscussion_topics.forum_iddiscussion_topics.forum_iddiscussion_topics
discussion_topics__hitsNUMERICdiscussion_topics.hitsdiscussion_topics.hitsdiscussion_topics
discussion_topics__idNUMERICdiscussion_topics.iddiscussion_topics.iddiscussion_topics
discussion_topics__lockedBOOLEANdiscussion_topics.lockeddiscussion_topics.lockeddiscussion_topics
discussion_topics__merged_topic_idNUMERICdiscussion_topics.merged_topic_iddiscussion_topics.merged_topic_iddiscussion_topics
discussion_topics__messageTEXTdiscussion_topics.messagediscussion_topics.messagediscussion_topics
discussion_topics__posts_countNUMERICdiscussion_topics.posts_countdiscussion_topics.posts_countdiscussion_topics
discussion_topics__replied_byNUMERICdiscussion_topics.replied_bydiscussion_topics.replied_bydiscussion_topics
discussion_topics__stamp_typeNUMERICdiscussion_topics.stamp_typediscussion_topics.stamp_typediscussion_topics
discussion_topics__stickyBOOLEANdiscussion_topics.stickydiscussion_topics.stickydiscussion_topics
discussion_topics__titleTEXTdiscussion_topics.titlediscussion_topics.titlediscussion_topics
discussion_topics__updated_atTEXTdiscussion_topics.updated_atdiscussion_topics.updated_atdiscussion_topics
discussion_topics__user_idNUMERICdiscussion_topics.user_iddiscussion_topics.user_iddiscussion_topics
discussion_topics__user_votesNUMERICdiscussion_topics.user_votesdiscussion_topics.user_votesdiscussion_topics
email_configs__activeBOOLEANemail_configs.activeemail_configs.activeemail_configs
email_configs__created_atTEXTemail_configs.created_atemail_configs.created_atemail_configs
email_configs__group_idNUMERICemail_configs.group_idemail_configs.group_idemail_configs
email_configs__idNUMERICemail_configs.idemail_configs.idemail_configs
email_configs__nameTEXTemail_configs.nameemail_configs.nameemail_configs
email_configs__primary_roleBOOLEANemail_configs.primary_roleemail_configs.primary_roleemail_configs
email_configs__product_idNUMERICemail_configs.product_idemail_configs.product_idemail_configs
email_configs__reply_emailTEXTemail_configs.reply_emailemail_configs.reply_emailemail_configs
email_configs__to_emailTEXTemail_configs.to_emailemail_configs.to_emailemail_configs
email_configs__updated_atTEXTemail_configs.updated_atemail_configs.updated_atemail_configs
email_mailboxes__access_typeTEXTemail_mailboxes.access_typeemail_mailboxes.access_typeemail_mailboxes
email_mailboxes__authenticationTEXTemail_mailboxes.authenticationemail_mailboxes.authenticationemail_mailboxes
email_mailboxes__custom_mailboxTEXTemail_mailboxes.custom_mailboxemail_mailboxes.custom_mailboxemail_mailboxes
email_mailboxes__default_reply_emailBOOLEANemail_mailboxes.default_reply_emailemail_mailboxes.default_reply_emailemail_mailboxes
email_mailboxes__delete_from_serverBOOLEANemail_mailboxes.delete_from_serveremail_mailboxes.delete_from_serveremail_mailboxes
email_mailboxes__group_idNUMERICemail_mailboxes.group_idemail_mailboxes.group_idemail_mailboxes
email_mailboxes__idNUMERICemail_mailboxes.idemail_mailboxes.idemail_mailboxes
email_mailboxes__incomingTEXTemail_mailboxes.incomingemail_mailboxes.incomingemail_mailboxes
email_mailboxes__mail_serverTEXTemail_mailboxes.mail_serveremail_mailboxes.mail_serveremail_mailboxes
email_mailboxes__mailbox_typeTEXTemail_mailboxes.mailbox_typeemail_mailboxes.mailbox_typeemail_mailboxes
email_mailboxes__nameTEXTemail_mailboxes.nameemail_mailboxes.nameemail_mailboxes
email_mailboxes__passwordTEXTemail_mailboxes.passwordemail_mailboxes.passwordemail_mailboxes
email_mailboxes__portNUMERICemail_mailboxes.portemail_mailboxes.portemail_mailboxes
email_mailboxes__product_idNUMERICemail_mailboxes.product_idemail_mailboxes.product_idemail_mailboxes
email_mailboxes__support_emailTEXTemail_mailboxes.support_emailemail_mailboxes.support_emailemail_mailboxes
email_mailboxes__use_sslBOOLEANemail_mailboxes.use_sslemail_mailboxes.use_sslemail_mailboxes
email_mailboxes__usernameTEXTemail_mailboxes.usernameemail_mailboxes.usernameemail_mailboxes
groups__auto_ticket_assignNUMERICgroups.auto_ticket_assigngroups.auto_ticket_assigngroups
groups__business_hour_idNUMERICgroups.business_hour_idgroups.business_hour_idgroups
groups__created_atTEXTgroups.created_atgroups.created_atgroups
groups__descriptionTEXTgroups.descriptiongroups.descriptiongroups
groups__escalate_toNUMERICgroups.escalate_togroups.escalate_togroups
groups__group_typeTEXTgroups.group_typegroups.group_typegroups
groups__idNUMERICgroups.idgroups.idgroups
groups__nameTEXTgroups.namegroups.namegroups
groups__unassigned_forTEXTgroups.unassigned_forgroups.unassigned_forgroups
groups__updated_atTEXTgroups.updated_atgroups.updated_atgroups
products__created_atTEXTproducts.created_atproducts.created_atproducts
products__descriptionTEXTproducts.descriptionproducts.descriptionproducts
products__idNUMERICproducts.idproducts.idproducts
products__nameTEXTproducts.nameproducts.nameproducts
products__updated_atTEXTproducts.updated_atproducts.updated_atproducts
roles__created_atTEXTroles.created_atroles.created_atroles
roles__defaultBOOLEANroles.defaultroles.defaultroles
roles__descriptionTEXTroles.descriptionroles.descriptionroles
roles__idNUMERICroles.idroles.idroles
roles__nameTEXTroles.nameroles.nameroles
roles__updated_atTEXTroles.updated_atroles.updated_atroles
satisfaction_ratings__agent_idNUMERICsatisfaction_ratings.agent_idsatisfaction_ratings.agent_idsatisfaction_ratings
satisfaction_ratings__created_atTEXTsatisfaction_ratings.created_atsatisfaction_ratings.created_atsatisfaction_ratings
satisfaction_ratings__feedbackTEXTsatisfaction_ratings.feedbacksatisfaction_ratings.feedbacksatisfaction_ratings
satisfaction_ratings__group_idNUMERICsatisfaction_ratings.group_idsatisfaction_ratings.group_idsatisfaction_ratings
satisfaction_ratings__idNUMERICsatisfaction_ratings.idsatisfaction_ratings.idsatisfaction_ratings
satisfaction_ratings__ratingsOBJECTsatisfaction_ratings.ratingssatisfaction_ratings.ratingssatisfaction_ratings
satisfaction_ratings__survey_idNUMERICsatisfaction_ratings.survey_idsatisfaction_ratings.survey_idsatisfaction_ratings
satisfaction_ratings__ticket_idNUMERICsatisfaction_ratings.ticket_idsatisfaction_ratings.ticket_idsatisfaction_ratings
satisfaction_ratings__updated_atTEXTsatisfaction_ratings.updated_atsatisfaction_ratings.updated_atsatisfaction_ratings
satisfaction_ratings__user_idNUMERICsatisfaction_ratings.user_idsatisfaction_ratings.user_idsatisfaction_ratings
scenario_automations__actionsOBJECTscenario_automations.actionsscenario_automations.actionsscenario_automations
scenario_automations__created_atTEXTscenario_automations.created_atscenario_automations.created_atscenario_automations
scenario_automations__descriptionTEXTscenario_automations.descriptionscenario_automations.descriptionscenario_automations
scenario_automations__idNUMERICscenario_automations.idscenario_automations.idscenario_automations
scenario_automations__nameTEXTscenario_automations.namescenario_automations.namescenario_automations
scenario_automations__privateBOOLEANscenario_automations.privatescenario_automations.privatescenario_automations
scenario_automations__updated_atTEXTscenario_automations.updated_atscenario_automations.updated_atscenario_automations
settings__portal_languagesOBJECTsettings.portal_languagessettings.portal_languagessettings
settings__primary_languageTEXTsettings.primary_languagesettings.primary_languagesettings
settings__supported_languagesOBJECTsettings.supported_languagessettings.supported_languagessettings
skills__agentsOBJECTskills.agentsskills.agentsskills
skills__conditionsOBJECTskills.conditionsskills.conditionsskills
skills__created_atTEXTskills.created_atskills.created_atskills
skills__idNUMERICskills.idskills.idskills
skills__match_typeTEXTskills.match_typeskills.match_typeskills
skills__nameTEXTskills.nameskills.nameskills
skills__rankNUMERICskills.rankskills.rankskills
skills__updated_atTEXTskills.updated_atskills.updated_atskills
sla_policies__activeBOOLEANsla_policies.activesla_policies.activesla_policies
sla_policies__applicable_toOBJECTsla_policies.applicable_tosla_policies.applicable_tosla_policies
sla_policies__descriptionTEXTsla_policies.descriptionsla_policies.descriptionsla_policies
sla_policies__escalationOBJECTsla_policies.escalationsla_policies.escalationsla_policies
sla_policies__idNUMERICsla_policies.idsla_policies.idsla_policies
sla_policies__is_defaultBOOLEANsla_policies.is_defaultsla_policies.is_defaultsla_policies
sla_policies__nameTEXTsla_policies.namesla_policies.namesla_policies
sla_policies__positionNUMERICsla_policies.positionsla_policies.positionsla_policies
sla_policies__sla_targetOBJECTsla_policies.sla_targetsla_policies.sla_targetsla_policies
solution_articles__agent_idNUMERICsolution_articles.agent_idsolution_articles.agent_idsolution_articles
solution_articles__category_idNUMERICsolution_articles.category_idsolution_articles.category_idsolution_articles
solution_articles__created_atTEXTsolution_articles.created_atsolution_articles.created_atsolution_articles
solution_articles__descriptionTEXTsolution_articles.descriptionsolution_articles.descriptionsolution_articles
solution_articles__description_textTEXTsolution_articles.description_textsolution_articles.description_textsolution_articles
solution_articles__folder_idNUMERICsolution_articles.folder_idsolution_articles.folder_idsolution_articles
solution_articles__hitsNUMERICsolution_articles.hitssolution_articles.hitssolution_articles
solution_articles__idNUMERICsolution_articles.idsolution_articles.idsolution_articles
solution_articles__seo_dataOBJECTsolution_articles.seo_datasolution_articles.seo_datasolution_articles
solution_articles__statusNUMERICsolution_articles.statussolution_articles.statussolution_articles
solution_articles__tagsOBJECTsolution_articles.tagssolution_articles.tagssolution_articles
solution_articles__thumbs_downNUMERICsolution_articles.thumbs_downsolution_articles.thumbs_downsolution_articles
solution_articles__thumbs_upNUMERICsolution_articles.thumbs_upsolution_articles.thumbs_upsolution_articles
solution_articles__titleTEXTsolution_articles.titlesolution_articles.titlesolution_articles
solution_articles__updated_atTEXTsolution_articles.updated_atsolution_articles.updated_atsolution_articles
solution_categories__created_atTEXTsolution_categories.created_atsolution_categories.created_atsolution_categories
solution_categories__descriptionTEXTsolution_categories.descriptionsolution_categories.descriptionsolution_categories
solution_categories__idNUMERICsolution_categories.idsolution_categories.idsolution_categories
solution_categories__nameTEXTsolution_categories.namesolution_categories.namesolution_categories
solution_categories__updated_atTEXTsolution_categories.updated_atsolution_categories.updated_atsolution_categories
solution_categories__visible_in_portalsOBJECTsolution_categories.visible_in_portalssolution_categories.visible_in_portalssolution_categories
solution_folders__company_idsOBJECTsolution_folders.company_idssolution_folders.company_idssolution_folders
solution_folders__company_segment_idsOBJECTsolution_folders.company_segment_idssolution_folders.company_segment_idssolution_folders
solution_folders__contact_segment_idsOBJECTsolution_folders.contact_segment_idssolution_folders.contact_segment_idssolution_folders
solution_folders__created_atTEXTsolution_folders.created_atsolution_folders.created_atsolution_folders
solution_folders__descriptionTEXTsolution_folders.descriptionsolution_folders.descriptionsolution_folders
solution_folders__idNUMERICsolution_folders.idsolution_folders.idsolution_folders
solution_folders__nameTEXTsolution_folders.namesolution_folders.namesolution_folders
solution_folders__updated_atTEXTsolution_folders.updated_atsolution_folders.updated_atsolution_folders
solution_folders__visibilityNUMERICsolution_folders.visibilitysolution_folders.visibilitysolution_folders
sourceTEXTSourceThe name of the Windsor connector returning the row
surveys__activeBOOLEANsurveys.activesurveys.activesurveys
surveys__created_atTEXTsurveys.created_atsurveys.created_atsurveys
surveys__idNUMERICsurveys.idsurveys.idsurveys
surveys__questionsOBJECTsurveys.questionssurveys.questionssurveys
surveys__titleTEXTsurveys.titlesurveys.titlesurveys
surveys__updated_atTEXTsurveys.updated_atsurveys.updated_atsurveys
ticket_fields__choicesOBJECTticket_fields.choicesticket_fields.choicesticket_fields
ticket_fields__created_atTEXTticket_fields.created_atticket_fields.created_atticket_fields
ticket_fields__customers_can_editBOOLEANticket_fields.customers_can_editticket_fields.customers_can_editticket_fields
ticket_fields__defaultBOOLEANticket_fields.defaultticket_fields.defaultticket_fields
ticket_fields__dependent_fieldsTEXTticket_fields.dependent_fieldsticket_fields.dependent_fieldsticket_fields
ticket_fields__descriptionTEXTticket_fields.descriptionticket_fields.descriptionticket_fields
ticket_fields__displayed_to_customersBOOLEANticket_fields.displayed_to_customersticket_fields.displayed_to_customersticket_fields
ticket_fields__field_update_in_progressBOOLEANticket_fields.field_update_in_progressticket_fields.field_update_in_progressticket_fields
ticket_fields__idNUMERICticket_fields.idticket_fields.idticket_fields
ticket_fields__is_fsmBOOLEANticket_fields.is_fsmticket_fields.is_fsmticket_fields
ticket_fields__labelTEXTticket_fields.labelticket_fields.labelticket_fields
ticket_fields__label_for_customersTEXTticket_fields.label_for_customersticket_fields.label_for_customersticket_fields
ticket_fields__nameTEXTticket_fields.nameticket_fields.nameticket_fields
ticket_fields__portal_ccBOOLEANticket_fields.portal_ccticket_fields.portal_ccticket_fields
ticket_fields__portal_cc_toTEXTticket_fields.portal_cc_toticket_fields.portal_cc_toticket_fields
ticket_fields__positionNUMERICticket_fields.positionticket_fields.positionticket_fields
ticket_fields__required_for_agentsBOOLEANticket_fields.required_for_agentsticket_fields.required_for_agentsticket_fields
ticket_fields__required_for_closureBOOLEANticket_fields.required_for_closureticket_fields.required_for_closureticket_fields
ticket_fields__required_for_customersBOOLEANticket_fields.required_for_customersticket_fields.required_for_customersticket_fields
ticket_fields__typeTEXTticket_fields.typeticket_fields.typeticket_fields
ticket_fields__updated_atTEXTticket_fields.updated_atticket_fields.updated_atticket_fields
tickets__associated_tickets_countNUMERICtickets.associated_tickets_counttickets.associated_tickets_counttickets
tickets__association_typeNUMERICtickets.association_typetickets.association_typetickets
tickets__cc_emailsOBJECTtickets.cc_emailstickets.cc_emailstickets
tickets__company_idNUMERICtickets.company_idtickets.company_idtickets
tickets__created_atTEXTtickets.created_attickets.created_attickets
tickets__custom_fieldsOBJECTtickets.custom_fieldstickets.custom_fieldstickets
tickets__descriptionTEXTtickets.descriptiontickets.descriptiontickets
tickets__description_textTEXTtickets.description_texttickets.description_texttickets
tickets__due_byTEXTtickets.due_bytickets.due_bytickets
tickets__email_config_idNUMERICtickets.email_config_idtickets.email_config_idtickets
tickets__fr_due_byTEXTtickets.fr_due_bytickets.fr_due_bytickets
tickets__fr_escalatedBOOLEANtickets.fr_escalatedtickets.fr_escalatedtickets
tickets__fwd_emailsOBJECTtickets.fwd_emailstickets.fwd_emailstickets
tickets__group_idNUMERICtickets.group_idtickets.group_idtickets
tickets__idNUMERICtickets.idtickets.idtickets
tickets__is_escalatedBOOLEANtickets.is_escalatedtickets.is_escalatedtickets
tickets__nr_due_byTEXTtickets.nr_due_bytickets.nr_due_bytickets
tickets__nr_escalatedBOOLEANtickets.nr_escalatedtickets.nr_escalatedtickets
tickets__priorityNUMERICtickets.prioritytickets.prioritytickets
tickets__product_idNUMERICtickets.product_idtickets.product_idtickets
tickets__reply_cc_emailsOBJECTtickets.reply_cc_emailstickets.reply_cc_emailstickets
tickets__requesterOBJECTtickets.requestertickets.requestertickets
tickets__requester_idNUMERICtickets.requester_idtickets.requester_idtickets
tickets__responder_idNUMERICtickets.responder_idtickets.responder_idtickets
tickets__sourceNUMERICtickets.sourcetickets.sourcetickets
tickets__spamBOOLEANtickets.spamtickets.spamtickets
tickets__statsOBJECTtickets.statstickets.statstickets
tickets__statusNUMERICtickets.statustickets.statustickets
tickets__subjectTEXTtickets.subjecttickets.subjecttickets
tickets__tagsOBJECTtickets.tagstickets.tagstickets
tickets__ticket_cc_emailsOBJECTtickets.ticket_cc_emailstickets.ticket_cc_emailstickets
tickets__to_emailsOBJECTtickets.to_emailstickets.to_emailstickets
tickets__typeTEXTtickets.typetickets.typetickets
tickets__updated_atTEXTtickets.updated_attickets.updated_attickets
time_entries__agent_idNUMERICtime_entries.agent_idtime_entries.agent_idtime_entries
time_entries__billableBOOLEANtime_entries.billabletime_entries.billabletime_entries
time_entries__company_idNUMERICtime_entries.company_idtime_entries.company_idtime_entries
time_entries__created_atDATEtime_entries.created_attime_entries.created_attime_entries
time_entries__executed_atDATEtime_entries.executed_attime_entries.executed_attime_entries
time_entries__idTEXTtime_entries.idtime_entries.idtime_entries
time_entries__noteTEXTtime_entries.notetime_entries.notetime_entries
time_entries__start_timeTEXTtime_entries.start_timetime_entries.start_timetime_entries
time_entries__ticket_idNUMERICtime_entries.ticket_idtime_entries.ticket_idtime_entries
time_entries__time_spentTEXTtime_entries.time_spenttime_entries.time_spenttime_entries
time_entries__timer_runningBOOLEANtime_entries.timer_runningtime_entries.timer_runningtime_entries
time_entries__updated_atTEXTtime_entries.updated_attime_entries.updated_attime_entries
todayDATETodayToday's date