Skip to Content

Filters and select system query in xsodata service SAPUI5

Jan 11 at 03:59 PM


avatar image
Former Member

Hi experts,

currently i am facing issues with my xsodata service. It is created based on HANA calculation view. It has one collection with about 40 properties. I want to use filters and the select system query.

        var aFilter = [new sap.ui.model.Filter("YEAR", "EQ", "2016"),
                       new sap.ui.model.Filter("MONTH", "EQ", "12")];"/Collection", {
            "urlParameters": {"$select": "YEAR,MONTH"},
            "filters": aFilter,
            "success": (oData, response) => {

I expected this code snippet to just return the entries for the properties YEAR and MONTH where YEAR equals 2016 and MONTH equals 12. I expect about 7500 entries but only receive one. also when i comment out the "filters" I only receive one entry.

Has anybody suggestions?


10 |10000 characters needed characters left characters exceeded

Have you checked already that your service does what you want w/o using UI5, e.g. using a tool like Postman. Just to be sure, that the base (calc. view, odata service) is fine?


Hi Benjamin Schmitz,

Could you check if you have implemented filter in your OData back-end.


Arjun Biswas.

Former Member

Filtering works fine. The select system query is not implemented correctly I guess.
Thanks for your comments so far - I will update you when I find a solution.


Former Member

By now i think the service works as it should be. It is the logic of the calculation view the service is based on. The result is an OData service which works different than the OData specification tells.

* Please Login or Register to Answer, Follow or Comment.

0 Answers