how to use $select and $filter in odata query

[nandini_borse]

Hello all,

How to use $select and $filter as combine in odata query to get data.

like how we write for now Matdetailset?$filter= matnr eq '12345' .

[former_member667434 · Accepted solution]

nandini_borse

Try something like this - /odata/SAP/XXXXXX/EntitySet?$filter=FieldName1 eq 'Value1' &$select=Field1 %2c Field2

I just did and it works good for me.

-Ashutosh

[rahulb87 · Accepted solution]

Hi @ashutosh.anand

Can you tell me if we can use the Select function to extract only a part of the database and not the whole table?

Example

I need to select warehouse tasks for warehouse 1000 only. Can I write a selection for this?

Currently, I am working like below:

XXXXXXsap/warehouseorder/0001/WarehouseTask?$select=EWMWarehouse&$filter=EWMWarehouse eq '1000'

This is taking a long time to process as I have multiple warehouses in the system.

Could you please help?

Regards

Rahul Bhardwaj