Skip to main content
C
challa1-Visitor
1-Visitor
April 2, 2018
Question

Dashboard with js, business logic and services to RDBMS

  • April 2, 2018
  • 2 replies
  • 3168 views

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.

2 replies

S
supandey5-Regular Member
5-Regular Member
April 3, 2018

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

    C
    challa1-VisitorAuthor
    1-Visitor
    April 20, 2018

    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

    L
    Leigh5-Regular Member
    5-Regular Member
    April 19, 2018

    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

    Terms & ConditionsAccessibility statement