i want to create report on two tables incident and problem which state is closed how to do it

[ashwitham]

i want to create report on two tables incident and problem which state is closed how to do it

[Uncle Rob]

Problem and Incident have two different state models.

[Anand Kumar P · Accepted solution]

Hi @ashwitham ,

you can create list report on task table and group by Tasktype, add filters like below task.type is incident and state closed another set of conditions with task.type is problem and problem state is closed.

Or 

Create a databaseview with below joins in related list

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand

[Anand Kumar P · Accepted solution]

Or 

Create a databaseview with below joins in related list

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand

[Community Alums]

Hi @ashwitham ,

To create a report on both Incident and Problem tables where the state is "Closed", you can use one of these methods:

1. Database View:

   • Create a database view joining the Incident and Problem tables with the condition state = Closed.
   • Use this view as the data source for your report.
   • join condition exaple 

incident.state = "Closed" AND problem.state = "Closed"

• Multi-Dataset Report:

  • Create a new report with the type Multi-Dataset.
  • Add Incident and Problem datasets with filters: State is Closed.

• Scripting (Advanced):

  • Use GlideRecord to fetch data from both tables and merge them into a custom output.

The Database View method is preferred for native reporting.