Price filter does not filter the price on customer group

[nicobatty]

After I started debugging the ElasticSearch requests, I noticed that there were no filter on the customer group when filtering the price.

"post_filter": {
  "bool": {
    "must": [
      {
        "nested": {
          "query": {
            "range": {
              "price.price": {
                "from": "15",
                "to": "29",
                "include_lower": true,
                "include_upper": false,
                "boost": 1.0
              }
            }
          },
          "path": "price",
          "ignore_unmapped": false,
          "score_mode": "none",
          "boost": 1.0
        }
      },
      {
        "terms": {
          "option_text_article_type": [
            "Sous-gants"
          ],
          "boost": 1.0
        }
      },
      {
        "terms": {
          "price.customer_group_id": [
            0
          ],
          "boost": 1.0
        }
      }
    ],
    "disable_coord": false,
    "adjust_pure_negative": true,
    "boost": 1.0
  }

In the response, I get two hits with this price list for example:

"price": [
  {
    "price": 10.2,
    "original_price": 10.2,
    "is_discount": false,
    "customer_group_id": "0"
  },
  {
    "price": 10.2,
    "original_price": 10.2,
    "is_discount": false,
    "customer_group_id": "1"
  },
  {
    "price": 16.99,
    "original_price": 16.99,
    "is_discount": false,
    "customer_group_id": "2"
  },
  {
    "price": 16.99,
    "original_price": 16.99,
    "is_discount": false,
    "customer_group_id": "3"
  }
]

The issue is that I'm navigating as a customer_group_id = 0 and a price range of 15-29 and 10.2 is not part of that range. It's only part of the range for the customer_group_id : 2 or 3.

Any idea on how to fix this?

[nicobatty]

It does work correctly if I change the post_filter part like this:

"post_filter": {
    "bool": {
      "must": [
        {
          "nested": {
            "query": {
              "bool": {
                "must": [
                  {
                    "range": {
                      "price.price": {
                        "from": "15",
                        "to": "29",
                        "include_lower": true,
                        "include_upper": false,
                        "boost": 1.0
                      }
                    }
                  },
                  {
                    "terms": {
                      "price.customer_group_id": [
                        0
                      ],
                      "boost": 1.0
                    }
                  }
                ]
              }
            },
            "path": "price",
            "ignore_unmapped": false,
            "score_mode": "none",
            "boost": 1.0
          }
        },
        {
          "terms": {
            "option_text_article_type": [
              "Sous-gants"
            ],
            "boost": 1.0
          }
        }
      ],
      "disable_coord": false,
      "adjust_pure_negative": true,
      "boost": 1.0
    }
  },

Though I'm not an expert in Elasticsearch so I'm not sure this would be the right way to do it.

[romainruaud]

Hello @nicobatty

interesting issue, and interesting hypothesis of resolution.

Always happy to see people digging inside our engine, so thank you for submitting a such detailed issue.

I'll have a look on this one.

[romainruaud]

Associated PR have been merged and will be part of the next minor release.

Thank you for supporting our module !