Help on Search

 

 

The site allows a generic full text search and more specific searches for values of certain database fields, called specific field search.

 

Details of each search type are described in the sections listed below. Please use the table of contents to go directly to the topic of interest.

 

 

Table of Contents:

 

Full Text Search. 2

Case Sensitivity. 2

Search for all Objects. 2

Simple Search Words (Terms and Phrases) 2

Wildcard Characters. 2

Search Operators (Boolean Operators) 3

Fuzzy Search. 4

Proximity Search. 5

More Information on Search Behavior 5

Ignored Words (Stop Words) 5

Filtering of special characters. 6

Specific Field Search. 7

Field Types and Search Behavior 7

Combination of specific search fields. 7

Combining Specific Field Search and Full Text Search. 8

 

 


Full Text Search

The full text search allows simple search terms (including phrases) as well as complex search combinations using keyword AND plus OR (Boolean search terms grouped via parenthesis) and other operators.

 

Case Sensitivity

Search terms/phrases are not case sensitive.

 

Search for all Objects

 

To search all objects for a given module use the asterisk wildcard character (‘*’) without any other search phrases.

 

Note that only a single asterisk character (‘*’), that is not embedded or contained in a search phrase or complex search query, is interpreted as search for all objects.

Search for all objects is ignored when specific field search values are entered.

 

Simple Search Words (Terms and Phrases)

 

The simplest search is based on single words such as “portrait” or “flower” (quotes are not necessary). All words specified must be matched by the search result (unless the webmaster defined the behavior to contain any word, i.e. OR combination).

Those single words are also called single terms. A simple search contains a single term of one or more search words (with or without operators).

 

A phrase is a group of words surrounded by quotes such as “portrait of a lady”. A phrase must match a corresponding text sequence to produce a search result.

 

Phrases and single search terms may be combined to define more complex searches.

For example:

            “portrait of a lady”  flower  rose 

 

When doing so, each search phrase and single term must be contained in a search result to produce a search hit.

 

 

Wildcard Characters

Wildcard characters allow definition of partial search terms.

We allow search for a single character or multiple characters:

 

 

 

 

Note and Limitations:

 

 

Search Operators (Boolean Operators)

More advanced searches can be defined by using search operators in combination with single terms and phrases. They allow terms and phrases to be combined through logic operators.

 

The following operators are provided:

 

Operator

Explanation

Example

"+"

(without quotes)

 

The "+" or required operator requires that the term after the "+" symbol is matched in the search result.

 

Note:

This is the default behavior of the application.

 

+madonna +child

“-“

(without quotes)

 

The "-" or prohibit operator excludes results  that contain the term after the "-" symbol.

 

Note:

The prohibit operator cannot be used with just one term. For example, the query “-child” will return no results..

 

madonna -child

AND, &&

(must be all upper case!)

 

 

The AND operator links to terms and matches results where both terms exist.

It is similar to the “+” operator and most useful in combination with the grouping of search terms.

The symbol && can be used in place of the word AND.

 

Note:

This is the default behavior of the application.

madonna  AND  child

OR, ||

(must be all upper case!)

 

The OR operator links two terms and matches results where either of the terms exists.

 

The symbol || can be used in place of the word OR

 

madonna  OR  maria

NOT, !

(must be all upper case!)

 

The NOT operator excludes results that contain the term after NOT.

The symbol ! can be used in place of the word NOT.

 

Note:

The NOT operator cannot be used with just one term. For example, the query “NOT maria” will return no results.

 

madonna   NOT maria

 

 

Grouping:

