Pass SQL Variable from Validation to Universal Function

Completed

Rasmus Jensen

• November 16, 2014 14:26

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

Vote

9

• Official comment

  

  Rasmus Jensen

  • October 24, 2017 15:47

  Added in B1UP 2017.09
• 

  Jay Cheah

  • August 07, 2016 06:27

  I vote for this functionality too, if it hasn't already been implemented.
• 

  Chris Clos

  • October 18, 2016 14:12

  Just had a use case very similar with this.  
• 

  Stephanie

  • March 15, 2018 18:16

  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
• 

  Rasmus Jensen

  • May 04, 2018 04:52

  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

Please sign in to leave a comment.