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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Guido Preite 54,084 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)

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No