Technical forums » Déjà Vu support »
SQL for filtering date and user in DVX Professional's TM
Thread poster: Ioanna Merope Ippiotis
Ioanna Merope Ippiotis
Ioanna Merope Ippiotis
Italy
Local time: 16:47
Italian to English
+ ...
Jun 6, 2010

I'm writing an essay on content management in DVX and I was wondering if there are SQL expressions to filter TM content by date, user or client in DVX Professional. I can only find SQLs for deleting and updating TM content but not for simply viewing a subset of its content.


Thank you,

Merope Ippiotis
 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 17:47
English to Turkish
+ ...
A Tinkerer's Guide to SQL in DVX Jun 6, 2010

You can find many useful SQL commands in A Tinkerer's Guide to SQL in DVX http://www.necco.ca/dv/docs/A%20Tinkerer's%20Guide%20to%20SQL%20in%20DVX.pdf

Export/Display all sentence pairs where one or both sentences in the pair was entered by Tom.
ID IN (SELECT ID FROM Sentences WHERE UserNick ='Tom')


Export/Display al... See more
You can find many useful SQL commands in A Tinkerer's Guide to SQL in DVX http://www.necco.ca/dv/docs/A%20Tinkerer's%20Guide%20to%20SQL%20in%20DVX.pdf

Export/Display all sentence pairs where one or both sentences in the pair was entered by Tom.
ID IN (SELECT ID FROM Sentences WHERE UserNick ='Tom')


Export/Display all sentence pairs entered for Client No. 01.
ID IN (SELECT ID FROM Translations WHERE Client = '01')


Export/Display all sentence pairs where one or both sentences in the pair was entered on or after 10 February 2004.
ID IN (SELECT ID FROM Sentences WHERE DateStamp >= #02/10/2004#) ▲ Collapse
 
Ioanna Merope Ippiotis
Ioanna Merope Ippiotis
Italy
Local time: 16:47
Italian to English
+ ...
TOPIC STARTER
Thank you Jun 6, 2010

Thank you very much. The link you posted is very useful!
 
Pablo Bouvier
Pablo Bouvier  Identity Verified
Local time: 16:47
German to Spanish
+ ...
SQL for filtering date and user in DVX Professional's TM Jun 7, 2010

Selcuk Akyuz wrote:

You can find many useful SQL commands in A Tinkerer's Guide to SQL in DVX http://www.necco.ca/dv/docs/A%20Tinkerer's%20Guide%20to%20SQL%20in%20DVX.pdf

Export/Display all sentence pairs where one or both sentences in the pair was entered by Tom.
ID IN (SELECT ID FROM Sentences WHERE UserNick ='Tom')


Export/Display all sentence pairs entered for Client No. 01.
ID IN (SELECT ID FROM Translations WHERE Client = '01')


Export/Display all sentence pairs where one or both sentences in the pair was entered on or after 10 February 2004.
ID IN (SELECT ID FROM Sentences WHERE DateStamp >= #02/10/2004#)



Thanks for share the info. I am sorry to say this, but clicking the link I am redirected to another nordic hosting url that is not related to neccos site. Am I alone with this and has my browser been hijacked? I run some antispyware like spybot and lavasoft, hijackthis, checked the host and lmhost files, etc. and have found nothing suspicious until now... Any suggestion? Thanks in adavnce for your help.

[Editado a las 2010-06-07 07:55 GMT]
 
Grzegorz Gryc
Grzegorz Gryc  Identity Verified
Local time: 16:47
French to Polish
+ ...
Apostrophe encoding Jun 7, 2010

Pablo Bouvier wrote:

Selcuk Akyuz wrote:

You can find many useful SQL commands in A Tinkerer's Guide to SQL in DVX
http://www.necco.ca/dv/docs/A%20Tinkerer's%20Guide%20to%20SQL%20in%20DVX.pdf


Thanks for share the info. I am sorry to say this, but clicking the link I am redirected to another nordic hosting url that is not related to neccos site. Am I alone with this and has my browser been hijacked? I run some antispyware like spybot and lavasoft, hijackthis, checked the host and lmhost files, etc. and have found nothing suspicious until now... Any suggestion? Thanks in adavnce for your help.


Just a problem with the apostrophe encoding.
Try this one:
http://www.necco.ca/dv/docs/A%20Tinkerer's%20Guide%20to%20SQL%20in%20DVX.pdf
Copy it and paste in your browser.

Cheers
GG

[Edited at 2010-06-07 07:56 GMT]
 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 17:47
English to Turkish
+ ...
New Link Jun 7, 2010

It seems that there is a problem with the link, you can find the working link on this page: http://www.necco.ca/dv/sql_dvx.htm
 
Pablo Bouvier
Pablo Bouvier  Identity Verified
Local time: 16:47
German to Spanish
+ ...
SQL for filtering date and user in DVX Professional's TM Jun 7, 2010

Selcuk Akyuz wrote:

It seems that there is a problem with the link, you can find the working link on this page: http://www.necco.ca/dv/sql_dvx.htm



I am sorry, but it still redirects me (copying and pasting as like with the new link) . So, I think there is a security issue with my computer.Nevertheless, many thanks for the info. I am somewaht crazy (obsessed) in behalf to security issues...

[Editado a las 2010-06-07 08:09 GMT]
 
Tatiana Nefyodova
Tatiana Nefyodova  Identity Verified
Russian Federation
Local time: 17:47
English to Russian
+ ...
no security issues Feb 21, 2012

If you go to http://www.necco.ca/dv/docs/ and then choose "A Tinkerer's Guide to SQL in DVX.pdf" on the list, you get the text.

Ilde Grimaldi
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

You can also contact site staff by submitting a support request »

SQL for filtering date and user in DVX Professional's TM






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »