Search

You can access the main search via the menu item Research. This is also by default the view after the user login.

Automatic completion

When you start typing your search into the search field, suggestions are generated based on the entered word or words. Easydb searches for suitable words and also for suitable linked records.

You can select a found token or a linked record (cursor up/down + return or mouse). The selected entry then creates a search term in the search field. Multiple search terms can be added and combined with commands (search operators).

And/or links

In order to create a combination of search terms, Boolean logic allows the following entries to be entered via key combinations:

Use the keyboard to scroll through the search terms with the cursor on the left and the cursor on the right. Use Backspace or Delete to delete a search term. You can not change search terms, you can only delete them and re-enter them again.

Object Types/Pools

The search runs by default across all pools and object types that contain records that you can read at least. Click on Object Types/Pools to customize this search filter.

Use the checkboxes to select or deselect individual object types or pools. Press and hold Alt to switch all checkboxes on one level at a time.

Click on the to get information about the object type or pool. A contact person and a description are displayed here.

Expert Search

To define more complex filters for the search, click to the right of the search box. By entering terms into the search fields, you can define the search for one or more fields. The entries are taken as search terms in the search field.

The expert search displays only the fields for the object types selected under “Object types/Pools”. If several are selected, a search mask “All object types” with fields that occur in at least two of the selected object types is also displayed. You can switch to the individual search fields of the individual object types via a pulldown. The entries in the search fields are then limited to the selected object type. If you want to search several object types, you must make multiple entries in the expert search for the corresponding object type. Your entries for different object types are collected when they are transferred to the search field.

The checkbox in the right column searches records without entry, that is, For example, if you select this checkbox for a field with Name Description, and then click on Include in the search, filter all records where the description field is empty.

In All object types shows the secondary search in the upper part under linked object types common linked object types and possibly the type file which can be searched together.

In Common fields the fields are displayed, which occur conceptually in all object types. Note that here the translated name is used for comparison, not the database field name.

Within individual object types, it will be displayed in Common fields if the field appears in more than one form.

In Change history you can search by user, operation, time period and comment. When searching for a Comment, the system checks whether the comment is contained in one of the records. If the search is limited to a certain user or a limited period of time, this information does not refer to the context in which the comment was created. The comments in the hits can therefore by created by other users and during other periods.

For simple date fields, two fields are automatically displayed to search for a time period. If you want to search for an exact date, this must be entered in both the “From” and “To” fields. Otherwise, all hits will be displayed where the date is before or after the entered date. For fields of the type “Date Range” you can switch to four input fields via “Advanced Options” to enter a range for both the “From” and the “To” date.

NOTE: The sorting in the expert search is alphabetic and refers to all available masks. If several main object types are defined for the search, a selection menu for the object types is displayed in the expert search. Here you can choose whether the field lists are displayed by default (corresponding to the order in the mask) or alphabetically in the expert search.

Sorting

The search result can be sorted by up to 3 criteria.

Depending on the selected object types/pool selection, various fields are available here. Fields are grouped according to their localized name.

In some fields, the sorting attribute can be selected in addition to the sorting direction, e.g. For files where file size, file class and format can be sorted.

For some data types, a grouping is also active during a sorting, which displays interim headings in the search result.

String sorting: alphabetical / alphanumeric

String fields can be sorted in an alphabetical and an alphanumeric way. In alphabetical sorting, all numbers are treated like single characters. In alphanumeric sorting, numbers characters are interpreted as actual numbers. This can change the sorting order:

Example:

• Strings with the following values:
  • A 12-B5
  • A 7-B1
  • A 12-B11
• Alphabetical Order:
  • A 12-B11
  • A 12-B5
  • A 7-B1
• Alphanumeric Order:
  • A 7-B1
  • A 12-B5
  • A 12-B11

Multilanguage sorting

For multilanguage fields the sorting works as follows: for a list of the languages “en-US”, “de-DE” it is checked if there is a value for “en-US”, in which case this field is used for sorting. If the english value is emtpy, it is checked if there is a value for “de-DE” and sorted by this value. If none of the values for these languages are set, a fixed value is returned which will sort this search result to the end of the list.

Attributes for selected field types

Display

The display in the search result can be switched between standard (gallery), text view and table with the selection buttons above the hits . Click to refine the display options for the respective ad selection.

Display Options

Display option Standard

Display option Text

Display option Table

NOTE: The display options are stored by the user and will be available as a pre-selection the next time.

Navigation

For each page there is a separate button, which you can click directly to get to the page. The label of the buttons corresponds to the numbers of the hits in the search result.

To scroll back or forward, use the und If you hold the mouse on these arrows, the display of the pages scrolls.

Filter (faceted search)

Click on Filter to enable or disable the search filter. The search filter groups found records by linked object types, file properties, object types, and pools.

The filters are displayed with the number of corresponding records for each block.

The selected checkboxes show active filters. If more than 10 filters are found per block, there is the possibility to click on More and search separately for filtered terms in the respective block.

The search field is very simple. Here, only after a term can be automatically filtered left- and right-lined.

The filter for periods refers to all time and date fields. This refers to the date of recording or production. The following filter options are available:

• today
• yesterday
• tomorrow
• this week (the week from Monday to Sunday)
• last week (the previous week from Monday to Sunday)
• next week
• week after next
• this month
• last month
• next month
• this year
• last year
• decades
• centuries
• millennia
• B.C.

The tag groups and tags configured for the filter also appear in the System Fields area.

NOTE: To reset the selection in the filter, click on the filter button to deactivate it. When the filter is reactivated, the previous selection is undone.

Choose

There are different methods to mark results and select records in easydb.

Click-and-Drag: Use the mouse to select records with the click-and-drag tool. Hold down the left mouse button and drag over records to be selected. To select more results, press the ALT key and select further records to add to the current selection. If you press the ALT key and select currently marked records, they will be removed from the selection. If you use the click-and-drag tool again without pressing the ALT key, the previous selection is deleted and a new selection is made.

SHIFT key: Select a record and press the SHIFT key while clicking on another record to select all records inbetween. Press the SHIFT key to expand the row. To add or remove individual records, press the ALT key while clicking selecting records.

Options menu: The option Select All is available via the menu above the hits display. This selects all hits of the current search on all pages.

Deselect: To deselect individual records of the current selection, use ALT or CTRL when clicking on the selected record. The entire selection can be deselected using the X button below the hits. Alternatively, you can also click in the free space between the records to deselect them.

Context menu

You can use a context menu for the records in the search result.

Text search

The search has several options for searching text. A distinction is made between Exact and Full Text and between Normal, Wildcard and Phrase searches.

• If the search contains double quotes and *, a full-text search is performed in phrase mode. The * is interpreted as a placeholder for any number of characters.

• If the search contains single quotes, an exact search is performed for words.

• If the search does not contain quotation marks, you can distinguish between full text and exact search in the auto-completion. The exact search basically searches for complete words, the full text search for occurrences of word beginnings.

• If the search contains one or more *, a Wildcard search is performed. Words are taken into account that correspond to the letters entered, taking into account the placeholder (any number of any characters).

• Capitals and small letter are ignored in the exact search. Vowels and vowel mutations such as A and Ä are treated differently.

• In the full-text vowels and mutations such as Ä and A are treated the same, as well as ß and ss, ae and ä, etc.

• If more than one word is used for the exact search (in quotation marks or not), all words are searched as single words, regardless of the order.

• Hyphens and quotes are interpreted as spaces in the search.

The suggestions in the search autocompletion are made as if you were searching in full text with an * appended.

Due to a limitation in Elasticsearch, words and phrases are truncated after 256 characters.