Dropdown on a UDF, pointing to a standard SBO table (any)

Respondida

Gerard Mengerink

• 10 de agosto de 2016 12:53

SBO allows to link a UDF to a business object (but only standard SBO objects) or to a linked entity (but only UDT's). We would like to set a drop down on a UDF, that points to a standard table like OSLP (sales persons). The UDF should show the name, but "under the covers" it stores the primary key of the OSLP table.

Vote

0

• Comentario oficial

  

  Naama Aharoni

  • 11 de agosto de 2016 10:33

  Hi Gerard,

  Once you have placed the UDF in the main window using the Item Placement Tool, you can create a dropdown list for a UDF field in the valid values column using an SQL query. However, that query must have two values (which will be shown to the user) and those are code and name.

  
  
  

  Thanks, Naama
• 

  Kevin Cunningham

  • 27 de febrero de 2018 16:52

  Thank you Naama, this is exactly what I have been looking for.  Kevin Cunningham.

Iniciar sesión para dejar un comentario.