PBI 4565 - Feature Request - Universal Function SQL Condition/Decisions

Not planned

Chris Clos

• August 23, 2016 16:13
• Edited

Would like to see Universal Function like Line Loop is but work on header data.  

I am finding that I have multiple Validations that reference the exact same SQL statement (and results function to execute) - Would like to have these in a single UF so we do not have to update all validations.  This scenario happens when I want to have multiple Form Modes and Event combinations.

 

 

Vote

0

• Official comment

  

  Naama Aharoni

  • May 21, 2017 12:42
  • Edited

  Hi Chris,

  Our development department have reviewed your request.

  It is indeed a good concept, however, after checking the validity and the ability to implement it in B1UP we have come to the conclusion that it would make the B1 Validation much more difficult to understand and make it less usable. Therefore, it is not planned.

  Thanks, Naama 
• 

  Balakumar Viswanathan

  • August 25, 2016 08:45

  Hi Chris,

  I hope this can be achieved by using ; separators at Item ID column of B1 Validation system where we can do validations for multiple Items at Header Level.

  Regards,

  Bala
• 

  Chris Clos

  • August 30, 2016 16:18

  While you can do multiple Item ID's in the validation system, there's no way to do multiple Form Modes or Events.
• 

  Chris Clos

  • September 01, 2016 19:19
  • Edited

  Also I think it would be really beneficial to have a logic process that works using SQL as a UF (non line-loop) where it reacts just like the Line Loops do, just against the header.
• 

  Naama Aharoni

  • May 21, 2017 12:42
  • Edited

  Hi,

  Can you provide an example where this is beneficial? Some scenarios where you find this useful?

   

  Thanks, Naama

   

   
• 

  Chris Clos

  • November 03, 2016 14:42

  The scenario would be I need to run the same logic process when the Event is two different functions, one is Form Closing, another is Menu Click.   The ultimate goal is code re-usability - where it can be called from multiple different validations or other conditions within the SQL for a validation that net the same result. 

Please sign in to leave a comment.