Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Subgrid for Security Roles in Systemuser doesn't work RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have customized a subgrid on the systemuser form for the "security role" relationship.

    But this subgrid doesn't show any data. As view I have set the default "All Security Roles".

    It also doesn't matter if I set the subgrid settings on "All Records" or on "only Related" in both cases the subgrid doesn't show any data. - WHY?

    The default "security role" node on the left side works.

    The same subgrid for the field level security profile works perfect.

    Has anybody a solution or workaround for this?

    Regards

    Matthias

    Monday, July 16, 2012 2:12 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have just set the ViewSelector to show all views.

    In this case it's possible to select further views in grid on the form. Also the systemview

    "Role Associated View"  If I select this view in the grid during runtime the roles are correct displayed!!!

    What are the differences between this views? It's not possible to select the views of the role with the SavedQuery Editor.

    If I select the fetch XML in the savedQueryBase table of the SQL Server the fetch show no special filter

    <fetch distinct="false" mapping="logical">
  <entity name="role">
    <attribute name="name" />
    <attribute name="businessunitid" />
    <attribute name="roleid" />
    <filter type="and">
      <condition attribute="roletemplateid" operator="ne" value="{2D101BB3-5CED-4122-83F1-94D5EFDE4E3B}" />
    </filter>
    <order attribute="name" descending="false" />
  </entity>
</fetch>

    Monday, July 16, 2012 2:19 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Matthias,

    Associated views are present one each per entity and can't be modified. If it solves your end goal, write a script on user form load which sets the view on the subgrid to the Associated view.

    Regards,

    Mayank

    • Proposed as answer by MayankAgrawal Monday, July 16, 2012 3:45 PM
    • Unproposed as answer by Matthias Back Wednesday, July 18, 2012 3:32 PM
    Monday, July 16, 2012 3:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Mayank,

    thank you for that hint. But changing the subgrid view in the onload is possible but not supported.

    Actually I does know any supported api for the subgrid control. I you have one, please inform me.

    Or vote for a supported way of subgrid filtering.

    https://connect.microsoft.com/dynamicssuggestions/feedback/details/753241/addcustomview-to-subgrid

    OK, I think that I have to remove the subgrids and work with the default left nodes

    • Marked as answer by Matthias Back Monday, July 23, 2012 3:44 PM
    Wednesday, July 18, 2012 3:41 PM