Reporting from WSS - field schema?

S

Steve

Hi, I need to report on custom fields I have set up against Risks and Issues
etc. Which table in which database will hold these new fields?
 
R

Ray McCoppin

The date for these fields is stored in the WSS centent DB(s). in the
AllUserData table each data type has a limited number of fields 1 to x
for example text fields are stored in ntext1-4.
I have not found the exact location of the metadata that defines the custom
fields names and values location. But as long at the template does not
change you should be ok accessing the fields directly.

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 Automation Tool.
SRS gantt charts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic hover/help texts based on Schema annotations? 0
MS Project Center-Autolink column fields 0
How to have two tables on same line? 1
WSS (STS) Risk and Issue Tables Schema 4
Project Commentary - Best Practice? 1
ASK Field Formatting 1
Table Name for Weekly Status 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top