SQL for filtering date and user in DVX Professional's TM
Thread poster: Ioanna Merope Ippiotis

Ioanna Merope Ippiotis
Italy
Local time: 02:15
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  Identity Verified
Turkey
Local time: 04:15
Member (2006)
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 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#)


 

Ioanna Merope Ippiotis
Italy
Local time: 02:15
Italian to English
+ ...
TOPIC STARTER
Thank you Jun 6, 2010

Thank you very much. The link you posted is very useful!

 

Pablo Bouvier  Identity Verified
Local time: 02:15
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  Identity Verified
Local time: 02:15
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  Identity Verified
Turkey
Local time: 04:15
Member (2006)
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  Identity Verified
Local time: 02:15
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...icon_wink.gif

[Editado a las 2010-06-07 08:09 GMT]


 

Tatiana Nefyodova  Identity Verified
Russian Federation
Local time: 04:15
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.

 


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

Advanced search






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search