how to Create a Database view joining problem_task and Attachments( Sys_attachment) table

[Vidya Aeil]

Hi All,

To do this I'm trying to create a database view joining the problem_task and Attachments( Sys_attachment) table. Need a report view that displays the count of all closed problem tasks containing attachments, Now how do I filter the sys_attachment table to only show closed problem_tasks? I can see problem_task but how do I know if they are closed.

So I need  to build a database views on this table  sys_attachment AND problem_task. Please give me the some suggestion to this.

Thank you.

Vid

[palanikumar · Accepted solution]

Hi @Vidya Aeil ,

Is the response answers your question? If yes please mark my response as accepted solution and close the thread.

Thank you,

Palani