Reporting on Open Problems with All Problem Tasks Closed

[shaneor]

Hi there,

I have been trying to report on Open Problems with All Problem Tasks Closed

I created a database view that joins the Problem to Problem Task table

The report I'm currently running isn't entirely accurate as it returns some problems where one of the Problem Tasks is Closed Complete but the others may be Open

The filters for my current report can be seen below

Would Greatly appreciate any support you may have on this issue

Thanks a million,

Shane

[chirag_bagdai]

Hi Shane,

If you just want to find Open Problem tickets with Closed Problem tasks, You can create report on "Problem Task" per below screenshot :

For getting reference field in the filter you need to use "Show Related Fields".

[sb1186]

Hi Shane,

You can create this report directly using the problem_task table. You don't need a database view to achieve the result.

Try creating a report with the following specifications and let me know if it helps:

1) Table: Problem Task (problem_task)

2) Filter: State is one of (Closed Complete, Closed Incomplete, Close Skipped)

                            AND

                            Problem.State is not Closed/Resolved (click on Show Related Fields > Problem   > State)

3) Save and Run the report

PS: Mark this answer as Correct if it solved your query or hit Like/Helpful depending upon the usefulness of the response.

Regards
Supriya Bisht

[Kalaiarasan Pus]

What if a problem has no problem task?

[AKrumm]

I am trying to create a very similar report. The need to is to be able to list he Problems that are still open but either have no tasks or all tasks are closed. The above report will only show you the closed tasks but not the ones that may still open.