|
Search
Recent blog posts
- Feature Upgrade : Better to go for full solution deployment or for solution upgrade?
- Localizing XSL with the Business Data and the Content Query Webparts
- Leveraging oData using the built-in SharePoint 2010 data factory
- My top 10 tools for a better SharePoint development experience
- Forms Services 2007 => 2010 migration tip
- Potential gotcha with custom display forms
- Building and consuming a custom oData service for SharePoint 2010
- SharePoint 2010 - Overcome the 10000 default search results limit
- My Top 10 tests when testing custom SharePoint webparts
- Unexpected People Search results - the right way to fix it!
- My top 10 sanity checks when performing SharePoint code review
- DropBox for SharePoint now includes tagging to integrate better with SharePoint 2010 social framework
- SharePoint 2010, deploying a BCS Model using a farm property bag to have a dynamic siteurl
- SharePoint User Profiles + BCS + XML Serialization problems when data is not sanitized
- Releasing DropBox for SharePoint Server 2010
- Dashboard helper for the SharePoint developer dashboard
- Customizing the master page of Office 365 public site
- Office 365 customization, from excitation to frustration
- One step further with the BCS and the StreamAccessor
- Using the SharePoint Client Object model from within a custom Document Information Panel
- Using the SharePoint RESTful service listdata.svc from within a custom Document Information Panel
- cloudshare & SharePoint
- Easy Forms Designer for SharePoint Foundation
- 10 steps to make use of the Rating System for SharePoint Foundation
- Techdays 2011 in Paris
- New release of the rating system for SharePoint Foundation
- Manage the ribbon easily for your lists and libraries
- SPClaimsAuthMembershipProvider casting error
- using jQuery with ListData.svc and redirecting the user when not logged in using FBA
- SharePoint COM, client side error handling and impact on the performance + tips to handle returned error codes
User login
Potential gotcha with custom display forms
Fri, 11/25/2011 - 21:56
Hi,
On a recent project, I've been involved in analyzing the WSS_Logging database for reporting purposes. As you certainly know already, this database contains a lof of information regarding usage & health of the SharePoint farms.
This database is opened for read/write and Microsoft even provides APIs for that purpose. For more info, I encourage you to read Todd Carter's excellent blog post here:
http://todd-carter.com/post/2011/05/03/Extending-The-SharePoint-2010-Hea...
I've been digging more particularly in the view called [WSS_Logging].[dbo].[RequestUsage] since it contains a lot of valuable information for reporting. In a few words, we could say that this is a staging view containing IIS Logs equivalent information plus some SharePoint specific columns. One of them has a great business value and is the Title column that holds the value of SharePoint list items.
To me, that's very interesting because it's meaningfull for the business. If they give relevant titles to their pages, list items etc...they'll easily identify those items in the reports.
However, I faced one problem with some legacy code where the default displayform of a given list had been completely modified and almost none of the SharePoint controls was declared. This resulted in wrong results in WSS_Logging since visits on this list items caused the system to save the list title instead of the item title for every item that was visited.
After comparing an out of the box display form with the custom one, I found out that just declaring the following control in the content placeholder PlaceHolderPageTitleInTitleArea of the custom DispForm.aspx was enough to get the right value back in the database:
<SharePoint:ListProperty Property="LinkTitle" runat="server"/>: <SharePoint:ListItemProperty runat="server"/>
Happy Coding!
Tags: