Create a new entity view with related table

(0) Share

Report

Posted on by GianlucaN

Hello,

I've one question.
I should create a new view on entity "Event Registration".
In this view I should add some column derived from contact that registered to the event.
No problem to do this.

But now i should add, in the same view, some column from the Account associated with this contact registered to the event.
I haven't a direct relationship between Event Registration and Account, my relation is indirect.
Event Registration -> Contact -> Account.

In SQL i can do something like this:
"select account.name, account.type, contact.email, contact.firstname, eventregistration.code
from
eventregistration inner join
contact on eventregistration.contact = contact.id inner join
account on contact.account = account.id"

Is possible to do this in entity view?

Thanks in advance

All responses (2)

Answers (1)

GianlucaN 6 on at

Like (0)

Report

RE: Create a new entity view with related table

Hello,

I assumed, unfortunately.

Thanks a lot for the answer
Verified answer

Guido Preite 54,073 Moderator on at

Like (0)

Report

RE: Create a new entity view with related table

Inside a view you can only go deeper one level (in your case from event registration to contact) you can't select a deeper level (in your case account). The only way is to replicate the information from the account to all the contacts (using custom workflow activity, power automate, plugins)