Answers to: Use nested query of elasticsearch in Ivy

Comment by Reto Weiss on Reto Weiss's answer

Reto Weiss — Wed, 31 May 2017 07:50:24 -0400

See here http://developer.axonivy.com/doc/latest/EngineGuideHtml/installation.html#installation-elasticsearch

Comment by trungdv on Reto Weiss's answer

trungdv — Wed, 31 May 2017 06:29:06 -0400

Following this post https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-query.html, object must be index as nested object in order to search with nested type (use raw query as your suggestion) So we need to run code like this example here :https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-mapping.html It will update elastics search index table.

So how can i access to instance of elastics search in ivy to execute that query? i try with Ivy.repo().search(clazz).raw(query) but i think it's not designed for this purpose.

Thanks

Comment by trungdv on Reto Weiss's answer

trungdv — Wed, 31 May 2017 05:59:38 -0400

hi @Reto Weiss ♦♦

One more question, where does elastic search store index data in ivy?

Comment by Reto Weiss on Reto Weiss's answer

Reto Weiss — Wed, 31 May 2017 03:35:42 -0400

We use a standard installation of elasticsearch in the Designer and Engine. You find it in the elasticsearch directory inside the Designer or Engine installation directory. See file /elasticsearch/config/elasticsearch.yml to configure this.

Comment by bthlan on Reto Weiss's answer

bthlan — Wed, 31 May 2017 03:19:27 -0400

hi @Reto Weiss ♦♦

Thanks for your answer. We will try with raw query.

I have another question. If we use nested fields, it will limit the number of documents to 50. (Please refer "Limiting the number of nested fields" section at https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html ). However 50 are quite small.

Elastic search still supports to config that number of documents by config index.mapping.nested_fields.limit (https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#mapping-limit-settings ). Does Ivy supports to config that value?

Comment by Reto Weiss on Reto Weiss's answer

Reto Weiss — Wed, 31 May 2017 02:59:41 -0400

No, there are currently no plan to support more query features.

Comment by trungdv on Reto Weiss's answer

trungdv — Tue, 30 May 2017 22:42:07 -0400

hi @Reto Weiss ♦♦

do you have plan to support it?

Answer by Reto Weiss

Reto Weiss — Tue, 30 May 2017 08:10:14 -0400

We do not support nested queries over the search API currently. However you can use the following method to use elastic search query directly:

String elasticSearchQuery = "...";  // configure your elastic search query here!
ivy.repo.search(Person.class).raw(elasticSearchQuery);

Regards

Reto