Skip to main content
challa1-Visitor
1-Visitor
Apr 2, 2018 8:09 AM UTC
Question

Dashboard with js, business logic and services to RDBMS

I want to build a dashboard with a small business logic layer underneath and then push the data to Mysql. I know how to do the mash up UI. I got the Mysql configured and able to show the data in grid as well.

I want to know 

- How to link button actions to services with js

- How to build a service layer underneath UI and database

Any help would be appreciated.

5 replies

supandey5-Regular Member
5-Regular Member
Apr 3, 2018 9:30 AM UTC

Hi @challa do you mean clicking of button should invoke certain service? Some like this 

03-04-2018 11-25-33.jpg

 

With this you should be able to invoke required services.

 

Sorry i'm not really following your 2nd question "How to build a service layer underneath UI and database"

 

Though you can create services using query handler like SQL Command/ SQL Query i.e. if you are looking to query DB pull certain data and show that in the UI on mashup. These handles are available when you'll create a Thing based of DatabaseThingTemplate

Translate
    challa1-VisitorAuthor
    1-Visitor
    Apr 20, 2018 5:01 AM UTC

    what i meant with my second question is that if i want to validate/filter certain fields before sending to database. Can i write that on the js editor and call another service once filtering is done

    Translate
    LeighEmeritus
    Emeritus
    Apr 19, 2018 3:29 PM UTC

    Hi @challa

    Just wanted to follow up to see if Sushant was able to answer your questions.  If so, please indicate his response as an Accepted Solution for the benefit of the rest of the Community.  If not, please let us know your current status.

    Thanks!

    Leigh

    Translate
    Terms & ConditionsAccessibility statement