• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • Last Modified:

One or more fields are not installed properly

I tried this query with CAML editor, and it shows me that error, I know the column exist, and that its written correctly

<Query><Where><And><Eq><FieldRef Name="Item_x0020_Language" /><Value Type="Choice">Nederlands</Value></Eq></And></Where><OrderBy><FieldRef Name="Created" Ascending="False" /></OrderBy></Query>
0
Simbios
Asked:
Simbios
1 Solution
 
Jamie McAllister MVPSharePoint ConsultantCommented:
You usually get that error when the CAML query is malformed, or the parser doesn't like something else about it.

If you're using this with SPQuery I'd lose the <Query> tags.

Also I'm seeing <And> elements but only a single equals clause inside (AND would expect two), so that's probably the culprit.
0
 
NomohoCommented:
Hello,

Try to remove one field from the query to see if it is:
Created or Item_x0020_Language which is wrong.

When you found which one (or two) of these field is wrong, find its real name and correct it.
Sometimes you must add "ows_ " at the beginning of the field names to use them in CAML query.

0
 
navdeepmadanCommented:
please provide the exact error message and ULS logs.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now