If you filter by [Status] = 'Active' , create a view that selects only active documents first .
The NotesSQL driver does support full-text search via standard SQL LIKE efficiently. A query like: lotus notessql 206 driver top