IQX CV Searching using Internal Db Text Indexes (SQL Anywhere 11+)

Searching the CV using the text index is much faster than using the previous indexing services.

Efficient CV searching - example 1

Tips on Text Index Server Searching

and

Using 'AND' will look for instances of both words:
Example

  Java AND Delphi    

near

There is also 'NEAR' which will look for two words near each other:
Examples

  Java NEAR Delphi    
  "Java Developer" NEAR "Delphi Developer"    

before

There is also 'BEFORE' which will look for a word which is before another word. 'BEFORE' uses two distances, a minimum (default 1) and a maximum (default 10) which are the distances (in words) between the two words to be searched for:
Examples

  Java BEFORE Developer
  Java BEFORE [1,10] Developer

both will give a result if 'Developer' is between 1 and 10 words after 'Java'

  Java BEFORE [4,20] Developer

will give a result if 'Developer' is between 4 and 20 words after 'Java'

not

Java AND NOT Delphi means that Java must be found but there must be no instance of Delphi. (You can also use '-' instead of the words 'AND NOT').
Example

  Java AND NOT Delphi     
  Java -Delphi
 

or

Java OR Delphi means that either Java or Delphi must be found.
Example

  Java OR Delphi     

multi word phrase to search for a multi-word phrase use double quotes
Example

  "java developer"     
  "java developer" AND "delphi developer"    

The wildcard character (*) can match words with a given prefix.
Example

  esc*     

matches the terms “ESC” “Esc.” “escape” “escapade” and so on.

Further tips
You can add parentheses to nest expressions within a query. The expressions in parentheses are evaluated before the rest of the query.


Use double quotes (“) to indicate that a Boolean or NEAR operator keyword should be ignored in your query. For example, “Abbott and Costello” will match pages with the phrase, not pages that match the Boolean expression. In addition to being an operator, the word and is a noise word in English.


To use specially treated characters such as &, |, ^, #, @, $, (, ), in a query, enclose your query in quotation marks (“).

Go to SAP Search Help for more information (external link)

Go back to Hints, Tips & Shortcuts

  • cvsearchingtextindex.txt
  • Last modified: 2017/12/01 16:35
  • by 127.0.0.1