Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / Filter in Subgrid View...
Sales forum

Filter in Subgrid View with field from the data record that I have open at the moment

Posted on by 2

Hello Community,

I have a problem regarding filtering in Subgrid View on a Form.

Following situation:

On Account we have a look up to a custom entity (CCP).

On this custom entity (CCP) we wont to show all opportunities that belongs to the related accounts. 

I tried to solve this with fetchXML, but im not sure, if this is the right way. Or when fetchXML is the right way, what does this look like.

Thanks in advance

BR

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,319 Moderator on at
    RE: Filter in Subgrid View with field from the data record that I have open at the moment

    Hello,

    In this case, you will have to use the second "code" way as far as I can see.

  • cusher Profile Picture
    cusher 2 on at
    RE: Filter in Subgrid View with field from the data record that I have open at the moment

    Hi Andrew,

    thanks for your answer.

    Your first described way is only possbile, when i have lookups between the entitys? In my case i have an N:N-Relationship between Accounts and CCP and also between Accounts and Opportunities. Is there also a simple way to solve this issue with this conditions i have?

    BR

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,319 Moderator on at
    RE: Filter in Subgrid View with field from the data record that I have open at the moment

    Hello,

    Check my post that describes 2 possible ways you can try - butenko.pro/.../

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans