SQL for filtering date and user in DVX Professional's TM Autor de la hebra: Ioanna Merope Ippiotis
|
|---|
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 
Turquía
Local time: 09:49
inglés al turco
+ ...
| 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
| | | |
Thank you very much. The link you posted is very useful!
| | | | | 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]
| | |
|
|
|
| Apostrophe encoding | Jun 7, 2010 |
Pablo Bouvier wrote: 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
Turquía
Local time: 09:49
inglés al turco
+ ...
| | SQL for filtering date and user in DVX Professional's TM | Jun 7, 2010 |
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]
| | | | | 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.
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » SQL for filtering date and user in DVX Professional's TM | CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
