[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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads