What is new with Columns?


Columns have always been one of the most powerful features in SharePoint as they allow you to slice and dice you data into different views that provide very compelling information to the end users. In MOSS 2007, columns have received a facelift and in this article I’ll aim to tell you what is new and how columns have been improved.


For the sake of clarity, when I’m referring to a column, I am talking about the columns that you would add to a list or library and use to define metadata for a document or list items that are contained within. I’ll also refer to libraries and documents exclusively throughout this article, but that also include lists and list items (just too lazy to write ‘library/list’ or ‘list item/document’ every time!).


What has not changed?
Columns in MOSS 2007 still adopt the same basic principles as in the 2003 suite. A column is still part of a library and when you add a document to that library you have to provide values for the columns. The data you provide acts as the metadata for that document and can be used for many things including:



  • Views on the library

  • Webparts

  • Search queries

  • Workflow

Columns still have a variety of types. All of the old types are still there (single line of text, number, date etc) but a few new ones have been added (which I’ll discuss later)
Columns are still the main data source for webparts and views.


What were the main issues with 2003 columns?
In the 2003 suite, columns were very useful and were enthusiastically used to build applications and tools based on SharePoint data. However, in my opinion they had several key draw-backs, which were:


1. No central management
Columns we not centrally managed across the portal, instead they were managed at the library level. This meant that you never had central control over your corporate metadata taxonomy which is an issue for most organisations, especially those that are concerned with compliance issues such as FOI or SOX.


For example, if you had a company-wide column called ‘Offices’ which you applied to every document library and you suddenly find yourself with new offices; there was no real way of retrospectively adding the new column values to the existing libraries. In practice if you needed to update all of your columns, you either had to manually visit every document library, or write some kind of script that used the object model to update the libraries. Both methods were time consuming and expensive.


2. Limited range of types
In 2003, you only had a limited range of types for each column. The types on offer did the job for most scenarios, but not all. You’ll see later in this article how several new types are now available.


3. Only defined at the list/library level
In 2003, the columns were defined at the library level which meant that every item in that library had to have the same metadata. This dictated the whole approach around how the lists and libraries were designed.


If you had a document that needed a different set of metadata, you had to have a whole new library just for that document, which clearly does not make sense.
Because of this restrictive approach, it became impossible to build a library structure based on corporate taxonomies; instead they were based on document types.


So what is new?
OK, so here is the interesting bit…. Unsurprisingly, my take on what is new directly maps to the weak areas in the 2003 platform, here goes:


1. Column templates: portal-wide management of column definitions
In MOSS 2007, when you add a column to a library, you now have two choices:



  • Create a new Colum directly on that library (2003 style)

  • Add a column template

This picture shows the interface for adding a column to a library



Column templates are centrally controlled columns that are created by Admins at the portal level. Site owners can simply add a column template to his library and it maintains a connection back to the central column template. This means that when the column template is changed in any way, it also changes on any libraries that have used it.


This addresses the scenario around “what happens when I get extra offices”.


2. New Types
In MOSS 2007, there are several interesting new types in additional to the 2003 types. The new types are:



  • Business Data: Allows you to include data from the Business Data Catalogue (BDC). The BDC is a whole new feature which I’ll probably blog about some time soon. It is basically a way of including business data from external applications in your portal.

  • Audience Targeting: A way of choosing a specific audience, distribution list or sharepoint group to target the document to. Adding this column gives you an audience picker control that you can use to browse the audience, distribution list or sharepoint groups and choose which ones to target the item to.

This picture shows the different types that are available



3. Content Types
Content Types are a whole new feature that allows the behaviour of a piece of content (including templates, columns workflow etc) to be centrally defined and applied to any library in the portal.
This means that libraries can now contain multiple content types and therefore the columns are defined by the content type itself, not the library in which it is placed.


For example, you can have you expense reports in the same library as your reports and they can each have different sets of columns that are driven by the Content Type, not the library (though you can still have library based columns).


This picture shows how columns can be included in Content Types



This is a huge step forward because it means that we can now design library structures based on organisational rules rather than content-driven rules. I’ve written a whole article explaining Content Types in general, check it out here.


But wasn’t all this in SharePoint 2001?
A few people have commented on my last post about Content Types and have drawn the obvious comparisons about this stuff in MOSS 2007 going back to some of the functionality on SharePoint 2001. These comments made me chuckle and it is true that we have come ‘full circle’ (thanks for the comments by the way 😉 ).


I think the reason that much of this stuff was removed in SharePoint 2003 was because of the changes in the underlying architecture (WebStore to SQL) and there simply not being enough time to develop these features.


It is good for all of us that they are now here in MOSS 2007!


Cheers


PS: I am never quite sure where my audience is at with these articles. If you do not understand anything, please do not hesitate to comment on the blog or ping me at Martin.Kearn@Microsoft.com and I’ll do my best to answer your question

Comments (13)

  1. Andre Kieft says:

    Great post! That surely clarifies it.

    Regards,

    Andre

  2. Romeo Pruno says:

    VIA JOPX on SharePoint, MCMS, Office and SOA

    The Beauty of SharePoint 2007 – Publishing / Copying…

  3. Bob C says:

    Will SPPS 2007/v3 be compatable with Office 2003?  Is there a compatability chart available?

    I’m guessing that Workflow stuff not, but what about current features (for example, Infopath publish adding columns to a form library)?

  4. via JOPX

     

    Ah finally, it is here … get your Office 2007 beta2 … So, to get things going -…

  5. rachel xu says:

    Do you see any improvement on the lookup field besides allowing selection of multiple values?  I think the most wanted feature of lookup field in WSS 2.0 is the filted lookup field.  I have been looking all over the web and couldn’t find anything regarding this on MOSS 2007.  

  6. Raul Ribeiro says:

    SharePoint 2007 – General information SharePoint Server 2007 – Hidden gems Microsoft Office SharePoint

  7. ….. In short, the Business Data Catalogue (BDC) is without doubt the most powerful feature in MOSS

  8. Donna says:

    What about the Summary Links column type?  Is that new?  What is it used for?

  9. Rahul Patil says:

    Hey Martin,

    I realy got impresed by your skills on SPPS. Your blog realy help us in most of the caises.

    thanks a lot busy.

  10. In Sharepoint 2007 when number type columns are displayed in views, it is formatted with comma(Ex: 1,243,554). Is there any way to display it as plain text without comma, other than creating calculated column based on this column.

  11. Maria Carmen Vilbar says:

    How to save a multi valued column in Sharepoint List using web services.

Skip to main content