Skip to Content
avatar image
Former Member

Service layer with userdefined query

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 02, 2018 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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01, 2018 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

    Add comment
    10|10000 characters needed characters exceeded

    • 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,