Wildcard queries on multiple fields and filtering by score

I have an index like below:

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.

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