Translations
Create, Update, Delete and Query the Translations in Zendesk. This table is deprecated, and is being replaced by the ArticleTranslations, CategoryTranslations, and SectionTranslations tables.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.Lists all translations for a given article, section, or category.
SELECT * FROM Translations WHERE ArticleId = '19206609899793' SELECT * FROM Translations WHERE ArticleId = '19206609899793' AND Locale = 'en-us' SELECT * FROM Translations WHERE SectionId = '19206579484689' SELECT * FROM Translations WHERE SectionId = '19206609899793' AND Locale = 'en-us' SELECT * FROM Translations WHERE CategoryId = '19206609899793' SELECT * FROM Translations WHERE CategoryId = '19206609899793' AND Locale = 'en-us'
Insert
To create a translation for a given source (such as an article, section, or category), the affiliated Ids of the source, as well as the Locale and Title fields are required. Any locale that you specify must be enabled for the current Help Center. The locale must also be different from that of any existing translation associated with the source object. Allowed for Help Center Managers and Agents (article translations only).
INSERT INTO Translations (ArticleId, Locale, Title) VALUES (19206609899793, 'hr', 'Article Translation')
INSERT INTO Translations (SectionId, Locale, Title) VALUES (19206579484689, 'hr', 'Section Translation')
INSERT INTO Translations (CategoryId, Locale, Title) VALUES (19206609883537, 'hr', 'Category Translation')
Update
You must specify the affiliated id of the source and Locale for UPDATEs. Allowed for Agents (only articles).
UPDATE Translations SET Title = 'Updated Article Translation' WHERE ArticleId = '19206609899793' AND Locale = 'hr'
UPDATE Translations SET Title = 'Section_Title_Updated' WHERE SectionId = '19206579484689' AND Locale = 'hr'
UPDATE Translations SET Title = 'Categoris Title' WHERE CategoryId = '19206609883537' AND Locale = 'hr'
Delete
You must specify the Id of the Translation to delete it. Allowed for agents.
DELETE FROM Translations WHERE Id = '19207534349457'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Automatically assigned when a translation is created. | |
| CreatedById | Long | True |
The id of the user who created the translation. | |
| UpdatedById | Long | True |
The id of the user who last updated the translation. | |
| SourceId | Long | True |
The id of the item that has this translation. | |
| Title | String | False |
The title of the translation. | |
| Body | String | False |
HTML body of the translation. Empty by default. | |
| Draft | Boolean | False |
True if the translation is a draft; false otherwise. False by default. | |
| HtmlUrl | String | True |
The url of the translation in Help Center. | |
| Locale | String | False |
The locale of the translation. | |
| Outdated | Boolean | False |
True if the translation is outdated; false otherwise. False by default. | |
| SourceType | String | True |
The type of the item that has this translation. Can be article, section, or category. | |
| Url | String | True |
The API url of the translation. | |
| CreatedAt | Datetime | True |
The time at which the translation was created. | |
| UpdatedAt | Datetime | True |
The time at which the translation was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ArticleId | Long |
Id of the associated article. |
| SectionId | Long |
Id of the associated section. |
| CategoryId | Long |
Id of the associated category. |