Pass SQL Variable from Validation to Universal Function Completada
Here is an example of my development request:
I have a validation that has a SQL condition. In my SQL condition I execute a SQL function (example of sql below):
SELECT CASE WHEN dbo_ufn_myfunction(123) <> '' Then 'True' Else 'False' End
If the condition is true I want to execute a Macro Universal function to set a field = the results of my SQL function. The only way to do this now is to call the SQL function in my Macro again in combination with a set command.
Instead I would rather set a variable (e.g. @myvariable = to my SQL function results) in the validation. Then I want to pass @myvariable to the Macro Universal Function, so my set command could look like Set($[$38.1.0]|@myvariable). The results of this would be that I only have to query my database once which could make the Validation/Macro combination twice as efficient.
Regards,
Heath Gardner
Comentarios
5 comentarios
Added in B1UP 2017.09
I vote for this functionality too, if it hasn't already been implemented.
Just had a use case very similar with this.
Glad this has been implemented. Are there examples or where is it in the documentation? I can't seem to get it to work. Thanks!
Stephanie Gibbs
Sorry for the late reply (missed this comment). The feature is discribed at the end of this page: http://help.boyum-it.com/B1UP/theconditionsystem.html
If still confusion let me know and I will make a video sample of it
Iniciar sesión para dejar un comentario.