Visual Builder

Get Involved. Join the Conversation.

Topic

    Sherwood Daniels
    Display reference or combo box in table
    Topic posted March 6, 2018 by Sherwood Daniels, last edited March 7, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code, Database, REST 
    87 Views, 1 Comment
    Title:
    Display reference or combo box in table
    Summary:
    Display reference or combo box in table
    Content:

    I am developing a VBCS app where the data comes from a DBaaS instance. I access this data via REST API. Not sure if this is relevant but thought I'd mention it.

     

    I have tables that reference foreign keys. The foreign key is a sequence number generated by the database. Obviously the users would rather see business values than these sequence numbers. I have created References that provide user-friendly values for the foreign keys. On detail pages I can use a list box to display the user-friendly values.

     

    Is there a similar strategy that I can use for tables? I don't see a way to define which control is used to display a data field in a table. Dragging-and-dropping any of the controls from the palette is being rejected for tables.

     

    Attached is a pic of representative page. The Group and Mapping columns are pointed to the references. In Development mode they show up as blanks.

     

    Thanks in advance for your help.

    Comment

     

    • Shay Shmeltzer

      One option to consider is to include the translated value in the original query on which you base the table.

      So basically have two fields - one is the code and one is the translation in the query (which will use a join) - then in the table you can show the translation instead of the code.