Custom SQL Filters – Atril Solutions

Following are some SQL Statements you can use to filter segments in a Translation Memory, or in the Translation Memory export wizard.

Name	SQL (Structured Query Language)
Export records belonging to project 1234567 from translation memory.	PrjID=1234567
Export records of subject "123" from translation memory.	Subject='123'
Export records of client "987" from translation memory.	Client='987'
Export records of client "987" and subject "123" from translation memory.	Client='987' AND Subject='123'
Export translation memory records entered on or after December 21, 2014.	ID IN (SELECT ID FROM Sentences WHERE Datestamp >= #12/21/2014#)
Export translation memory records entered on December 21, 2014. Because the date field also contains a time value, you have to add lower and upper boundaries.	ID IN (SELECT ID FROM Sentences WHERE Datestamp >= #12/21/2014# AND Datestamp < #12/22/2014#)
Export translation memory records entered between January 1, 2015, and January 31, 2015	ID IN (SELECT ID FROM Sentences WHERE Datestamp >= #1/1/2015# AND Datestamp < #2/1/2015#)
Export translation memory records entered on December 21, 2014, between 12 pm and 3 pm	ID IN (SELECT ID FROM Sentences WHERE Datestamp >= #12/21/2014 11:00# AND Datestamp < #12/21/2014 15:00#)
Export all translation memory records in U.S. English starting with "ABC". For a list of language and sublanguage codes, see this article.	ID IN (SELECT ID FROM Sentences WHERE Lang = 9 AND SubLang = 1 AND Sentence LIKE 'ABC*')
Export all translation memory records from User "Joe"	ID IN (SELECT ID FROM Sentences WHERE UserNick = 'Joe')
Sentences with no translations The following can be used to identify any sentences that do not have any translations at all.	ID IN (SELECT ID FROM Sentences GROUP BY ID HAVING COUNT(*) <= 1)
Segments marked as duplicate This is equivalent to clicking on Duplicates Only when you have a Translation Memory open in Déjà Vu. However, this can be used to filter segments during export. This will only work if you have instructed Déjà Vu to mark segments in the Translation Memory as duplicate.	ID IN (SELECT ID FROM Sentences WHERE Duplicate <> 0)

Comments