Translations

Release 1.0 - ...

Translations view:

Translations can be derived from. The translations view should reflect all translations:

SQL	Copy Code
SELECT c.Nr, c.Parent, c.Title AS Code, c.Body AS Replacement, ISNULL(c.CTSPecificInt1, 0) AS TranslationType, c.Description AS Notes, c.SortIndex, ISNULL(c.CTSpecificBit1, 0) AS Overridable FROM dbo.vwContent AS c INNER JOIN dbo.ContentTypes AS ct ON c.ContentType = ct.Nr WHERE (ct.Nr = 2) OR (ct.DerivedFrom = 2)

SQL

Copy Code

SELECT c.Nr, c.Parent, c.Title AS Code, c.Body AS Replacement,
    ISNULL(c.CTSPecificInt1, 0) AS TranslationType, c.Description AS Notes,
    c.SortIndex, ISNULL(c.CTSpecificBit1, 0) AS Overridable
FROM dbo.vwContent AS c
INNER JOIN dbo.ContentTypes AS ct ON c.ContentType = ct.Nr
WHERE (ct.Nr = 2) OR (ct.DerivedFrom = 2)

Advanced