Votes
Create, Delete and Query the Votes in Zendesk. Votes represents positive and negative opinions of users about articles, article comments, posts or post comments.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM Votes WHERE UserId = '19128124956177' SELECT * FROM Votes WHERE ArticleId = '19206579478289' SELECT * FROM Votes WHERE Locale = 'en-us' AND ArticleId = '19206579478289' SELECT * FROM Votes WHERE ArticleId = '19206579478289' AND CommentId = '19244072685969' SELECT * FROM Votes WHERE Locale = 'en-us' AND ArticleId = '19206579478289' AND CommentId = '19244072685969' SELECT * FROM Votes WHERE PostId = '19206579516945' SELECT * FROM Votes WHERE PostId = '19206579516945' AND CommentId = '19244379733521'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
Insert
The Value field is required to insert. Allowed for End-users.
To create an vote for a given Article:
INSERT INTO Votes (ArticleId, Value) VALUES ('19206579478289', 1)
To create an vote for a given Article comment:
INSERT INTO Votes (ArticleId, CommentId, Value) VALUES ('19206579478289', '19244072685969', 1)
To create an vote for a given Post:
INSERT INTO Votes (PostId, Value) VALUES ('19206579516945', -1)
To create an vote for a given Post Comment:
INSERT INTO Votes (PostId, CommentId, Value) VALUES ('19206579516945', '19244379733521', -1)
Delete
You must specify the Id of the Vote to delete it. Allowed for Agents and End-users.
DELETE FROM Votes WHERE Id = '19243214837905'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Automatically assigned when the vote is created. | |
UserId | Long | True |
Users.Id |
The id of the user who cast this vote. |
ItemId | Long | True |
The id of the item for which this vote was cast. | |
ItemType | String | True |
The type of the item. Can be Article, Comment, Post or PostComment. | |
Value | Integer | False |
The value of the vote. Specify 1 for up and -1 for down. 使用できる値は次のとおりです。1, -1 | |
Url | String | True |
The ids of user segments that have edit privileges. For insertion and updation provide these values separated by semicolon. | |
CreatedAt | Datetime | True |
The time at which the vote was created. | |
UpdatedAt | Datetime | True |
The time at which the vote was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Locale | String |
The locale value. |
ArticleId | Long |
The Id of the Article. |
CommentId | Long |
The Id of the Article Comment or Post Comment. |
PostId | Long |
The Id of the Post. |