Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Advanced Find

Posted on by 428
Hi all
 
We are D365CE on-premise 9.1.
 
We have meetings (1) and meetings attendee entities (N) with 1:N relation. On meetings form i have also added a subgrid to add meeting attendees.
 
Now i want to run advanced find query to find all meetings where meeting attendees contains data but this query never works and i keep getting error.
 
My questions are:
1) What the reason of error
2) If advanced find doesn't work for 1:N relationship which is the case here, than, how can i find such meetings where meeting participants contains data.
 
Thank you
PS
  • PS10 Profile Picture
    PS10 428 on at
    Advanced Find
    Thank you Leah Ju, for taking out time, really appreciate. 
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Advanced Find
    Hi,
    If you want to make Meeting Attendees as a Regarding option:
    1)Meeting should be Activity entity.
    2)  Meeting(N) and Meeting Attendees(1) should be N:1 relationship.
     
  • PS10 Profile Picture
    PS10 428 on at
    Advanced Find
    Hi Leah
     
    Thank you for testing this out , that is what i was expecting but for some reason I keep getting error and not just in Production but also in other non-prod environments.
     
    I will investigate further. 
     
    Could you also check that on advanced find when you add related columns due you see Meeting Attendees as a Regarding option?
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Advanced Find
    Hi PS10
    It should be achievable, here is my test procedure:
    1.Meeting and meeting attendee:
    2.Sub-grid:
    3.Records:
    4.Advanced Find:

    I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
    Regards,
    Leah

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans