Microsoft Dynamics CRM (Archived)

View for Tickets without any active Activities

(0) Share

Report

Posted on by Community Member

Hello everyone,

i am trying to create a View that shows all the open Tickets with no active Activities regarding to it.

I tried to filter by Activity Status but that does not work at all.

Does anyone have a solution for this?

Thank you

Julian

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report

Hi Julian,

In advanced find you can very easily do that :

however the same is not available in normal view filter which is i know sad.

https://community.dynamics.com/crm/f/117/t/309584

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (1)

Report

Try the following query?

Only issue with this query is that it will not return the cases that have no activity created at all. If all your cases will have at least one activity, then the above query should work fine for you

Was this reply helpful? Yes No
Rawish Kumar 13,758 on at

Like (0)

Report

ignore me! I miss understood the question.

Query provided by Kokulan should work. Let us know the outcome.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Almost :)

I do have a Ticket with Activities regarding to it but they are all completed.

Now i want to filter all our Tickets that could be closed because there are no more Open Activities

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I allready tried this one. But it does not work. It still shows Tickets with Open Aktivities :/

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Julian,

what is the definition for you of a "Close activity" , is there specific status you are looking for.

because with above query under any circumstances you will get a case with open activity.

not sure if this make a different but Another suggestion would be to look for specific actitvity such as phone call or email etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

My filter should be like this.

But what i get is like this.

Top Activities=Open

Bottom = completed

I get Tickets with Activites that do have Status OPEN

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Okay if you have filter what you have posted - it should not bring the open activity.

is it happening with just this activity or it happens frequently?

Edit the view again - publish properly - log out and login again. also try to clear cache or change browser. see if that works.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It happens for a lot of activities. I guess 150+

I i will try to publish, log out/in and clear cache.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Still get the same results...

Was this reply helpful? Yes No