2 Replies Latest reply on May 16, 2013 8:37 AM by Ilmar Waldner

    How can I assign a calculated value as a parameter in a custom SQL statement?

    Ilmar Waldner

      From the login username I can create a calculated field that contains the user id as an integer.

      I want to pass this value to the custom sql statement which selects from a table valued function and returns that user's data.

      The sql statement works fine if I just give it a parameter which has that user id.. but how do i dynamically assign the value from the login to that parameter so that the logged in user's data is always returned?

       

      Thanks,

      Ilmar