Wildcard queries on multiple fields and filtering by score

Elastic Stack Elasticsearch
1

I have an index like below:

Image 12
Image 121861×116 165 KB

For example user searchs "c 001", I look at search_all_fields and find it in two documents.
With WildCardQuery for all searching keywords " c " and " 001 "
But the second one is useless. Because the first one matches with search_item_no. This is more valuable. The second one matches with search_group_one field. This is less valuable. I must filter it.

But on the other hand, someone searchs "yyy 102", then it only takes place in search_group_one and search_group two field. So I must not filter it.

Going twice elastic side for scoring is expensive. But How can I achive this?

I asked this before. Filter Based On Average Score
I've added the scenarios and index structure.

Any advice would be appreciated.

2

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