Skip to Content
0
Former Member
Oct 17, 2013 at 06:45 PM

SAP HANA Calculation View OData Service - Filters not affecting the output

365 Views

Hi all,

I have written an OData service for a HANA calculation view and I am trying to filter the output using the OData service $filter. The filters should alter the result based on:

  • A date range - $filter=date ge datetime'2012-01-01' and date le datetime'2012-12-31'
  • A list of ids - id eq 1 or id eq 2 ....

I expected that changing the date range or the list of ids would alter the result but the result is remaining the same irrespective of the values passed in through the $filter. I also tried creating two calculated columns for the date range, i.e. DateFrom and DateTo to see if it would help.

I created variable in HANA Studio to test the output and the view performs as I would have expected but I'm not sure how to recreate the effect in an OData URL.

Does anyone have a solution for this issue? Any help with this issue would be gratefully appreciated.

Kind regards,

Martin.