1

My scenario :

I am using a caml query to read all folder and files in a list but i noticed that if i get a folder by serverrelativeURl and the list name is(eg késhév,ie has special character or a space),the caml query return null.

For other list with standard name the codes work.

I am trying to use CDATA,but its not working.i think its a syntax error.

 var query = new CamlQuery();

            query.FolderServerRelativeUrl = folderServerRelativeUrl;

            query.ViewXml = "<View Scope=\"RecursiveAll\"> " +
                "<Query>" +
                "<Where>" +
                            "<Eq>" +
                                "<FieldRef Name=\"FileDirRef\" />" +
                                "<Value Type=\"Text\">" + "<![CDATA["+folderServerRelativeUrl+"]]>" + "</Value>" +
                             "</Eq>" +
                "</Where>" +
                "</Query>" +
                "</View>";

            ListItemCollection folderItems = list.GetItems(query);
            clientContext.Load(folderItems);
            clientContext.ExecuteQuery();
Improve this question
1
  • Try with the encoded value (k%C3%A9sh%C3%A9v). – Christoffer Mar 16 '18 at 7:37
2

Encode the values:

encodeURIComponent('listname') in javascript
Uri.EscapeUriString("listname") in C#
Improve this answer
2
  • I am using c# and not javascript. Is there an equivalent – Keshav Taurah Mar 18 '18 at 11:03
  • Use Uri.EscapeUriString("listname") in C# – Deepmala Mar 19 '18 at 3:32
1

Include the text containing special characters in CDATA. See this for reference: http://code2care.org/2015/error-caml-query-containing-special-characters/

Improve this answer
1
  • Can you verify the code above please,i can't seem to be able to use a variable in CDATA – Keshav Taurah Mar 18 '18 at 12:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.