Exception while executing CAML query sharepoint 2007

Question

Name of the column in document library is : Column name => Keywords (Sub-Processes, Methodology, Servicing Model, etc) Column Type=> Multiple lines of text

We are using the above column name in the caml query as below

query.Query = "<Where><Eq><FieldRef Name='Keywords(Sub-Processes,Methodology,Servicing Model, etc)'/><Value Type='Text'>Merchant Services,Merchant Set Up</Value></Eq></Where>";

but when we run the code we get the exception:

Microsoft.SharePoint.SPException: One or more field types are not installed properly. Go to the list settings page to delete these fields.

Is this exception because of special characters used in the column name if yes then how can I correct it.

We can't change the column name because it is requirement.

I am adding code but after submitting the code it is not getting displayed :( — Rushikesh
query.Query = "<Where><Eq><FieldRef Name='Keywords_x0020_(Sub-Processes,_x0020_Methodology,_x0020_Servicing_x0020_Model,_x0020_etc)'/><Value Type='Text'>Merchant Services,Merchant Set Up</Value></Eq></Where>"; — Rushikesh
@Rushikesh are you sure fields internal name is soo long? Check With SharePoint manager to be sure. Or you can try using fields ID instead ID="{G-U-I-D}" — Janis Veinbergs

LordKakarot LordKakarot · Accepted Answer · 2012-01-24T06:41:05

Internal names and display names are quite different from each other. They can be the same in some cases but not all. There is generally an escape sequence in between two words with a space.

It is often a good practice to retrieve the internal name at runtime rather than hardcoding it.

Here's how to do it:

var internalName=list.Fields.GetFieldByInternalName(column.ColumnName).Title;

Exception while executing CAML query sharepoint 2007

3 Answers