1. UNIFYBroker Forum
  2. Questions
0
Answered

A question about transformations

Daniel Walters 14 years ago • updated by anonymous 9 years ago • 3

I've looked at the transformation pages already.

My question is

If you have two tables: People and Roles. There's a one to many relationship ie. a person can have many roles.

Is there a transformation that can return distinct People with a multivalued attribute that contains each Role? I think the answer is no but I'm not 100% certain and I don't want to advise the wrong thing.

Adam van Vliet 14 years ago

Are the table definitions like this:

Person
  • PK_PersonId
  • Name
Role
  • PK_RoleId
  • FK_PersonId

If so, do you think something like this would work?

<adapterEntityTransformationFactory name="Relation.Group"
    InputKey="PK_PersonId"
    RelationshipConnectorId="{5A8BDEFD-7348-4f05-83AC-B9EE0082B2CD}"
    RelationKey="FK_PersonId"
    RelationReference="PK_RoleId"
    GroupTarget="members" />
Daniel Walters 14 years ago

Yeah I think that would work. Thanks Adam.

Daniel Walters 14 years ago

Question Answered.

Customer support service by UserEcho