SatisfactionRatings
Returns satisfaction ratings submitted for resolved tickets.
Table-Specific Information
Select
The following query is processed server-side while other filters are processed client-side within the provider.
SELECT * FROM SatisfactionRatings WHERE Id = '123'
Insert
The TicketId and Score columns are required to insert. This insertion creates a Customer Satisfaction (CSAT) rating for solved tickets, or for tickets that were previously solved and then reopened. This operation is allowed for the end user who requested the ticket.
INSERT INTO SatisfactionRatings (TicketId, Score) VALUES ('12', 'good')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | False |
The Id automatically assigned to the satisfaction rating upon creation. | |
| TicketId | Integer | False |
Tickets.Id |
The Id of the ticket being rated. |
| Score | String | False |
The satisfaction rating score. When used in a filter it takes one of values: offered, unoffered, received, received_with_comment, received_without_comment, good, good_with_comment, good_without_comment, bad, bad_with_comment, bad_without_comment. | |
| Comment | String | False |
The comment received with this rating, if available. | |
| Reason | String | False |
The reason for a bad rating given by the requester in a follow-up question. Satisfaction reasons must be enabled. | |
| AssigneeId | Long | False |
Users.Id |
The Id of the agent assigned to the ticket at the time of rating. |
| GroupId | Long | False |
Groups.Id |
The Id of the group assigned to the ticket at the time of rating. |
| RequesterId | Long | False |
Users.Id |
The Id of the ticket requester submitting the rating. |
| CreatedAt | Datetime | False |
The time the satisfaction rating was created. | |
| UpdatedAt | Datetime | False |
The time the satisfaction rating was last updated. | |
| Url | String | False |
The API URL of this satisfaction rating. | |
| StartTime | Datetime | False |
The time of the oldest satisfaction rating. | |
| EndTime | Datetime | False |
The time of the most recent satisfaction rating. |