When you are building a DVWP in SharePoint, there are some project (Web site) and list properties that are available to you directly from CAML that aren’t well-documented, which you can use if you request them directly. For instance, if you add the following to your CAML <ListProperty Name=”Title” /><ProjectProperty Name=”Title” />, the titles of…
I want to thank my ex-colleagues at Vitale, Caturano for a great event today in Waltham at Microsoft’s offices. There were some good presentations about the use of Sharepoint in the enterprise, about some of the vendor offerings in the space, and specific stories about how SharePoint use has evolved by Andy Kawa from Goodwin Procter LLP and by…
I’ve had this happen often and I’ve usually just left the unused master pages, since they aren’t really hurting anything. Today I finally decided to try to see if I could get rid of a pile of old copies of master pages I had lying around, and I found this Microsoft article which explains a workaround. …
I think I’ve found a bug in using aggregate data sources in DVWPs with SQL Stored Procedures. I’m trying to use the results of a Stored Procedure combined with the content of a list in SharePoint. I’ve isolated the issue to the Stored Procedure. The first asp:SqlDataSource statement below is what I want the data…
Sometimes when you create and configure a Data View Web Part (DVWP), you’ll see the PermMask column show up on its own in the DataFields or the CAML in your DataSource. This happens most often when you are building a Crosslist query (DataSourceMode=”CrossList”). The PermMask column contains the permissions mask for the item for the…
This is a little one, but a time saver all the same. I can never seem to find the “right” navigational route to the page which shows the permission levels (I think of them as roles and the page name backs me up!) in SharePoint. It’s the page at /_layouts/role.aspx. So: http://[yourservername]/_layouts/role.aspx From this page,…
Another name drop and tip ‘o the hat to Mauro Cardarelli for bringing this one to my attention. SharePoint Saturday is coming to Boston. I’m going to see if I can’t get in as a speaker to talk about my SharePoint Designer DVWP stuff. Working title: Developing with SharePoint Designer: The Middle Tier, Focus on Data…
My colleague Mauro Cardarelli posted about this the other day: By now, you have probably heard about Microsoft’s decision on the future of PerformancePoint Server (Microsoft Business Intelligence Announcement Q&A). Kudos to friend Chris Webb for breaking the news… at least to me! For PerformancePoint jocks, this is probably bad news, but as a SharePoint…
I had a question from a colleague today about how to do an XSL transformation of some search results. Here’s the query: Basically, I want to do the following in XSL: Parse a managed property, urlEncoded, that has the format of http://[doc library]/[filename] to separate path and filename Take that prefix and concatenate it with…
I think I’ve found an interesting (if you think things like this are interesting) difference between Document Libraries and Custom lists when it comes to the use of Site Columns. I had some filtering code in a DVWP that ought to have worked the same way on both a Custom List and a Document Library,…