CRM Small Tip: (Advanced Find for Activities)

“How to Find cases where activities (emails, phone, task etc.) modified last 1 month?”

Above is the question, One of our customer asked me last week and they wanted to do advanced find on cases and find out the cases which have activities (emails, phone, tasks, service activity etc…) created/modified in last 1 month.

Now I first thought was this is not possible through standard advanced find because I thought you can do condition with multiple entities (email, task etc.) but there is no way we can do OR conditions for multiple entities in dynamics advanced find screen.

But then realized that all activities are derived from the same base activity class, so we can use that and turn out there is already field called “Last Updated” (date field) on activity..

So turn out this is really simple advanced find as per following screen print.

Cheers,
MayankP 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s