[resolved] Search view composite with many to many relationship
Hi all,
I have a simple model with Customer, Address, CustomerAddress. Relation N-N between Customer and Address (aggregation) is declared in Customer : Customer/AddressList String with foreign key to Address. Is it possible to create a search view to retrieve Customer fields and list of attached adresses ?
Thks,
Pat
Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view?
Hello Willm, nothing special I have just made a view like this :
=> Customer properties
Customer/CustomerId
Customer/CustomerName
...
=> Customer adresse relation properties
Customer/AddressList/AddressLabel
Customer/AddressList/AddressTypeOf
...
=> Adresse properties
Address/AddressId
Address/AddressIdEM
...
and I add the followinf join :
Customer/AddressList/Address join with Address/AddressId
Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view?
Hello Pat - did you have to do anything special to get this to work? Curious if this is any different from what you'd normally do for a composite view?
Hello Willm, nothing special I have just made a view like this :
=> Customer properties
Customer/CustomerId
Customer/CustomerName
...
=> Customer adresse relation properties
Customer/AddressList/AddressLabel
Customer/AddressList/AddressTypeOf
...
=> Adresse properties
Address/AddressId
Address/AddressIdEM
...
and I add the followinf join :
Customer/AddressList/Address join with Address/AddressId
