ADO.NET Provider for Zendesk

Build 26.0.9655

YourSolvedTicketsThisWeek

Returns the current user's solved tickets for the current week.

Columns

Name Type References Description
Id [KEY] Integer The Id of the ticket, automatically assigned when it 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 Indicates whether this ticket has been marked as a problem.
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 Id of the user who requested this ticket.
SubmitterId Long

Users.Id

The Id of 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

Organizations.Id

The Id of the requester's organization. Only an organization associated with the requester can be specified.
GroupId Long

Groups.Id

The Id of the group to which the ticket is assigned.
CollaboratorIds String The Ids of users currently CC'd 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 used to link 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 Indicates 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 Indicates whether channelback is enabled. Only applicable for channels framework tickets.
IsPublic Boolean Indicates whether any comments are public.
CreatedAt Datetime The date and time when this ticket was created.
UpdatedAt Datetime The date and time when this ticket was last updated.
Url String The API URL of this ticket.
Assignee String The assigned agent or other entity. Possible values: '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. Possible values: 'none', 'me', user name (full name or partial), email address, user Id, or phone number.
Submitter String The ticket submitter. May be different from the requester if the ticket was submitted by an agent on behalf of the requester. Possible values: 'none', 'me', user name (full name or partial), email address, user Id, or phone number.
Brand String The brand associated with the ticket.
Commenter String People who have added comments to tickets. Possible values: '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. Possible values: 'none', 'me', user name (full name or partial), email address, user Id, or phone number.
AllowAttachments Boolean Indicates whether agents can add attachments to a comment. Defaults to true.
CustomStatusId Long The Id of the custom ticket status.
EmailCcIds String An array of objects that represent agent or end users email CCs to add or delete from the ticket.
FromMessagingChannel Boolean Indicates whether the ticket's via type is a messaging channel.
ResultType String The type of the search result.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655