Possibility to create Choose from lists in SQL report and UDT Handler

Respondida

Thijs Geeris

• 20 de septiembre de 2019 12:44

Currently it is not possible to link a table or a custom query to a field in an SQL report or in a UDT Handler. 

Example:

You have a UDT with BP and Item details. In the UDT you have BP code and Name and ItemCode and Name. In the UDT handler (or SQL report) you want to have a choose from list to look up all Items and Business Partners to fill out one BP or Item. Besides that you want the names to be automatically filled when the code is choosen.

Currently you can only assign a formatted search to the column, this work but atomatic triggering (filling the name) doesn't work.

So it would be nice to have an option to assign a default table or custom query (in case you need a lookup to another UDT) to a field in a UDT handler or assign it to a column in a SQL report

Vote

7

• 

  SSP Automation

  • 20 de septiembre de 2019 12:45

  Thank you for your request.
  The development team have now added it to our internal planning-system for evaluation.
  [Internal Id: 30406]
• 

  Dave Gutman

  • 20 de septiembre de 2019 12:58

  This seems similar to: 

  https://support.boyum-it.com/hc/en-us/community/posts/360030312993-UDT-Handler-ability-to-add-columns-to-grids

   
• 

  Thijs Geeris

  • 20 de septiembre de 2019 13:03

  Not totally the same as my request is about linking table/ queries to fields to create choose from lists or automatic population of data. In this post it is not explicity mentioned like this

Iniciar sesión para dejar un comentario.