cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

How to get data from a MS SQL SP to drive a Gauge Widget

dbryant
1-Newbie

How to get data from a MS SQL SP to drive a Gauge Widget

I have a sql Database connection with services. How do I get a Gauge Widget driven by data returned from a stored procedure? Does it need to have an output parameter assigned to the Gauge?

Any advice appreciated,

2 REPLIES 2
ttielebein
12-Amethyst
(To:dbryant)

David,

I'd recommend wrapping the stored procedure call in a Javascript service written on some helper thing in your application, and then bind this to your gauge widget. The service can receive the output from the database and output it in whatever format is needed for your mashup.

Hope this helps!

Tori

PaiChung
22-Sapphire I
(To:dbryant)

The Gauge widget accepts a BaseType Number for Data.

Your data from the SQL procedure will come back as an InfoTable.

As Tori said, either in your wrapped service you can output the required field/column as Number or just output the whole table (infotable) and grab the specific field to bind to the Gauge widget.

Besides that you will likely need a refresh widget to pull the value periodically (although in 7.2 it can be pushed)

Top Tags