Pass SQL Variable from Validation to Universal Function

Completada

Rasmus Jensen

• 16 de noviembre de 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

• Comentario oficial

  

  Rasmus Jensen

  • 24 de octubre de 2017 15:47

  Added in B1UP 2017.09
• 

  Jay Cheah

  • 7 de agosto de 2016 06:27

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

  Chris Clos

  • 18 de octubre de 2016 14:12

  Just had a use case very similar with this.  
• 

  Stephanie

  • 15 de marzo de 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

  • 4 de mayo de 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

Iniciar sesión para dejar un comentario.