Enhanced full-text search in new Ultra Recall 4.1 beta

< Next Topic | Back to topic list | Previous Topic >

Posted by Chris Murtland
Sep 1, 2009 at 07:32 PM

Relevant portions clipped from email from Kinook:

SQLite now provides a full-text search capability which efficiently stores
and indexes the text in the database, and the beta build of UR leverages
this capability to provide faster phrase searching and retrieval of item
text and additional full-text search capabilities.

Searches work nearly the same as before FTS (implicit AND when multiple
words are entered in the search criteria, OR supported for ‘or’ conditions,
double quotes for phrase searches, etc.), but extended phrase searching is
no longer necessary, and phrase searches should be faster.

New capabilities include the NOT prefix to exclude items containing a
specific word, NEAR (defaulting to within 10 words) and NEAR/x (where x is a
number between 0 and 9) to find two words near each other, and parentheses
are supported for complex search conditions. A Relevance system attribute
is also available in the Search Results pane (View | Choose Columns).

Differences to be aware of:
1) Matching is now done on a whole word basis by default, and instead of
specifying this option globally (by unchecking the Match whole words
option), add a * to each word that should match partially (i.e., word*).
2) AND, OR, NOT, and NEAR must be capitalized to be treated as logical
operators.

Posted by quant
Sep 12, 2009 at 09:26 PM

I’m not beta tester, so this is news to me. This is going to be a fantastic feature, having NEAR operator together with Relevance attribute will greatly enhance UR search capabilities, close to what dedicated Indexing Search software provides. Together with “highlighted search results” (which still has some annoyances), it’s going to be great. So far I was putting to UR only the most important info (because of limited search capabilities) and the rest outside where I could use Search program (Archivarius 3000). It seems that I’ll be able to store much more info in UR and use it’s powerful features. Can’t wait!

Chris Murtland wrote:
>New
>capabilities include the NOT prefix to exclude items containing a
>specific word,
>NEAR (defaulting to within 10 words) and NEAR/x (where x is a
>number between 0 and 9) to
>find two words near each other, and parentheses
>are supported for complex search
>conditions. A Relevance system attribute
>is also available in the Search Results
>pane (View | Choose Columns).

Back to topic list