Tag Info

New answers tagged

0

Your query is wrong. It should be <Where> <And> <Neq> <FieldRef Name='Status'/><Value Type='Choice'>Completed</Value> </Neq> <And> <Neq> <FieldRef Name='Status' /><Value Type='Choice'>Waiting for Inputs</Value> ...


0

IncludeAttachmentURLs is not available with CAML query object of .NET Client object model. To retrieve the files from the attachment field you have to try the following: Folder folder = clientContext.Web.GetFolderByServerRelativeUrl( spList.RootFolder.ServerRelativeUrl + "/Attachments/" + item.Id); FileCollection files = attFolder.Files; // If you ...


0

The "Include attachment urls" section of this article may provide you help with what you want to achieve. Let us know if it helped.


0

Probably because (oListItem.get_item('Setting_x0020_Value') == 'Yes') isn't true when you run the code. If you straighten out all of the indentation levels using an IDE of some sort you'll get a clearer picture on where it falls out: function onQuerySucceeded(sender, args) { var listItemEnumerator = collListItem.getEnumerator(); while ...


1

Your problem is your string literal for set_viewXml. You need to escape newline to continue a string literal through several lines. You also need to swap your ' for "". Example: camlQuery.set_viewXml("<Query> \ <Where> \ <And> \ <Eq> \ <FieldRef Name='Title' /> \ <Value ...


0

Querying calendar events are not simple. You need to take care of 3 scenarios Events that are set on specific dates All day events Recurring event Based on all these we can say whether a conflict exists or not. Below is a sample query which returns all event between two date ranges (you can use this as the starting point "<Where> <And> ...


1

Make sure field SalesCode is indexed. If you are expecting only one record then apply RowLimit Follow Microsoft's recommendation of maintaining large lists http://technet.microsoft.com/en-us/library/cc262813(v=office.14).aspx


1

CAML is the best way to go for quering the list . But since you have 100,000 your list will have to overcome the list throttling . The list throttling can be change in central admin ,but its better to do in code as mentioned below: var query = new SPQuery(); query.Query = "<Where><Eq><FieldRef Name=\"Title\" /><Value ...


0

Use CamlQuery.FolderServerRelativeUrl property for specify the server relative URL of a list folder from which results will be returned. Example Assume we need to retrieve zip files from Folder Archive located in Documents library var fileType = "zip"; var list = ctx.Web.Lists.GetByTitle("Documents"); var query = new CamlQuery(); ...


0

Try this @"<Where>" + "<And>" + "<Or>" + "<Contains><FieldRef Name=""Status""></FieldRef><Value Type=""Choice"">Current</Value></Contains>" + "<Contains><FieldRef Name=""Status""></FieldRef><Value ...


0

You should use 'ExecuteNonQuery` var siteUrl = "/"; var res = ""; var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('MyFolder'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml("<View Scope='RecursiveAll'><Query><Where>" + "" + ...



Top 50 recent answers are included