Skip to Content
0
Jun 16, 2022 at 12:36 AM

ODATA on the Business Objects filter parameters are not working

204 Views

Hello Everyone,

I have an ODATA on a custom object and trying to consume it in the POSTMAN and seeing the weird responses. In the custom object, I have two fields called "ActivityType and SLTaskStatus".

SLTaskStatus is the standard data type "ProcessingStatusCode" and the ActivityType is a custom code list with values (01 and 02).


I have data in the object with different status values to the SLTaskStatus (1 -Not Started, 2-In process, and 3-Finished). when I am trying to GET the data records with the values Activity Type == 02 and SLTask Status == 1 the system is giving back all the data records irrespective of the SL Task Status I need. The ODAT endpoint I used is as below

https://myXXXXX.sapbydesign.com/sap/byd/odata/cust/v1/readpicktasksdata/SiteLogisticsTaskDataCollectionRootQueryByElements?$format=json&$filter=(SLTaskStatus eq '1') and (ActivityType eq '02').

Please let me know what I am doing wrong here and how can I filter this with both the paramters.

Thank you,

Hanumath