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]

Do the following:

1. Create Database View
2. Add first table as problem_task with variable prefix as prb
3. Add Second table as sys_attachment with variable prefix as attach
4. set condition in second table as below:

             attach_table_name=problem&&attach_table_sys_id=prb_sys_id

Thank you,

Palani

[Vidya Aeil]

4. 

1. set condition in second table as below:

             attach_table_name=problem&&attach_table_sys_id=prb_sys_id

This is I need to put in Where clause Right 

Thank you.

Vidya

[palanikumar]

Please us this in the where clause. I tested in my PDI, it is working fine

attach_table_name="problem_task"&&prb_sys_id=attach_table_sys_id

[Vidya Aeil]

Thank you Palani .