Pages: How to identify pages with translation in invariant culture that don't have translation in another language using SQL query? - Progress Community

Loading

Skip to Main Content

Pages: How to identify pages with translation in invariant culture that don't have translation in another language using SQL query?

This article includes a SQL query to get all pages with translation in invariant culture and without translation in other language.

Jan 27, 2025
Knowledge

Title

Pages: How to identify pages with translation in invariant culture that don't have translation in another language using SQL query?

URL Name

pages-how-to-identify-pages-with-translation-in-invariant-that-doesn-t-have-translation-in-another-language-using-sql-query

Article Number

000275802

Environment

Product: Sitefinity Version: 13.3, 14.4, 15.0, 15.1, 15.2 OS: All supported OS versions Database: All supported Microsoft SQL Server versions

Question/Problem Description

How to get all pages that has translation in invariant culture but doesn't have translation in another language using SQL query?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

The following query returns all pages with a translation in the invariant culture but missing translation in another culture:

Note: Change the "(language)" with the respective language code (e.g Arabic - title_ar)

DECLARE @SfPagesList TABLE (page NVARCHAR(500))

INSERT INTO @SfPagesList VALUES ('Pages'), ('Backend'), ('Sitefinity'), ('A/B testing console'), ('Personalization console')

SELECT * FROM sf_page_node
WHERE title_ NOT LIKE '%$Resources:%'
AND title_ NOT IN (SELECT * FROM @SfPagesList)
AND title_ IS NOT NULL
AND title_(language) IS NULL

Workaround

Notes

Keyword Phrase

Last Modified Date

1/27/2025 3:52 PM

Sitefinity Bugs & IssuesSitefinity CloudSitefinity General DiscussionsSitefinity UpgradingSitefinity Front & Back-End Development

Drop Files

Upload FilesOr drop files

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Loading

Pages: How to identify pages with translation in invariant culture that don't have translation in another language using SQL query? - Progress Community