Valid values on item placement - sql query length limitation

Completada

Ben Brearley

• 12 de junio de 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

• Comentario oficial

  

  Rasmus Jensen

  • 24 de octubre de 2017 14:07

  Added to internal todo but not yet planned
• 

  Balakumar Viswanathan

  • 31 de julio de 2017 07:52

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

  Regards,

  Bala
• 

  Rasmus Jensen

  • 7 de noviembre de 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 :-)

Iniciar sesión para dejar un comentario.