Boolean Searching


Boolean text searches are simply text searches that allow you to include operators between certain words and phrases to provide a more in-depth set of criteria when searching text. In itris, you can use Boolean searching to search across the following areas; applicants CVs, job descriptions on job records as well as the summary fields on applicants, companies or contacts.

If you are using the CV text search, the text matches will be highlighted on the CV in green when using the snap view. The results by default will be ordered with the highest-ranking showing at the top. This can be changed to ascending or another sort option, using the sort icon in the grid as required. 

Note: When Boolean searching online, quotation marks are often used to search for two or more words which need to remain together. Examples include searching for job titles. To simplify this process itris does not require quotation marks around multiple words, instead simply list them. For example: 

Biology Teacher

Additionally, searching is not case-sensitive.


AND Searching

This operator combines terms so that a record is only returned if all terms exist in the same searched area. For example, "Teacher" AND "Biology" will find only records where both words exist within the searched area.

To perform an AND search the words being searched for need to be entered on separate lines. For example:

Teacher

Biology


OR Searching

This operator combines terms so that a record is returned if it contains any or all of the terms within the searched area. Searching for "Biology" OR "Chemistry" will find records where either of the words exist in the searched area. For example:

Biology OR Chemistry

These operators will be displayed in blue.


NOT Searching

This operator prevents records being returned in which the specified term occurs in the searched area. It is helpful when a word has multiple meanings, such as, if a user searches for "Engineer", and "NOT Software", itris will return results where Engineer occurs, but Software does not. It is also useful as a way of excluding a word which may otherwise appear and skew the results. For example:

NOT Physics

These operators will be displayed in red.

Note: "not" can only be used at the beginning of a line and cannot be used on the first line of a search.


Wildcard Searching

This operator allows for flexibility in that it can replace one or more letters at the end of a word. This might help when searching for something that can be phrased differently. Such as, Teach* which will return records containing the words "Teach", "Teacher" or "Teaching" etc. within the searched area. For example:

Teach*

This operator will be displayed in green.

Note: Wildcards can only be used at the end of a word.


Proximity Searching

Sometimes search terms are only relevant if the words are close to each other within the CV. For this, you can use proximity searching. To do so type the word "near" followed by a comma-separated list of words or phrases. For example: 

NEAR Secondary, Biology, Teacher

The example above would return records that have the words "Secondary", "Biology" and "Teacher" close to each other (usually within 20 words) within the searched area. This would therefore find an applicant whose CV or summary contained the sentence "I currently work as a Science Teacher at Marks House Secondary School, where my main subject speciality is biology. ".


Combining Search Operators

You can also combine any of the search options above to achieve powerful results. For example:

Teach*

Biology OR Chemistry

NOT Physics

Special Words

When performing text searches, SQL Server naturally omits certain characters to streamline full-text searching. This includes numbers, single characters, symbols, and anything in the Unicode dictionary. So for example, when searching CVs for ‘C#’ or ‘C++’, SQL Server will remove these and treat them as if they do not exist.

Special words are therefore used to force SQL Server to include these when performing a full-text search and this is done by creating a catalogue in the database, essentially telling SQL Server that it is actually a word. Special words are created within the itris Management Utility (IMU), Settings area.