# Minimum Missed Conditions Search

**URL:** <https://discuss.elastic.co/t/minimum-missed-conditions-search/282701>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [August 27, 2021, 6:10pm UTC](https://discuss.elastic.co/t/minimum-missed-conditions-search/282701 "2021-08-27T18:10:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MagicMatt](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@MagicMatt](https://discuss.elastic.co/u/MagicMatt)\
**Post date:** [August 27, 2021, 6:10pm UTC](https://discuss.elastic.co/t/minimum-missed-conditions-search/282701/1 "2021-08-27T18:10:24Z")

</div>

Hi guys, I just started learning ES and it is fun to play with the data and try to apply the queries to some special cases.

These days I am trying to build two sorting methods to help return better results:  
Max Used Conditions  
Min Missing Conditions

I can simply achieve maximum used conditions by

```auto
GET test/_search
{
  "query": {
    "bool": {
      "minimum_should_match": 1,
      "should": [
        {"match": {"tags": {"query": "condition A","fuzziness": "AUTO"}}},
        {"match": {"tags": {"query": "condition B","fuzziness": "AUTO"}}},
        {"match": {"tags": {"query": "condition C","fuzziness": "AUTO"}}},       
...

```

tags is an Array contain different conditions.  
The more tags element matched in a doc, the higher score it will have.

However, when we tried to sort the result with minimum missed conditions:  
For example,  
I have the following items with tags:  
ItemA: [condition A, condition B, condition C]  
ItemB: [condition A, condition B, condition D, condition F]  
ItemC: [condition A, condition B, condition D, condition E, condition F]

I use [condition A, condition B, condition C, condition E]  
ItemA's tags all got matched (3/3) 100%  
ItemB's tags (2/4) 50%  
ItemC's tags (3/5) 60%  
I hope the sorting order to be: ItemA \> ItemC \> ItemB

I wrote a function script myself, but it ended up with 3 nested for loops and I know it is not practical and it doesn't use ES's advanced searching features... Is there any way that I can return get used conditions and missed conditions **Count** to help to achieve what I want? Thank you.

```auto
POST _scripts/min-missing-conditions
{
	"script":{
     "lang": "painless",
     "source": """
         def cnt = 0.0;
         //I am trying to achieve kind of fuzzy search in the script...
         for (int i = 0; i < doc['tags.keyword'].length; ++i){
            for (int j = 0; j < params.tags.length; ++j){
                String[] tagsSplit = params.tags[j].splitOnToken(" ");
                for (int k = 0; k < tagsSplit.length; ++k){
                   if (doc['tags.keyword'][i].contains(tagsSplit[k])){
                       cnt = cnt + 1.0/(2.0 * tagsSplit.length);
                   }
                   if (tagsSplit[k].contains(doc['tags.keyword'][i])){
                       cnt = cnt + 1.0/(2.0 * tagsSplit.length);
                   }
              }
         }
   }
   return cnt / doc['tags.keyword'].length;
   """
   }
}

```

---

<div class="post-metadata">

**Author:** ![MagicMatt](https://avatars.discourse-cdn.com/v4/letter/m/c5a1d2/32.png) [@MagicMatt](https://discuss.elastic.co/u/MagicMatt)\
**Post date:** [August 29, 2021, 11:37pm UTC](https://discuss.elastic.co/t/minimum-missed-conditions-search/282701/2 "2021-08-29T23:37:37Z")

</div>

I can kind of getting the number of matched conditions by using function\_score with functions:

```auto
GET test/_search
{
  "query": {
  "function_score":{
    "query": {...},
    "functions": [{
       {
          "filter":{"match": {"tags": {"query": "condition A","fuzziness": "AUTO"}}},
          "weight": 1
        }
...
    ],
    "score_mode": "sum",
    "boost_mode": "replace"

```

and get the tags array length via script:

```auto
"source": "params['_source'].tags.length

```

However, I cannot use them together since for function\_score query, "[you can either define [functions] array or a single function, not both. already found [functions] array, now encountering [script\_score].]"

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 26, 2021, 11:37pm UTC](https://discuss.elastic.co/t/minimum-missed-conditions-search/282701/3 "2021-09-26T23:37:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.