WSS (STS) Risk and Issue Tables Schema

[MED]

I need to access the Risk and Issues tables in WSS (STS) for MS-Project
Server 2003. Where Do I find the Tables schema and field descriptions to
access WSS (STS) directly from Business Onjects.

 

[Scott m Wagner - EPM Consulting Services]

MED,

There are "issues and risks" associated with direct access to the issues and
risks tables (haha!!). I would refer you to the wss sdk here for information
as i believe it better to get to the data in a programatic way.:

http://www.microsoft.com/downloads/...e5-daee-4d10-980f-789b827967b0&displaylang=en


Hope that helps

 

[MED]

I understand the "risks and issues", ha ha. But Business object does not
write to the tables, so what is the big deal. I need access to the live data
from the BO universe to develop more professional looking reports. SO I ask
again, where can I get a schema, please??????????

 

[Scott m Wagner - EPM Consulting Services]

MED,

To my knowledge there is not one available. Check with Heather Solomon, she
is a SharePoint MVP. Here is her blog address:

http://www.heathersolomon.com/Blog/

 

[jbf1]

But Business object does not
write to the tables, so what is the big deal. I need access to the live data
from the BO universe to develop more professional looking reports. SO I ask
again, where can I get a schema, please??????????

The SharePoint table schema is designed so that SharePoint lists are
extensible without changing the schema of the tables containing the
data. So there are a bunch of mappings/redirections used to store
which column contains which data. If you are certain you want to
report on the WSS v2 tables directly, expect to do a moderate amount
of reverse engineering. Here's an article to get you started. While it
references SQL Reporting services, the bulk of the article deals with
the schema of SharePoint tables.
http://www.teuntostring.net/blog/2006/03/update-reporting-over-sharepoint-lists.html


I've written some reports on these for clients and they were not
trivial...
James Fraser