Skip to Content

Service layer with userdefined query

Feb 01 at 01:46 PM


avatar image
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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sergio Guerrero Feb 02 at 04:20 PM

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

10 |10000 characters needed characters left characters exceeded
Maria Trinidad MARTINEZ GEA
Feb 01 at 02:11 PM

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:

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Dear Maria,

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

Thank you for your answer!

Former Member

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,