Help on Specific Field Search

The Advanced Search allows a more specific search for values of certain database fields, called specific field search. Details of each search type are described in the sections listed below.

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 <=s earch).

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.

© 2017 Wilhelm Busch – Deutsches Museum für Karikatur & Zeichenkunst

Georgengarten30167 Hannover0511 16 9999 11

Tuesday – Sunday
and public holidays
11am –6pm