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

Gerard Mengerink

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.

Comments

2 comments

Date Votes
  • Comment author
    Naama Aharoni
    • Official comment

    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

  • Comment author
    Kevin Cunningham

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

    0

Please sign in to leave a comment.