Customer experience | Sales, Customer Insights,...

Advanced Find

(0) Share

Report

Posted on by PS10

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

All responses (4)

Answers (0)

PS10 428 on at

Like (0)

Report

Advanced Find

Thank you Leah Ju, for taking out time, really appreciate.
Leah Ju Microsoft Employee on at

Like (1)

Report

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 428 on at

Like (0)

Report

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 Microsoft Employee on at

Like (1)

Report

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