Grouping of search terms can be used to define the behavior of operators (and hence form sub queries. Grouping is achieved via parenthesis (“(“, “)”).

By default, the following precedence rules are applied:

 

Example:

(madonna OR maria) AND child AND (Weyden  NOT kranach)

 

Searches for all items containing either “madonna” or “maria”, contain the term “child” and contain the term “weyden” but not the term “kranach”.

 

 

Fuzzy Search

The “~” character at the end of a search term produces search results that are similar in spelling to the given search term.

 

Example: “boat~” may produce search results like “boat”, “coat”, “goat” etc.

 

 

Note and Limitations:

 

 

Proximity Search

Proximity search allows searching for words that are within a specific distance from each other

To do a proximity search use the tilde ("~") symbol (without quotes) at the end of a search phrase.

 

Example:

To search for a "maria" and "child" within 5 words of each other use the search:

“maria  child”~5

 

 

 

More Information on Search Behavior

 

The search is mostly powered by Apache Lucene search engine (see http://lucene.apache.org/java/docs/index.html for details).

 

Ignored Words (Stop Words)

 

Depending on the way the site was implemented and the currently selected language, the search may ignore specific words (so called stop words).

 

Some examples for stop words:

 

·        In English:
a, an, and, are, as, at, be, but, by, for, if, in, into, is, it, no, not, of, on, or,  such, that, the,  their, then, there, these, they, this, to, was, will, with

·        In German:
einer, eine, eines, einem, einen, der, die, das, dass, du, er, sie, es, was, wer, wie, wir, und, oder, ohne, mit, am, im, in, aus, auf, ist, sein, war, wird, ihr, ihre, ihres, als, fur, von, mit, dich, dir,mich, mir, mein, sein, kein, durch, wegen, wird

·        In French:
a, afin, ai, ainsi, apres, attendu, au, aujourd, auquel, aussi, autre, autres, aux, auxquelles, auxquels, avait, avant, avec, avoir, c, car, ce, ceci, cela, celle, celles, celui, cependant, certain, certaine, certaines, certains, ces, cet, cette, ceux, chez, ci, combien, comme, comment, concernant, contre, d, dans, de, debout, dedans, dehors, del`, depuis, derriere, des, desormais, desquelles, desquels, dessous, dessus, devant, devers, devra, divers, diverse, diverses, doit, donc, dont, du, duquel, durant, des, elle, elles, en, entre, environ, est, et, etc, etre,eu, eux, excepte, hormis, hors, helas, hui, il, ils, j, je, jusqu, jusque, l, la, laquelle, le, lequel, les, lesquelles, lesquels, leur, leurs, lorsque, lui, l`, ma, mais, malgre, me, merci,mes, mien, mienne, miennes, miens, moi, moins, mon, moyennant, meme, memes, n, ne, ni, non, nos, notre, nous, neanmoins, notre, notres, on, ont, ou, outre, ou, par, parmi, partant, pas, passe, pendant, plein, plus, plusieurs, pour, pourquoi,proche, pres, puisque, qu, quand, que, quel, quelle, quelles, quels, qui, quoi, quoique, revoici, revoil`, s, sa, sans, sauf, se, selon, seront, ses, si, sien, sienne, siennes, siens, sinon, soi, soit, son, sont, sous, suivant, sur, ta, te, tes, tien, tienne, tiennes, tiens, toi, ton, tous, tout, toute, toutes, tu, un, une, va, vers, voici, voil`, vos, votre, vous, vu, votre, votres, y, ca, es, ete, etre, o

 

Filtering of special characters

 

·        Accentuated characters are treated like their non accentuated counterparts.

Example:

ö à o, ä à a, á à a, Ä à A, etc

 

·        German sharp s (‘ß’) will be treated as ‘ss’.

 

 

Specific Field Search

Field Types and Search Behavior

Specific fields are listed to define the desired result for a search. They represent database fields in the application and can be configured to appear as

 

·        Regular text field (for free text input)

Note: The same search rules as defined for the full text field apply except that search is only performed on the specified database field.

·        Dropdown fields:
When a value is selected the field is combined with other fields and the full text search field to produce the search result

·        Multi select fields:
The fields allow more than one object to be selected by pressing the CTRL key. If more than one value is specified, at least one of the selected search criteria must be met for the final search result (compare OR operator in full text search field).

When a value is selected the field is combined with other fields and the full text search field to produce the search result.

Note: To deselect a value, use CTRL key and click on the selected entry.

·        Range fields:
Allows searching of a result within a certain range (mostly date or numeric fields provide range search) by specifying a lower (“From” field part) and upper bound (“To” field part) for the search value. The search value itself is included in the result (i.e. >= or <= search).

If no lower bound is specified, all values up to the upper bound are considered.
If no upper bound is specified, all values starting at the lower bound are considered.

 

 

Combination of specific search fields

The search result will meet all search criteria for all fields where at least one search value is specified.

 


Combining Specific Field Search and Full Text Search

Providing search values for full text search field and specific fields will eventually find results matching all specified criteria, regardless if they are defined in full text search field or specific search field.

 

 

Close Window