Service layer with userdefined query

[#1]

Dear all,

Currenly i had used service layer to populate or manipulate data of hana system. The filter of api is not strong enough when coming to some customize query like Join multiple tables or get from store procedure, i have not found any api to support that.

It like when we using DI, recordset do query, it very useful.

Please share if you have any solution for this case.

Thank you and best regards,

[SergioG_TX]

i think the XS would be an easier approach as you can do a couple diff things:

1) odata - will allow you to query the data models, filters, filter operators, etc

2) if you can call a REST service, you have access to make it more customizable ... using either xsjs or if you have xsa, possibly nodejs or Java - this is a little more complicated as you have to do programming unlike if you used odata

[former_member335216]

Sergio is it avalable for HANA 1?

[SergioG_TX]

yes, xsjs and xsodata is availabe in HANA 1 and HANA 2 as well