Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Since version 11.3, Wedia relies on ElasticSearch for full text and structured search. All SQL or SQL + Full text queries go through ElasticSearch. The RDBMS is only used to retrieve instances identified by the ElasticSearch search.

Full-text syntax

...

Note

The content of this article is only valid from version 11.6 onwards.

A "full text" search does not require any special syntax elements. Just list the words you want to search for a result, e.g.: green boat

...

Finally, if you are looking for a boat whose reference is vaguely known, it is possible to do a search starting with suffixing the reference by '*':
+boat +REF25*

...

Note

Prefix searching is not implemented for performance reasons. A search on F25 will not have the desired effect.

To summarize:

  • Prefix with '+' to force the presence of a term.

  • Prefix '-' to exclude the presence of a term.

  • Surround with '"' to search for an exact phrase.

  • It is possible to force or exclude a sentence: +"green boat" -"red boat"

...

There is also a shortcut to search directly for an instance whose id is known by typing: #id.

zSyslucene object

...

Note

This section applies for developers migrating from a Lucene based to a ElasticSearch based version.

The use of ElasticSearch entails some changes to be taken into account when developing new applications or migrating existing ones.

...