[resolved] Search view composite with many to many relationship

Five Stars

[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

Accepted Solutions
Five Stars

Re: [resolved] Search view composite with many to many relationship

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

Pat

All Replies
Five Stars

Re: [resolved] Search view composite with many to many relationship

I finally found.

Four Stars

Re: [resolved] Search view composite with many to many relationship

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? 
Five Stars

Re: [resolved] Search view composite with many to many relationship

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

Pat