YourSolvedTicketsThisWeek
Query your solved tickets this week
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Automatically assigned when the ticket is created. | |
| Subject | String | The value of the subject field for this ticket. When used in WHERE clause: The text in the ticket's subject | |
| RawSubject | String | The dynamic content placeholder, if present, or the subject value, if not. | |
| Description | String | The first comment on the ticket. When used in WHERE clause: The text in the ticket's description and comments | |
| Type | String | The type of this ticket. Possible values: problem, incident, question or task. | |
| Priority | String | The urgency with which the ticket should be addressed. Possible values: urgent, high, normal, low. | |
| Status | String | The state of the ticket. Possible values: new, open, pending, hold, solved, closed. | |
| Recipient | String | The original recipient e-mail address of the ticket. | |
| HasIncidents | Boolean | Is true of this ticket has been marked as a problem, false otherwise. | |
| DueAt | Datetime | If this is a ticket of type task it has a due date. Due date format uses ISO 8601 format. | |
| RequesterId | Long |
Users.Id | The user who requested this ticket. |
| SubmitterId | Long |
Users.Id | The user who submitted the ticket. The submitter always becomes the author of the first comment on the ticket. |
| AssigneeId | Long |
Users.Id | The agent currently assigned to the ticket. |
| OrganizationId | String | The organization of the requester. You can only specify the ID of an organization associated with the requester. | |
| GroupId | Long |
Groups.Id | The ID of the group, to which the Ticket is assigned. |
| CollaboratorIds | String | The ids of users currently cc-ed on the ticket. | |
| FollowerIds | String | Agents currently following the ticket. | |
| ForumTopicId | Long |
Topics.Id | The topic this ticket originated from, if any. |
| ProblemId | Integer |
Tickets.Id | For tickets of type incident, the ID of the problem the incident is linked to. |
| ExternalId | String | An id you can use to link Zendesk Support tickets to local records. | |
| FollowupIds | String | Closed tickets only. The ids of the followups created from this ticket. | |
| TicketFormId | Long |
TicketForms.Id | Enterprise only. The id of the ticket form to render for the ticket. |
| BrandId | Long |
Brands.Id | Enterprise only. The id of the brand this ticket is associated with. |
| Tags | String | The array of tags applied to this ticket. | |
| ViaChannel | String | This tells you how the ticket or event was created. Examples: web, mobile, rule, system. | |
| ViaSource | String | The ticket's source. | |
| SatisfactionRating | String | The satisfaction rating of the ticket, if it exists, or the state of satisfaction, 'offered' or 'unoffered'. | |
| SharingAgreementIds | String | The ids of the sharing agreements used for this ticket. | |
| AllowChannelback | Boolean | Is false if channelback is disabled, true otherwise. Only applicable for channels framework ticket. | |
| IsPublic | Boolean | Is true if any comments are public, false otherwise. | |
| CreatedAt | Datetime | When this record was created. | |
| UpdatedAt | Datetime | When this record last got updated. | |
| Url | String | The API url of this ticket. | |
| Assignee | String | The assigned agent or other entity. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number | |
| GroupName | String | The name of the group, to which the Ticket is assigned. | |
| Requester | String | The ticket requester. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number. | |
| Submitter | String | The ticket submitter. This may be different than the requester if the ticket was submitted by an agent on behalf of the requester. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number. . | |
| Brand | String | Search for a specific Brand on a ticket. | |
| Commenter | String | People who have added comments to tickets. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number. | |
| Cc | String | People who have been CC'd on tickets. You can specify 'none', 'me', user name (full name or partial), email address, user ID, or phone number. | |
| AllowAttachments | Boolean | Permission for agents to add add attachments to a comment. Defaults to true. | |
| CustomStatusId | Long | The custom ticket status id of the ticket. | |
| EmailCcIds | String | An array of objects that represent agent or end users email CCs to add or delete from the ticket. | |
| FromMessagingChannel | Boolean | If true, the ticket's via type is a messaging channel. | |
| ResultType | String | Result type. |