Valid values on item placement - sql query length limitation

Completed

Ben Brearley

• June 12, 2017 03:04

Using SQL query in item placement tool valid values is a useful feature, but the field is limited in length so more complex queries cannot be entered here - can the field length on the valid values column of item placement please be extended.

Valid values can be triggered in a macro however this is additional configuration and also sometimes troublesome to get working with the correct validation trigger i.e. sales opportunities that only allow the card code to be populated before anything else on the screen can be accessed. meaning you must put the trigger on field validation / lost focus but also on switch to find etc

Vote

0

• Official comment

  

  Rasmus Jensen

  • October 24, 2017 14:07

  Added to internal todo but not yet planned
• 

  Balakumar Viswanathan

  • July 31, 2017 07:52

  Possible workaround is to create a SQL VIEW and use that VIEW in Valid Values :)

  Regards,

  Bala
• 

  Rasmus Jensen

  • November 07, 2017 13:43

  The development team has now completed this request. Expect it to be in the next release of the product. Thank you again for helping us make the product better :-)

Please sign in to leave a comment.