Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Needs review
Created by Guest
Created on Dec 21, 2023

Convert/provide a version of the Stored procedures as SQL functions for greater flexibility

Given the move away from being able to have custom stored procedures with the new 2023 DI server, it would be good if some of the provided stored procedures were converted to SQL scalar value functions as these provide greater flexibility in their use. Scalar value functions can be used in select statements making it easier to implement conditional logic. i.e.

SELECT CASE '$EDIT#SOME_ATTRIBUTE$'

WHEN 'X' THEN GET_PW_VALUE_FUNCTION('$EDIT#PARAM_1$')

ELSE GET_PW_VALUE_FUNCTION('$EDIT#PARAM_2$')

END