TicketProperties

Query the TicketProperties view.

Columns


Name	Type	Description
TicketId	Bigint	Ticket Id of the ticket property.
Subject	String	Subject of the ticket property.
Status	String	Status of the ticket property.
Priority	String	Priority of the ticket property.
Source	String	Source of the ticket property.
TicketType	String	Ticket type of the ticket property.
AssociationType	String	Association type of the ticket property.
AgentName	String	Agent name of the ticket property.
ResolutionDueBy	Datetime	Resolution Due By of the ticket property.
FirstAssignedDate	Datetime	First Assigned Date of the ticket property.
CreatedDate	Datetime	Created Date of the ticket property.
FirstResponseDueBy	Datetime	First Response Due By of the ticket property.
AgentReplyCount	Bigint	Agent Reply Count of the ticket property.
CustomerReplyCount	Bigint	Customer Reply Count of the ticket property.
LastUpdatedDate	Datetime	Last Updated Date of the ticket property.
ResolvedDate	Datetime	Resolved Date of the ticket property.
ClosedDate	Datetime	Closed Date of the ticket property.
FirstResponseDate	Datetime	First Response Date of the ticket property.
ReferenceNumber	String	Reference Number of the ticket property.
RequesterName	String	Requester name of the ticket property.
RequesterEmail	String	Requester email of the ticket property.
RequesterType	String	Requester type of the ticket property.
CompanyName	String	Company name of the ticket property.
GroupName	String	Group name of the ticket property.
AssignType	String	Assign type of the ticket property.
Product	String	Product of the ticket property.
FirstAssignedGroup	String	First Assigned Group of the ticket property.
LastUpdatedAgent	String	Last Updated Agent of the ticket property.
FirstAssignedAgent	String	First Assigned Agent of the ticket property.
AgentEmail	String	Agent email of the ticket property.
TicketsAge	Bigint	Tickets Age of the ticket property.
FirstResponseGroup	String	First Response Group of the ticket property.

JDBC Driver for Freshdesk

TicketProperties

Columns