Found how to «Go to next empty»
Thread poster: mikhailo

Local time: 19:23
English to Russian
+ ...
Dec 7, 2015

I've found how to «Go to next empty»

1. File->Options->SQL
Statement Name — «Next Empty» (w/o quotes)
SQL WHERE Filter Expression — «((Target_XXXX = ''))» (w/o quotes)
Press «Add» button

In «Filters» appears «Next Empty»

In «DB type» shloud be «Project»

Then use it from ribbon

Goto - > next segment matching SQL filter -> Next Empty

the only thing to do - how to add shortcut to this.

A good idea to add some examples of such SQL to manual. Last time I haven't understood how when Atril peoples wrote that «Go to next empty» can be made with SQL.

Direct link Reply with quote

Local time: 19:23
English to Russian
+ ...
some addendum Dec 7, 2015

How to make filter working not in WORD boundaries.

So that filter «match» find also «matches» etc?

And another good idea — to not filter if there are zero results.

Direct link Reply with quote

Endre Both  Identity Verified
Local time: 18:23
Member (2002)
English to German
DVX's SQL filtering is great Dec 8, 2015

mikhailo wrote:
the only thing to do - how to add shortcut to this.

Exactly. Having to point and click three times on the ribbon is a real letdown for the marvelous feature of SQL filters.

Regarding word boundaries, if you're talking about the regular filter available in the grid context menu, then you cannot customize that. The source filter filters on whole words (so if you select a partial word and do the filtering, the very segment you filtered from disappears!), while the target filter filters regardless of word boundaries. Don't ask me why it works like this. The SQL filter on the other hand knows no word boundaries.

On not filtering if there are zero results, it's an interesting idea. You won't be able to do that with SQL, but DVX could implement in internally. It might be confusing if DVX simply did nothing, but a message to the effect "This filter produces no segments" might indeed be better than showing an empty grid.


Direct link Reply with quote

Selcuk Akyuz  Identity Verified
Local time: 19:23
Member (2006)
English to Turkish
+ ...
go to next empty with RegEx Dec 8, 2015

You can use the Find dialogue to go to the next empty segment.

In Find dialogue, check "Use Regular Expressions" and find:



Moreover in DVX3 there is a shortcut for it (though I never used it before)

Next Untranslated on Ribbon (Home Tab)
Next Unconfirmed Ctrl+Shift+Alt+Down Arrow

[Edited at 2015-12-08 08:53 GMT]

Direct link Reply with quote

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 »

Found how to «Go to next empty»

Advanced search

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 »
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, integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search