Valid values on item placement - sql query length limitation Completed

Ben Brearley

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

Comments

3 comments

Date Votes
  • Comment author
    Rasmus Jensen
    • Official comment

    Added to internal todo but not yet planned

  • Comment author
    Balakumar Viswanathan

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

    Regards,

    Bala

    0
  • Comment author
    Rasmus Jensen
    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 :-)
    0

Please sign in to leave a comment.