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,

[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.