Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 26 Feb 2012 11:53 PM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 19 Sep 2013 5:04 PM
  • Revisions: 7
  • Comments: 7
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: One or More Field Types are not Installed Properly. Go to the List Settings Page to Delete These Fields in Executing CAML Queries

SharePoint 2010: One or More Field Types are not Installed Properly. Go to the List Settings Page to Delete These Fields in Executing CAML Queries

SharePoint 2010: One or More Field Types are not Installed Properly. Go to the List Settings Page to Delete These Fields in Executing CAML Queries

Hi,

An issue was reported to me where a developer was trying to use a  CAML query and was getting this error:
"One or more field types are not installed properly. Go to the list settings page to delete these fields". I checked the fields and they were fine. I executed a few other queries and found that they were working fine. This was a clear indication that there was something wrong in the query rather than in the list settings. I found that the query had a column "Approval Status". To verify whether it is causing the issue or not I executed a small piece of code to get the internal name and I found that the internal name of this field is "_ModerationStatus". I changed the value in the query and it worked fine.

 I am attaching a small piece of code for reference:

SPQuery query = new SPQuery();
                String camlQuery = "<Where><Eq><FieldRef Name='_ModerationStatus'/><Value Type='Text'>Pending</Value></Eq></Where>";
                query.Query = camlQuery;
                SPListItemCollection items = list.GetItems(query);

I hope this will help you out.

Thanks,
Rahul Rashu
, , , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 15 Apr 2013 1:53 PM

    Richard Mueller edited Revision 2. Comment: Modified title casing, removed (en-US) from title, added tag

  • 15 Apr 2013 2:00 PM

    Richard Mueller edited Revision 3. Comment: Replaced RGB values with color names in HTML to restore colors

  • 18 Sep 2013 9:11 AM

    Richard Mueller edited Revision 4. Comment: Fixed grammar, changed tag "SharePoint 2007 (en-US)" to "SharePoint 2007"

  • 19 Sep 2013 5:04 PM

    Richard Mueller edited Revision 5. Comment: Change tag "SPS 2010" to "SharePoint 2010"

  • 27 Feb 2012 2:00 PM

    Craig Lussier edited Original. Comment: added tags

  • 28 Feb 2012 2:41 AM

    Gokhan Ozcifci edited Revision 1. Comment: Great article, juste changed the title and add tags

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 15 Apr 2013 1:53 PM

    Richard Mueller edited Revision 2. Comment: Modified title casing, removed (en-US) from title, added tag

  • Posted by
    on 15 Apr 2013 2:00 PM

    Richard Mueller edited Revision 3. Comment: Replaced RGB values with color names in HTML to restore colors

  • Posted by
    on 18 Sep 2013 9:11 AM

    Richard Mueller edited Revision 4. Comment: Fixed grammar, changed tag "SharePoint 2007 (en-US)" to "SharePoint 2007"

  • Posted by
    on 19 Sep 2013 5:04 PM

    Richard Mueller edited Revision 5. Comment: Change tag "SPS 2010" to "SharePoint 2010"

  • Posted by
    on 27 Feb 2012 2:00 PM

    Craig Lussier edited Original. Comment: added tags

  • Posted by
    on 28 Feb 2012 2:41 AM

    Gokhan Ozcifci edited Revision 1. Comment: Great article, juste changed the title and add tags

  • Posted by
    on 29 Oct 2012 7:25 AM

    This helped me a lot :)

Page 1 of 1 (7 items)