Customer experience | Sales, Customer Insights,...

Advanced Find

(0) Share

Report

Posted on by PS10

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PS10 8 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
PS10 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you Leah Ju, for taking out time, really appreciate.

Was this reply helpful? Yes No