Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Object Function Issues

edited Aug 5, 2019 4:48PM in Visual Builder 5 comments

Summary

Trying to get value of field in one BO based on ID in another BO

Content

Here is the situation.

I have an object function created on a DummyBO so I can iterate over multiple records in another BO.

I have no problem getting a unique list of values for the field I am interested in.  However, the values are the ids in a reference field to another BO that has the names associated with the ids.  I would like to get the values in the other BO which are the names.

The reason I am doing this is to develop a pick list for a field to search on a business object represented in the UI.  That business object used in the UI is a transaction BO so using a standard LOV directly on the BO returns duplicates of the field (e.g., all records) I am interested in.  So I decided to create a function on the object that would get a list of the unique values and then get the label/name from the setup business object.  If there is a way to list unique values using the wizard for the LOV,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!