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
David Humpherson
