HOWTO: get a projectserver view in a Recordset

[Merijn Boom]

Hi,

Hopefully I'm right in this group by posting a
projectserver question?

Anyway I would like to know how I can retrieve a
projectview in a Recordset. Whay I mean is the following:

Login to projectserver
Go to projects (top nav)
On the right you can select a view
I would like to know how I can get the fields and data of
that view (or any made by a user) in a by us created
storedprocedure

Could anyone help me out?

Thanks in advance,

Merijn

 

[Rod Gill]

Hi,

Simplest way is to create your own Views in SQL server based on the MSP_VIEW
tables.

 

[Merijn Boom]

Hi Rob,

Thank you for your answer. But could please help me a bit more? I mean I
created a view (descibed below) but I can not find the view name back in the
tables. Where can I find that specific viewname from where I could get the
attached fields etc,

Regards,

Merijn

 

[Rod Gill]

Hi,

Look in the list of Views, not tables! Use Query Analyzer, Enterprise
Manager or an Access project linked to the database to view tables, views
etc.