I am trying to filter a SPListItemCollection with CAML but I don't get the results I want.
Here is my code:
query.Query = "<Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">" + project.Split('/').ToString().Trim() + "</Value></Eq>"; ProjectsList.GetItems(query)[Variables.externalProjectNumber].ToString();
This should return one item as Title field is unique. However, when I use SP Caml Query Helper, I get all items returned. When I execute the code in Sharepoint, I get an error that a field is not correctly installed.
Anybody see a problem with my code?