Error while getting data from opensearch

OpenSearch
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
I am using opensearch with magento commerce 2.4.6-p2 and getting below error. Can you please help ?
2023-08-31T12:08:21.943510+00:00] report.CRITICAL: OpenSearch\Common\Exceptions\BadRequest400Exception: {“error”:{“root_cause”:[{“type”:“x_content_parse_exception”,“reason”:“[1:287] [terms_lookup] unknown field [in]”}],“type”:“x_content_parse_exception”,“reason”:“[1:292] [bool] failed to parse field [must]”,“caused_by”:{“type”:“x_content_parse_exception”,“reason”:“[1:287] [terms_lookup] unknown field [in]”}},“status”:400} in /app/3fj23x5cmkxlk_stg/vendor/opensearch-project/opensearch-php/src/OpenSearch/Connections/Connection.php:661

Describe the issue:

Configuration:

Relevant Logs or Screenshots:

2

It seems that the format of query DSL is not correct, you can show you query DSL directly or show your code to help solving the problem.

3

Looks like it is shown from exception.log file. Can you reproduce step by step the process that led to this error?