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

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

RE: View for Tickets without any active Activities

I will try and send you an update here.

Thank you !
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: View for Tickets without any active Activities

to be honest, I am clueless at the moment. few more thigs:

1. are you able to reproduce this on your other environment i.e DEV, UAT?

2. you could try to look into the xml of this view creating a solution , adding this view to it. --> export the solution > extract the files > open customizations xml and see what condition you see under query of this saved view under the entity tag.
Community Member on at

Like (0)

Report

RE: View for Tickets without any active Activities

Still get the same results...
Community Member on at

Like (0)

Report

RE: View for Tickets without any active Activities

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

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

Rawish Kumar 13,758 on at

Like (0)

Report

RE: View for Tickets without any active Activities

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.
Community Member on at

Like (0)

Report

RE: View for Tickets without any active Activities

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
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: View for Tickets without any active Activities

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.
Community Member on at

Like (0)

Report

RE: View for Tickets without any active Activities

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

Like (0)

Report

RE: View for Tickets without any active Activities

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
Rawish Kumar 13,758 on at

Like (0)

Report

RE: View for Tickets without any active Activities

ignore me! I miss understood the question.

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