Smart Notification Stored Procedure

Sort:
You are not authorized to post a reply.
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
    I am using a stored procedure, which has a declared variable, which is being contrained on in the where clause of the stored proc. Here is a crude example.

    Select *
    from title
    where token = @token


    I want Smart Notification to prompt me to enter a valid string for this variable. Can I do that with SmartNotes.


    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      the question is do you want the Admin that i updating/processing the infoset to be prompter or do you want the user who is viewing a Notification to be able to enter a value to filter the notification? If the former, its very simple. If the later, its very complicated and its easier to not to use data side filtering if your data set isnt hundreds of rows. If it is it will be a bit complicated. Let me know if this is the preferred method (server side filtering initiated by end user of Notification) and ill try to shed some light on it.
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Layne
      Basic Member
      Posts: 24
      Basic Member
        I just would like to be prompted with a list of values to choose from that will be sent to the stored procedure variable used inside the where clause.
        ..
        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
          Still need to know where you want to be prompted, when the infoset is updated or in the dashboard where the notification will be published? If in the infoset then your SQL should look something like this:

          Select *
          from title
          where token = [token]

          If the other, its much more complicated.
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          You are not authorized to post a reply.