Project Server 2003: Sort view by name

All the views in Project Server Web Access are currently not sorted by the view name. Instead they are sort by the ViewID. This could pose a usability problem when you have a long list of views. Your users will need to scroll through the whole list to find the view they want.

If you are really desperate in getting the view to sort by name, there are 2 stored proc in the Project Server database that control the retrieving of 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. Do it at your own risk.

 

Best Regards,

Jerry
EPM Consultant\Sr. Software Engineer

Work In Progress

Work: +92 42 5427001-4 Ext 213
Mobile: +92 345 4257573

Email: yasir.attiq@gmail.com
IM: <On Request>

 

INTECH Process Automation
119 B, Tech Society
Lahore, Punjab 54950
Pakistan

See who we know in common

Want a signature like this?

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s