About retrieving data from Issues?

[Dennis]

Hi all :

I would like to retrieve data from the table where the issues store
and create a report to show all the issues in all projects.

It would look like this :

Project Name Issue Assigned to Category DueDate
Discussion Solution

Project1 AAA John System
20051130 ABCDEFG Buy something
...
...

Project2 KKK Dennis Security
20051215 KKKKKK Development ..

Is there any way to achieve it?

Thanks & Regards,

Dennis

 

[William Raymond]

Yes. You need to access the WSS content database. Use the TP_ID as the
linkage. I will see if there are some sample queries to dig up for you.

-Bill