Es query problem

an index of a product with a price field. This product may have a price of 1mi N, probably less than 20.

search criteria: more than 10w, more than 50w, etc. To search for products with a price that meets these conditions

the current practice is that when you generate a product price field index, a price category is generated for the product according to each price, which is written in AME Z. for example, the price range field of a product is productA.pricre: a code Bpenc < / price >. Then go to the partial match when searching the B interval. The field of the price range.

I don"t know if there are any other good ideas

Jul.22,2021

whether to consider using a separate record for each price of a product. The price uses the number
to search the range and then remove it. The advantage is that the definition of the scope is flexible and the subsequent expansion is convenient

.
Menu