Resolving a 1:n Association to a single row
I have a requirement wherein there are 2 BOs, and the first BO has a 1:n association to the other BO. On the UI, I want to show fields from both the BOs in ONE row, but after resolving 1 particular instance.
For eg: If the 2nd BO has 3 records, and only one of them is valid for the period I login, I should pick up only that record and show its fields along with other fields of the first BO.
ID, Desc, Type ID, BO1 ID, Current valid Indicator Amount
01 Test1 A 1, 01, True, 1000
2, 01, False, 2000
3, 01, False, 3000
ID Desc Type ID Amount
01 Test1 A 1 1000
Although there are 3 records for the ID 01 of the BO1 via association to BO2, I should pick up only the first record to show on the UI. How should one resolve a 1:n association in UI designer ?