0
Answered

A question about transformations

Daniel Walters 10 years ago updated by anonymous 5 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.

Affected Versions:
Fixed by Version:

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" />

Yeah I think that would work. Thanks Adam.