Business object relation / dynamic filtering between 2 Databands
Posted: Fri May 15, 2020 9:31 am
Hi,
Is there any option to manually create a relation between business object or somehow manually create a Master/Detail relation dynamically
If have the following independent Objects
ROOMS
- RoomId
- Name
NOTES
- ReferenceId (could be a RoomId)
-Text
In Databand1: Business Object: ROOMS
--this prints now all the rooms
Databand 2: --- here i would like to print NOTES, if RoomId and ReferencedId are the same
I tried to to this with a Databand2 Filter (Value - string - Column: Notes.ReferenceId - Equals ROOMS.RoomID )
- but this didn't work
Any way to achieve this?
Is there any option to manually create a relation between business object or somehow manually create a Master/Detail relation dynamically
If have the following independent Objects
ROOMS
- RoomId
- Name
NOTES
- ReferenceId (could be a RoomId)
-Text
In Databand1: Business Object: ROOMS
--this prints now all the rooms
Databand 2: --- here i would like to print NOTES, if RoomId and ReferencedId are the same
I tried to to this with a Databand2 Filter (Value - string - Column: Notes.ReferenceId - Equals ROOMS.RoomID )
- but this didn't work
Any way to achieve this?