Skip to Content
avatar image
Former Member

XSHANA Odata service filter option

Hi All,

I want to fetch WERKS based on LAND1.

for example, if I pass LAND1 in the service link, service should return the respective WERKS.

what code should I write to do that in .xsodata file?

currently written the below code which is fetching data based on key fields of T001W.

service { "SAPPFD"."T001W" as "Stores" with("MANDT","WERKS","LAND1"); }.

Regards,

Subhanshu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 02, 2017 at 10:34 AM

    In the service definition you do not have to add anything, because filtering is supported out of the box. You just have to add the corresponding $filter parameter to your OData service call. E.g. .../service.xsodata/Stores?$filter=LAND1 eq 'DE'.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded