-
Type:
Bug
-
Status: Resolved
-
Priority:
Major
-
Resolution: Not A Bug
-
Affects Version/s: 6.0-HF14
-
Fix Version/s: None
-
Component/s: Elasticsearch, Query & PageProvider
-
Tags:
In Nuxeo Studio:
- Create a search content view using elasticsearch index
- Drag and drop the dublincore title metadata in the search layout
- Use the ILIKE operator and text widget
- Save and deploy
=> Search returns no result although documents with a corresponding title exist
Corresponding elasticsearch log snippet below:
2015-06-19 18:15:23,051 DEBUG [http-bio-0.0.0.0-8080-exec-13][org.nuxeo.elasticsearch.provider.ElasticSearchNxqlPageProvider] Perform query for provider 'bookSearchCV': with pageSize=10, offset=0{{RemoteAddr,127.0.0.1}{RequestURL,http://localhost:8080/nuxeo/search/search.faces}{ServletPath,/search/search.faces}{SessionID,219E3F0A9001CBBE14219876B68E4990.nuxeo}{UserPrincipal,Administrator}} 2015-06-19 18:15:23,052 DEBUG [http-bio-0.0.0.0-8080-exec-13][org.nuxeo.elasticsearch.core.ElasticSearchServiceImpl] Search query: curl -XGET 'http://localhost:9200/nuxeo/doc/_search?pretty' -d '{ "from" : 0, "size" : 10, "query" : { "bool" : { "must" : [ { "wildcard" : { "dc:title.lowercase" : { "wildcard" : "tintin chez les nudistes" } } }, { "bool" : { "must" : [ { "constant_score" : { "filter" : { "not" : { "filter" : { "term" : { "ecm:mixinType" : "HiddenInNavigation" } } } } } }, { "constant_score" : { "filter" : { "term" : { "ecm:isVersion" : "0" } } } }, { "constant_score" : { "filter" : { "not" : { "filter" : { "term" : { "ecm:currentLifeCycleState" : "deleted" } } } } } }, { "constant_score" : { "filter" : { "term" : { "ecm:primaryType" : "Book" } } } } ] } } ] } }, "fields" : "_id", "aggregations" : { "book_publicationDate_agg_filter" : { "filter" : { "match_all" : { } }, "aggregations" : { "book_publicationDate_agg" : { "date_range" : { "field" : "book:publicationDate", "ranges" : [ { "key" : "from_now-1M_to_now", "from" : "now-1M", "to" : "now" }, { "key" : "from_now-7d_to_now", "from" : "now-7d", "to" : "now" }, { "key" : "from_now_to_", "from" : "now" }, { "key" : "from__to_now", "to" : "now" } ] } } } }, "book_category_agg_filter" : { "filter" : { "match_all" : { } }, "aggregations" : { "book_category_agg" : { "terms" : { "field" : "book:category", "order" : { "_count" : "desc" } } } } } } }'{{RemoteAddr,127.0.0.1}{RequestURL,http://localhost:8080/nuxeo/search/search.faces}{ServletPath,/search/search.faces}{SessionID,219E3F0A9001CBBE14219876B68E4990.nuxeo}{UserPrincipal,Administrator}} 2015-06-19 18:15:23,054 DEBUG [http-bio-0.0.0.0-8080-exec-13][org.nuxeo.elasticsearch.core.ElasticSearchServiceImpl] Response: { "took" : 1, "timed_out" : false, "_shards" : { "total" : 1, "successful" : 1, "failed" : 0 }, "hits" : { "total" : 0, "max_score" : null, "hits" : [ ] }, "aggregations" : { "book_category_agg_filter" : { "doc_count" : 0, "book_category_agg" : { "buckets" : [ ] } }, "book_publicationDate_agg_filter" : { "doc_count" : 0, "book_publicationDate_agg" : { "buckets" : [ { "key" : "from__to_now", "to" : 1.434730523053E12, "to_as_string" : "2015-06-19T16:15:23.053Z", "doc_count" : 0 }, { "key" : "from_now-1M_to_now", "from" : 1.432052123053E12, "from_as_string" : "2015-05-19T16:15:23.053Z", "to" : 1.434730523053E12, "to_as_string" : "2015-06-19T16:15:23.053Z", "doc_count" : 0 }, { "key" : "from_now-7d_to_now", "from" : 1.434125723053E12, "from_as_string" : "2015-06-12T16:15:23.053Z", "to" : 1.434730523053E12, "to_as_string" : "2015-06-19T16:15:23.053Z", "doc_count" : 0 }, { "key" : "from_now_to_", "from" : 1.434730523053E12, "from_as_string" : "2015-06-19T16:15:23.053Z", "doc_count" : 0 } ] } } } }{{RemoteAddr,127.0.0.1}{RequestURL,http://localhost:8080/nuxeo/search/search.faces}{ServletPath,/search/search.faces}{SessionID,219E3F0A9001CBBE14219876B68E4990.nuxeo}{UserPrincipal,Administrator}}