SAP Knowledge Base Article - Public

3677121 - Odata query $filter combined with 'and'/'or' criteria is not working

Symptom

Filtering on multiple strings fields does not work properly in analytical requests, due to an issue in the parsers, and returns no results (when it should return valid results).

Environment

SAP Datasphere

Reproducing the Issue

  1. Make an OData analytical request which uses filter for 2 strings joined with and/or operators
  2. Returned Value: []

Cause

Program error 

Resolution

The fix is already in place and will be part of release 2025.23 

Meanwhile the workaround is to move the filter temporary to the AM model.

For more information, please see SAP Note ##2984828 - SAP Datasphere Release & Delivery Schedule As global deployment usually takes 24 hours, you may plan to test the fix one day later. 

Keywords

odata, $filter, criteria, and, or, filter , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Problem

Product

SAP Datasphere all versions