New answers tagged

0

I recommend this counter trick for returning all records from a list. You're probably only getting the current month because you haven't declared a view or a CAML query, so you're getting data from the default view, which is probably the current month. Alternatively, you could create a list-style view of all events in your Calendar list.


3

If you want to compare with both conditions than use AND: @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> <FieldRef Name='Team' /> <Value Type='Text'>"+ selected+ @"</Value> </Eq> </And> </...


1

@"<Where> <And> <Eq><FieldRef Name='ReportsTo' /><Value Type='Text'>" + reportsTo + @"</Value></Eq> <Eq><FieldRef Name='Team' /><Value Type='Text'>"+ selected+ @"</Value></Eq> </And> </Where>"


1

You can use like this: @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> <FieldRef Name='Team' /> <Value Type='Text'>"+ selected+ @"</Value> </Eq> </And> </Where>" NOTE: You can also use <...


1

Wrap your conditions in <And>...</And> inside <Where> Reference: https://msdn.microsoft.com/en-us/library/office/ms196939.aspx @"<Where> <And> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> <Eq> &...


0

Replace following block from your code CmalQuery = "<View><Query><Where><Or>"; while (e.moveNext()) { fieldName = e.get_current(); CmalQuery += "<Contains><FieldRef Name='"+fieldName+"' /><Value Type='Text'>" + txtValue + "</Value></Contains>"; console.log(...


0

This is for Sharepoint 2013. When a CAML query is issued against a list: if the security context is a user who is not an administrator and the query contains a filter that uses the "IN" clause. More than 60 values are passed for a particular indexed field that includes the "In" clause. The query is throttled, and the following error message is shown to ...


0

Rather than CAML, why not use the search API. For example, if you use a content type for the CV, you could fire a second query from your display template using the search REST API to find the content ContentType=CV.


0

I had similar kind of requirement, below is the code which I have used previously: enum MergeType { Or, And }; private static string MergeCAMLConditions(List<string> conditions, MergeType type) { if (conditions.Count == 0) return ""; string typeStart = (type == MergeType.And ? "<And>" : "<Or>"); string typeEnd = (type == ...


2

Before getting into the analysis how to use CAML query instead of LINQ, better know what is the usage of CAML Query. CAML - Collaborative Application Markup Language CAML Query is used in various ways within the context of Microsoft SharePoint Foundation to define queries against list data. Source: MSDN From the above statement it is very clear that the ...


0

Using below code you will get recurring events as distinct items using SPServices. var startDate = "2012-05-12T12:00:00Z"; // Our example will show the month of May 2012 $().SPServices({ operation: "GetListItems", async: false, listName: "My Calendar", CAMLViewFields: "<ViewFields>" + "<FieldRef Name='Title' />" + ...


1

While writing CAML query, you must understand the architecture how it works. It is pretty simple. You just have to do logical AND/OR operators. Any operator must have 2 conditions to combine and test. SCENARIO 1 : This is 1 Operator use with 2 conditions <Or> <Eq><FieldRef Name='Status' /><Value Type='Text'>(3) TestStatus3&...


1

CAML queries only accept two conditions for logical operators. So you can do <And> <Eq>...</Eq> <Eq>...</Eq> </And> but not <And> <Eq>...</Eq> <Eq>...</Eq> <Eq>...</Eq> </And> Solution is using two s: <And> <And> <Eq>...</Eq>...


0

This is waht I ended up going with Web web = ctx.Web; ListCollection lists = web.Lists; var docLib = web.Lists.GetByTitle(SharePointConnector.DocumentLibrary); ctx.Load(docLib, d => d.Title, d => d.RootFolder.Name, d => d.RootFolder....



Top 50 recent answers are included