Follow

Custom SQL Filters

Because the date field also contains a time value, you have to add lower and upper boundaries.

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.note
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".
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
ID IN (SELECT ID FROM Sentences GROUP BY ID HAVING COUNT(*) <= 1)
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk