MashZone / Data Feeds / User Input field

Posted by Nikolai Chmatov

Posted on Fri, 03/31/2017 - 17:31 in MashZone

Hi Folks,

I need some example of how "User input text" at data feed's level can be linked to the field at the dashboard level.
My data source is SQL Server and I need to call sp procedure and dynamically pass the parameters.

Thanks,

Nikolai

dashboard

MashZone

15.2k

by Jiri Mares

Posted on Tue, 04/04/2017 - 06:25

It's quite easy to build up a sql commands with user input fields to have some more dyn. capabilities for the end users, but I'd need to check how (and if even) it works with stored procedures.

Could you share in meanwhile an example of your code and highlight the part(s) with your dyn. parameters? Just to see more details.

by Nem Stewart

Posted on Tue, 04/04/2017 - 08:12

Although I have never used SQL server and sp procedures, I have used "user input text" within my data feed to dynamically pass parameters. If this would help, I can put some info together for you.

by Nikolai Chmatov Author

Posted on Tue, 04/04/2017 - 21:01

Here is the simple quesy:

EXEC sp_PROCEDURE @Parameter1, @Parameter2

I can use User Input element to compile required SQL Statement, but question is - how I link that User input with any element (say drop-down box) on dashboard?

Thanks,

Nikoilai

MashZone / Data Feeds / User Input field

Featured achievement

Leaderboard

Follow us

View posts by tag