You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-10-18 16:17:13

patgream
Member
24 posts

patgream said:

[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 [0..many] 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

Offline

#2 2016-10-19 08:03:54

patgream
Member
24 posts

patgream said:

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

I finally found.

Offline

#3 2016-12-21 04:52:29

willm
Member
477 posts

willm said:

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? 

Offline

#4 2016-12-21 13:52:42

patgream
Member
24 posts

patgream said:

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

willm wrote:

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy