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?

 

WSS Web Part Library Template for VS.Net 2005


The Long awaited WSS Web Part Library Project Template for Visual Studio 2005 is now published on GotDotNet. The URL is:
http://workspaces.gotdotnet.com/jywss

 

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?