In my previous on the CFSharepoint tag and SharePoint Views we retrieved the meta-data columns for the specified view.

Now that we have the columns of the view we can build a CAML query to restrict what is returned when we get all the items of the list.

[More]

In my last post on the CFSharepoint tag and Sharepoint ViewCollections we retrieved a list of the views associated to the specified list.

Allowing the user to select a list provides us the ability to restrict, to some degree, the meta-data that will be returned for a list item. There is a lot of meta-data available and while restricting the meta-data to just the view fields may actually be a little too restrictive. One column baseName contains the filename, if this is not a column in the view fields you will end up without an easily "digestible" file name. Specifically you will need to parse the file name out from the ows_FileRef column. The FileRef column contains a relative path to the file including filename with extension.

[More]

In my last post on the CFSharepoint tag and ListCollections we connected to a Microsoft Sharepoint server and using the ListCollection action of the CFSharepoint tag we retrieved a collection of all the lists available to the user.

In Sharepoint each list can have multiple views associated with it that show different meta-data for the list items. If you plan on integrating Sharepoint it is a good idea to provide the user the ability to choose the meta-data they want to view. In order to do this you need to allow them to choose the view.

[More]

ColdFusion 9 saw the release of quite a bit of new functionality none so little blogged about as the new cfsharepoint tag. Not all surprising really since in order to use the cfsharepoint tag you need to have a Microsoft Sharepoint server at your disposal. Another reason it's probably not so often blogged about is that Sharepoint integration is going to be typically going on behind the scenes, integration projects with corporate Intranets and perhaps not really all that interesting for the masses.

Never the less I have decided to start a small series of blog posts on some of the different things you can do with the cfsharepoint tag. I will only be concentrating on document lists as that is where, in my opinion, most of the integration is going to be centered around.

[More]