Project Center "Choose a View" Listing

C

Charles Simpson

Anyone know how one would go about rearranging the views listed in the
"Choose a view" drop-down listing in Project Center (alphabetically?)?

Running Project Server 2003 SP1

Thanks,

Charles L. Simpson
 
D

Dale Howard [MVP]

Charles --

I do not believe there is a way to rearrange the list of views on the Choose
a view pick list. Sorry.
 
C

Charles Simpson

Thanks Dale

Are you sure that this information isn't kept in the database somewhere. If
so, maybe we could find out how they are sorted and possible make some
changes.

Any ideas?

BTW: Saw you guys at the MS Project 2006 Conference!
 
D

Dale Howard [MVP]

Charles --

I do not believe the information is stored in the database in a manner that
users can change it. If I am wrong about this, I will gladly invite anyone
else to correct my error, and to tell how you to set the order of Views
listed on the Choose a View pick list. Hope this helps.
 
J

Jonathan Yong

If you are really desperate in sorting the view, there are 2 stored proc
that manage the retrieving of the views.

The 2 SP are
MSP_WEB_SP_SEC_GetAllResViewsByType and
MSP_WEB_SP_SEC_GetAllResProjectViewsByProject

To order view by name, add the following order clause at the end of the
SELECT statement:

order by wview_name


However, modifying the SP is not supported.
 
C

Charles Simpson

Thanks Jonathan ... I'll try this in my development environment and try to
remember to post back my results. I'm going to backup my existing stored
procedures first.

Charles L. Simpson
 
C

Charles Simpson

Do any of you guys know what negative impact this change would make (why it
is not a supported change) to the product in production? Would it interfere
with the upcoming migration to P12?

Thanks!

Charles L. Simpson
 
C

Charles Simpson

OK ... this is working great for me in our development environment. I now
must justify the risk at doing this change to production. I'm not sure if
this change will hurt us when applying future service packs or the eventual
migration to P12.

If anyone has an opinion on this, I would appreciate it.

Thanks!

Charles L. Simpson

Dale Howard said:
Jonathan --

Thanks for sharing your knowledge on this subject! :)
Click to expand...
 
C

Charles Simpson

I've had this change in production for several months now and it works great.
Thanks! All of the "choose a view" drop-downs in PWA are sorted
alphabetically and this includes new views created after the stored
procedures were modified.

The only issue that I had was that when moving to new environments, I must
remember to apply the stored procedure changes again as they are not moved
with the data.

Charles L. Simpson
 
Top