Forums

Forums / Developing Portals / N:N Subgrid

N:N Subgrid

4 posts, 1 answered
  1. Richard Funk_2
    Richard Funk_2 avatar
    14 posts
    Registered:
    28 Oct 2019
    06 Feb 2023
    Link to this post
    I am having trouble getting a subgrid to work with a many to many relationship and I cannot find documentation on any special configuration for this. When I add a subgrid widget to a form, I can select the many to many relationship on the data tab. However, when the page loads, the grid says "There was an internal error retrieving the data, please try again later." In browser dev tools, I see the following error: "xxx_EntityName entity doesn't contain attribute with Name = xxx_idattribue". This seems to me like its looking for a 1:N relationship but the relationship I selected while configuring the subgrid widget is for the N:N relationship. Is there a trick to displaying a many to many subgrid on a form?
  2. Tom Pawelec
    Tom Pawelec avatar
    25 posts
    Registered:
    21 Oct 2022
    Answered
    07 Feb 2023 in reply to Richard Funk_2
    Link to this post
    Hi Richard,

    It looks like this was a known issue and was also fixed in TPC build 140.

    6.1.0.140
    - Resolved an issue with Sub-Grid fetches that prevented custom N:N related entities from displaying on the frontend.

    Regards,
    Tom

  3. Richard Funk_2
    Richard Funk_2 avatar
    14 posts
    Registered:
    28 Oct 2019
    07 Feb 2023 in reply to Tom Pawelec
    Link to this post
    Hey Tom,

    Here is what I show as portal connector version in my environment: v6.1.142.134.

    Thanks,

    Rich
  4. Tom Pawelec
    Tom Pawelec avatar
    25 posts
    Registered:
    21 Oct 2022
    08 Feb 2023 in reply to Richard Funk_2
    Link to this post
    Hi Richard,

    It looks like you are on build 134 so you will have to update to at least build 140 where the known issue was fixed.

    If you require assistance updating you can open a case by emailing support@crmportalconnector.com

    Regards,
    Tom
4 posts, 1 answered