NC

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

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.

1
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.

1
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

 

1

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock