Translations
Returns translations for Help Center content. 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 provider.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 columns 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. This operation is allowed for logged-in users with the "Help Center manager" role, or agents (for 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 Update operations. This operation is allowed for logged-in users with the "agent" role (for articles only).
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. This operation is allowed for logged-in users with the "agent" role.
DELETE FROM Translations WHERE Id = '19207534349457'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The Id 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 |
The HTML body of the translation. Empty by default. | |
| Draft | Boolean | False |
Indicates whether the translation is a draft. 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 |
Indicates whether the translation is outdated. False by default. | |
| SourceType | String | True |
The type of the item that has this translation, such as article, section, or category. | |
| Url | String | True |
The API URL of the translation. | |
| CreatedAt | Datetime | True |
The date and time when the translation was created. | |
| UpdatedAt | Datetime | True |
The date and time when the translation was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ArticleId | Long |
The Id of the associated article. |
| SectionId | Long |
The Id of the associated section. |
| CategoryId | Long |
The Id of the associated category. |