Display multiple records from related business class

smodarressiyazdi

I have two user business classes: "TravelRequest" (TR) and "TravelRequestCities" (TRC). On the TravelRequest web form, users can input trip details for upcoming business travel, such as the Country, City, and Dates.

When a user submits the TR form, the City data is transferred to the TRC business class, which creates a record for each city entered. The trip data is not stored on the TR business class. Each TRC record also includes the symbolic key linking it to the corresponding TR record. A common scenario involves users visiting multiple cities or countries during a single business trip.

I need to display all the cities and countries submitted on the TR form. However, even though I am using one-to-many relationship where multiple records exist, only the first or last city entered is showing.

I would appreciate any guidance on how I can display all cities/countries from the TRC records, matching the symbolic key to the TR form.

balkenhol

There are two ways you could achieve this. 

The first way is to display a list for the TRCs that uses TRs in context of the form.  See the LPL for AsyncQueueDefinition.QueueDefinitionCompositeForm for an example form that contains both the form and the list of related items.  The benefit of this method is that it provides the user the opportunity to interact with the items on the list.

The second way is to create a derived field of type Alpha or RichText on the TR that loops through the set of related TRC records and builds text to statically display on your current form. See the LPL for the Position.LRCPositionDescriptionManagerSummary form.  It references a "DerivedEssentialJobAndPositionCompetencies" field.  This uses a relation on the for each loop, but you should be able to just use a TRC set there since the TR is within context.  Another useful example is the derived field "DependentsHoverOver" on the "EmployeeBenefit" business class.  For this, Infor is building CSV text on a set where the business class (EmployeeBenefit) is within context of the business class (DependentBenefit) used in the for each ... set loop.

Product Update Session, IPS, EAM, CS FSM, HCM-20200716 1701-1.mp4