Results not as expected on O-Data Service

[former_member261585]

When we are trying running a Query on browser

“https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/TravelagencyCollection? $filter=Region eq '03'”  it does NOT fetch results as expected. ?

The returned data from the query returns Region which is not equal to 3 which means the filter is not working.

Please advice ,

Thanks in advance

[kammaje_cis]

You should have used 'REGION', but anyway it does not work for that as well.

It means that Filter was not handled for 'Region', and service has just ignored it.

But I would have expected the service to raise an exception. Anyway, it is all about how the service was implemented.

[sreehari_vpillai]

Ignore this .. I mistook it as xsodata

Hi,

I faced kind of same issue before.

What is the data type of "Region" attribute ?

IF you are not passing the filter , is it returning the data with '03' as region ? - If yes , pls share a snap shot.

Are you using a scripted calculation view/Graphical ? - Share the semantics .

Sree