Service layer with userdefined query

[Former Member]

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

[Trinidad]

Hi Khanh,

SL 9.3 PL02 has been just released and contains a new feature that allows to run Semantic Layer views from Service Layer (system or custom views added to B1 Semantic Layer). Here you can access the blog with more details and a pointer to the documentation:

https://blogs.sap.com/2018/02/01/new-sap-business-one-semantic-layer-view-exposure/

In B1H 9.2 version the only options are to use either the B1 xApp Framework:
1858188 – Extreme App Framework for SAP Business One: Samples and Documentation (S-user required)

or to create a HANA XS xsodata access.

Hope it helps
Trinidad.

[Former Member]

Dear Maria,

I will research your topic. It way is a lot helpful.

Thank you for your answer!

[rchougui]

Hello Maria,

Is it planned for the future to have some sort of user defined queries support in the service layer ? Otherwise what would be the best practices to extend the Service Layer in order to use it with custom queries.

We tried using the Script Engine for service layer to create extensions and deploy them using the extension manager, but it wasn't very practical to us, since every single object needed to have its own script and testing each script required us to create the ard file and deploy the script

Thank you very much,
Riadh.