Filtering out contacts with notes on specific dates

(0) Share

Report

Posted on by Galil Sales

Hi Everyone,

I have a list of contacts in which I want to filter out only those who contain notes documented, say, 6 months ago.

Thing is, when I do that I also get contacts with recent note activity (during the past 6 months).

Can anyone advise?

Thanks.

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Eiken Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please refer to my following Edit Filter

Then click apply.

Was this reply helpful? Yes No
Galil Sales 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eiken,

Thank you for your reply!

Unfortunately, that's what I did before - the list that was generated contains contacts with note activity both from 6 months ago and from last week (for example).

Since there is no "NOT" operator, I'm not sure what to do.

Any other suggestions?

Thanks you!

Was this reply helpful? Yes No
Suggested answer

Eiken Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Would you please show me your screenshot about your edit filter?

It will help me a lot.

Was this reply helpful? Yes No
Galil Sales 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure, attached.

Was this reply helpful? Yes No
Suggested answer

Eiken Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You would need to use custom FetchXML to create these searches and views.

Please refer to the following link.

Creating System Views with complex “NOT IN” filter in Dynamics 365 for Customer Engagement (arbelatech.com)

Was this reply helpful? Yes No
Galil Sales 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eiken,

I finally got around to installing XRM ToolBox and connecting it to the MSD CRM.

Unfortunately, I can't find the views I saved (only general ones) and my views include attributes which don't exist in the FetchXML Builder.

Any ideas?

Thanks!

Was this reply helpful? Yes No