Kartic's Musings on Corporate Information and Knowledge Management

November 12, 2007

Using Calculated Field – Nested IF Statement in Sharepoint list

Filed under: SharePoint — Tags: , , — kartickapur @ 3:51 am

I was trying to convert this lookup table in the excel sheet to a SharePoint list. Basically, The column C1 (Choice of 1 to E) and C2 (A to E) together determine the value of Column C3 (Let’s say). The lookup table given below provides the reference for the Column C3. 


The nested IF statement using the calculated field did the trick.

 IF(OR(AND(C1=”A”,C2=”A”),AND(C1=”A”,C2=“B”), AND(C1=”A”,C2=“C”), AND(C1=“B”,C2=”A”), AND(C1=“B”,C2=“B”), AND(C1=“C”,C2=”A”), AND(C1=”A”,C2=“D”)),”High”,IF(OR(AND(C1=“E”,C2=“C”),AND(C1=“E”,C2=“D”),AND(C1=“E”,C2=“E”),AND(C1=“D”,C2=“D”), AND(C1=“D”,C2=“E”), AND(C1=“C”,C2=“D”), AND(C1=“C”,C2=“E”), AND(C1=“B”,C2=“E”)),”Low”,”Medium”))


November 7, 2007

Search Server 2008 Express

Filed under: SharePoint — Tags: , , — kartickapur @ 12:40 am

Microsoft has just released its free product – Search Server 2008 Express for Enterprise search. It is a search product in itself which combines all the desirable feature of MOSS enterprise search along with added configuration features, data Connector and Unified Administration Dashboard functionality.

 Search Centre 

Search centre provides the similar functionality as MOSS 2007 of :

  1. Term Definition
  2. Best Bets
  3. Hit Highlighting
  4. Alternative common search items when search word is misspelled
  5. Alerts via RSS or email when new search results which meet your criteria are found

 search-centre-results.jpg Configuration 

A new Search Administration Dashboard provides a wide range of functionality from the dashboard. The Dashboard highlights most common search task, status and settings. Out of the Box search centre indexes File Shares, Web Site and Exchange Public Folders straight away using feature called content source under crawling.


You can configure key relevancy settings like authoritative pages, search scopes, keywords and synonyms.


Search Server supports many security features and authentication mechanisms. Helps secure access to critical business information and Services using NTLM, Kerberos, Form based or Cookie based authentication.





 No Limit 

The best feature incorporated is the no pre set limit on number of documents you can index. Search index allows you to scale your search centre infrastructure to meet your changing needs.

 Federated Search Connectors 

You can now index and search other key business systems at the same place. Connectors can be added that allow search server express to also index information stored in Lotus Notes, EMC Documentum, IBM filenet and other Repositories.


Similar to MOSS search, Search server provides:


  1. Graphical display of queries over a time period
  2. Most common search items
  3. Queries with no results
  4. Top Destination pages
  5. Query volume
  6. Click through rates
  7. Most Clicked best bets

Exporting to excel

November 1, 2007

Content query web part: customisation and adding custom fields

Filed under: SharePoint — Tags: , , , , — kartickapur @ 6:17 am

Don’t we all love Content Query Web Part in MOSS 2007. Its a powerful tool to display content from other sites.

We do come to a dead end when the requirement is to display fields other than the one’s available out of the box or to show context menu.

It is amazing to see how an ordinary user (doesn’t have to be a developer) can modify the .webpart file to customise it. follow the steps given on microsoft technet site:


you will notice that CommonViewFields property can be changed easily. you will need to know the type of the column. The list is not given in the article. you can get it here:

Field Name

AllDayEvent Specifies an all day event. 
Attachments Contains attachments. 
Boolean Contains Boolean values that are stored in the database as 1 or 0
Calculated Contains calculated values. 
Choice Specifies a predetermined set of values that can be used to enter data into the field. 
Computed Specifies an abstract field type that depends on other fields for its content and definition. 
ContentTypeId Contains a content type ID.  
Counter Contains an integer used for internal ID fields. 
CrossProjectLink Specifies a link between projects in a Meetings Workspace site. 
Currency Contains currency values formatted based on a specific locale. 
DateTime Contains date and time values. 
Error Contains errors. 
File Contains files. 
GridChoice Specifies a Choice field for a data sheet. 
Guid Contains GUIDs. 
Integer Contains positive or negative integer values. 
Invalid Not used. 
Lookup Contains references to values in other lists. 
MaxItems Contains the maximum number of items. 
ModStat Specifies Content Approval status. 
MultiChoice Contains multiple values per list item. 
Note Specifies a field that can contain multiple lines of text. 
Number Contains floating point numbers. 
PageSeparator Inserts a page break in a survey list. 
Recurrence Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition. 
Text Contains a single line of text. 
ThreadIndex Contains the ID that indicates the relative position of a message within a conversation thread. 
Threading Specifies a field that is used in the creation and display of threaded Web discussions. 
URL Contains hyperlinks. 
User Specifies users of a SharePoint site. 
WorkflowEventType Specifies a workflow event type. 
WorkflowStatus Specifies workflow status. 

Enhanced Content Query Web Part created by my colleague Ishai Sagi is an amazing web part: http://www.codeplex.com/ECQWP

Heather Solomon provides the easy approaches of not just customising the Web Part but to apply custom styles as well. Look for step by step details here: http://www.heathersolomon.com/blog/articles/customitemstyle.aspx

Create a free website or blog at WordPress.com.