Unanswered

Unable to Set Many-to-Many Relationship with mspp_ Virtual Tables in Enhanced Data Model

(0) Share

Report

Posted on by Gturro_tflow

Hello,

I've recently transitioned to the enhanced data model and observed that the web role table is now virtual (prefixed with mspp_). In my previous portal setup, I had a many-to-many relationship between contact and web role. However, with this new model, I've noticed that this relationship isn't established by default.

Is it a known limitation that many-to-many relationships cannot be created with mspp_ virtual tables in the enhanced data model? If so, are there recommended workarounds to achieve similar functionality?

Thank you for your insights!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Gturro_tflow 4 on at

Like (0)

Report
Copy link

Link copied!

I found the solution:

using web api:
/contacts({{user.id}})?$select=contactid&$expand=powerpagecomponent_mspp_webrole_contact($select=componentidunique,name)
If you want more information about this feel free to reply.

Guillem

Was this reply helpful? Yes No
Khonzi 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Guillem

I have virtual tables from SQL and I don't have many-to-many option. I have a mapping table in SQL for the many-to-many relationship. Can I use your method to 'simulate' a many-to-many relationship?

Was this reply helpful? Yes No