Searching for Objects Using Expert Mode

Valid for: yuuvis® RAD client 5.20

yuuvis® RAD client offers search requests in expert mode for proficient users. You can access the expert mode using the Expert search icon Expert search icon in the search dialog.

The query language is based on the syntax of Elasticsearch. General information about the Elasticsearch search options is available here.

The following rules apply to searching in expert mode:

Placeholder

Search requests can be combined with the following placeholders:

'*' for any kind and any number of characters.

'?' for exactly one character.
Exact search If you want to search for an exact string, enter it in double quotation marks.
Operators

You can combine search requests with logical operators.

  • Support for <, >, <=, >=, <>, = as relational operators is provided.
  • Support for AND, OR, NOT as linking operators is provided.

Here are some examples of search requests:

Find all objects of type 'photo' which have a date in 2016 in the date field 'imagedate'.
dte_photo_imagedate:[2016-01-01 TO 2016-12-31]

Examples:

Find objects of a specific type that contain the search term in two string fields.
str_email_to:test@gmx.de OR str_email_from:test@gmx.de
Find objects of a specific type where the search term 'Mar' is contained in a specific field.
key_type:personalkte AND str_personalakte_name.idxs:Mar*

key_type:personalkte AND str_personalakte_name.idxs:Mar?in

When searching with wildcards, it is necessary to append .idxs to the string field name.

If 'key_type:personnel file AND' is omitted, all children objects of the context file will be found if they have been assigned the field 'str_personnelfile_name' for inheritance.
Find all objects of the type 'document', where the 'class' field is set to 'applicant’ in the 'personal file' context folder.
key_type:document AND key_contextfoldertype:personnel file AND key_personnelfile_class:applicant
Find all objects of the type 'photo' that have no value in the 'imagedate' date field (NULL).
key_type:photo AND NOT _exists_:dte_photo_imagedate

For some field names, a prefix must be prefixed to the search request:

  • Catalog fields: key_ prefix

    Example: key_personnelfile_class:applicant

  • String fields: str_ prefix

    Example: str_personnelfile_firstname:

  • Numeric fields: num_ prefix

    Example (all journal e-mails with attachments): num_sysemail_sysattachmentcount:>0

  • Boolean fields: bol_ prefix

    Example: bol_personnelfile_active:true / ....:(false

  • Date fields: dte_ prefix

    Example: dte_photobasic_photodate:<ISO data format

Searches in the expert mode cannot be saved, added to the favorites, or shared.

Related Topics Link IconRelated Topics