SAP Knowledge Base Article - Public

2972132 - OData Filter Returns Wrong Result


You have built your OData query but when you run it with a filter, you notice that it does not work. You may not get any results even though that filter values you defined should return data.


  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Ensure that your OData query has some values in the filter.
  2. Run your OData query in the browser.

You get no results even though there is data for those values in the report. You may also notice that without the filters, the expected values are returned.


You have put the filter on an ID field. Let us assume the following example: You are filtering on the Contract and Contract Item. These are UUID fields, however in the item field, you filter for the ID '10'. Since it's a UUID field, the ID 10 will be converted into a UUID. However there are multiple items with the ID 10. Hence the system takes the first UUID with this ID, which may not correspond to the item of that contract. As a result, no data is returned.


For item fields (or other fields where 1 ID may correspond to several UUIDs), it is strongly recommended to use an ID field in the filter, for example Contract Item ID.


Odata, report, data source, analytics, reporting, filter not working, no results, missing data , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign 2008