Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.

learn more… | top users | synonyms

1
vote
2answers
2k views

Help with Complex CAML Query - Multiple OR Conditions

I need some assistance with a complex CAML query. I can get parts of it working but cannot get all of it working together. What I need in laymans terms is this: Where Country = US AND Status ...
0
votes
0answers
19 views

Method to get list headers & filters via jQuery SPServices CAML GetListItems or similar?

Is there a method similar to GetListItems to grab the column headers and/or filters for a list? Or a way to use GetListItems to get that information?
1
vote
1answer
21 views

Error updating List Items

I have found this code to perform batch update function updateListItems() { var itemArray = []; var clientContext = SP.ClientContext.get_current(); var oList = clientContext.get_web()....
0
votes
2answers
1k views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
7
votes
4answers
37k views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
3
votes
0answers
28 views

CamlQuery <Eq> vs <In> condition

I have two queries. The first uses the <In> condition and the latter the <Eq>. The latter works and returns 632 items, the first returns 0. <Where> <In> <...
0
votes
1answer
41 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
3
votes
4answers
115 views

SP - CodError with CAML query,

I want go get last record field value from my SPList with CAML query. Really code working but gives me following ERROR... My Code: void ddCarNumber_TextChanged(object sender, EventArgs e) { try ...
2
votes
2answers
1k views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'...
1
vote
1answer
735 views

Caml Query on calendar to get the next x events (including recurring)

So far I'm able to get the next x events (without recurring events). Code: private SPListItemCollection GetNextEvents(SPList eventCalendar) { DateTime currentDateTime = DateTime.Now; ...
2
votes
1answer
1k views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
0
votes
0answers
17 views

How to get Display name of MMS column using rest

I am using the rest call to get the display name of MMS column "Assetname" and I am getting the GUID https://<site>/_api/web/Lists/GetByTitle('HomePageConfig')/items?$select=TagsTitle,Assetname ...
-1
votes
1answer
44 views

Caml query with more than 2 or conditions [closed]

var fieldName; var listFields; var CmalQuery; $(document).ready(function () { $('#btnSearch').on('click', function () { txtValue = $('#txtSearch').val(); ...
0
votes
1answer
31 views

What is the limit of nested OR's in a CAML Query?? For each Version?

I'm needing to know what the exact nested CAML Query limits are for each version of Sharepoint? Also are these limits the same for using the IN,INCLUDES Operators with 2010+ ??? Thanks in advance ...
3
votes
4answers
209 views

CSOM get document by ID

I'm using the following CSOM code to retrieve a document title by id: ClientContext context = new ClientContext("http://sharepoint"); List oList = context.Web.Lists.GetByTitle("Documents"); ...
0
votes
1answer
37 views

error : collection has not been initialized on deleting an item from list

Below is the function and its fetching the Amount and uno but it throws an exception on clientContext.executeQueryAsync(). Here is the Code: function delRec() { var uno; var itemArray = []; ...
13
votes
4answers
21k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx http://www....
1
vote
0answers
19 views

Can SharePoint use an index for 'Begins with' queries?

Lets say I have a 'Begins with' CAML query for a column and I also created an index for this column. Can SharePoint use this index for the query?
0
votes
1answer
37 views

CAML to query a recurrent event - SP 2010

I´m using SP CAML Query Helper Online fot getting all the elements of a recurrent event but it only get the general recurrent event. there is possible to get all the days of this recurrent event in ...
4
votes
3answers
144 views

Multiple Lookup Columns return no items CAML Query SharePoint Views

I have a document library that has reached it's 5000 view limit and I'm trying to retrospectively create views on indexed lookup columns. I can successfully return views that are customised in ...
0
votes
1answer
1k views

getting length of list after caml query

var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('Privacy Statements'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<...
0
votes
1answer
25 views

CSOM request sometimes works, sometimes fails

I try to modify the value of some fields in a list with CSOM on a button click. Here is the script I call in the html: $("#palettebutton").click(function(){ getItemsToBeUpdated(); }); ...
1
vote
1answer
39 views

Union Multiple Lists with Client JavaScript Object Model

I have several SP 2010 lists with the exact same columns. I would like to perform a union on the lists and display a filtered subset from this union. I tried doing it using a joined datasource in SP ...
2
votes
5answers
9k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
0answers
10 views

CAML query of Gantt task template data in AssignedTo field SharePoint 2013

I am creating a SharePoint task aggregate app that retrieves various field information from SharePoint task templates. I am receiving blank data for the AssignedTo field for templates 150 and 171. I ...
3
votes
3answers
679 views

Query multiple lists using javascript/CSOM

I'm about to query multiple lists using JavaScript (JSOM, SharePoint 2010). It's working when querying one list in a time, but that's annoying when I'm having lots of lists. Working example: ...
0
votes
0answers
21 views

SP2013: CAML query return result paged?

I have a list of 2500 items which I need to filter and then iterate through. Since the payload of returning (potentially) 2500 items is too big I need to break it down into small pieces. For this ...
0
votes
1answer
40 views

SP07 - How to get SPListItem Author and Last Editor

I want to get author and editor on SP ListItem: With this Page_load Code : SPQuery myQuery = new SPQuery(); myQuery.Query = "<Where><Eq><FieldRef Name='ID'/><Value Type='Text'&...
0
votes
1answer
68 views

Getting this error: An entry without a type name was found, but no expected type was specified

I am new to sharepoint.I am getting below error on ajax call i dont know where it is occuring. "{\"error\":{\"code\":\"-1, Microsoft.SharePoint.Client.InvalidClientQueryException\",\"message\":{\"lang\...
5
votes
3answers
3k views

How to get caml query to return list items created by the current user?

I want a caml query that only retrieves items created by the user currently logged in. I tried this specifier = "<Eq><FieldRef Name='AssignedTo'/><Value Type='Integer'><UserID/&...
0
votes
1answer
21 views

Can't make a caml query works for a boolean

I try to take the elemtens in a list where the field "Mise à jour parc" is set to "No" with the boolean type. My field 'Mise à jour parc" has for db name for sharepoint "...
-1
votes
1answer
750 views

ItemUpdated Event Receiver how to change element from one list to secound list

I have got two lists. I must do synchronize this list, but one have got only 3 columns, and secound list have got 3 columns too, but have got more columns with hidden value. I done synchronizing ...
1
vote
1answer
47 views

Empty CAML Query recursively search through document sets

I want to search for every single item within a document library. This is working just fine, but isn't working if the files within a document set in that library. I'm using an empty CAML query ...
1
vote
2answers
104 views

SP - CAML Query with three AND operators

I have a CAML Query with range between two dates and one text from DropDownList. Where I'm wrong in this query: myquery.Query = " <Where> <And> <FieldRef Name='...
1
vote
1answer
79 views

CAML Query to retrieve list item by title

I'm trying to query for only this the item called Test1. I'm using this caml query but I'm returning all items in the list for some reason. private static int GetlookUpId(List hrLookupList, string ...
0
votes
1answer
27 views

Retrieve all List items in library caml

I have reference to a document library. I want to now create a CAML to pull out every item contained within this document library. I can't seem to figure out the CAML in which to do this. Every CAML ...
1
vote
2answers
68 views

Select 5 items with caml beginning at the fifth row

I can get the 5 first items of a list with caml : var collListItemToBeUpdated = ""; var listItemToBeUpdated = ""; var enumerator; function getItemsToBeUpdated2() //this function ...
7
votes
5answers
264 views

CAML query for Sharepoint Calender Lists

I am using CAML query for SharePoint calender list. I am able fetch proper daily data. but when i choose weekly, monthly and yearly, it doesn't give me reports as expected. it doesn't take date ...
0
votes
1answer
62 views

camlQuery rowlimit not working on a list

I'm trying to update some elements in a list with client object and caml query. It's working, my values are updated, but for all the items (around 15) even I have a rowlimit of 5 : var ...
2
votes
1answer
1k views

Client Object Model & CAML -> Getting Items of a specific view

I need some support as I am struggling to understand what is wrong with my code. I try to retrieve the data of a specific view. The line camlQuery.ViewXml = view.ViewQuery; throws an exception The ...
0
votes
2answers
38 views

SP07 - CAML Query between two dates

I have two datetimeControllers : DateTimeControl dtFrom = new DateTimeControl(); dtFrom.ID = "startDate"; DateTimeControl dtTo = new DateTimeControl(); dtTo.ID = "endDate"; I want to get ...
1
vote
1answer
32 views

Query for spaces in values

I'm trying to filter a large list to pull out any values that have trailing or leading spaces using a powershell script. I can do it using a where-object command ($items| ? {$_["field"].StartsWith(' ')...
0
votes
0answers
77 views

Sharepoint Online REST api CAML query not returning file related columns

Hiho! I'm trying to query a document list from a sharepoint online server using REST api. I have to use caml, otherwise filtering is not possible on the taxonomy field as far as i know. Below is ...
2
votes
1answer
81 views

CAML OrderBy on Choice Field

I'm trying to return a list and order it by a choice field. My choice field currently is just set to Yes or No. The XML I'm using: <View><Query><OrderBy><FieldRef Name="...
1
vote
3answers
82 views

SharePoint - CAML query where check TextBox for existing “User Name”

I need to make query in SharePoint WebPart with VisualStudio. I have list "Employees" and need to check this list for existing UserName! <tr> <td class="auto-style1">...
1
vote
3answers
41 views

CAML Query with AND OR

I'm struggling to get a simple query working and would appreciate any assistance in pointing out my error/s. I need to return all "Chart Type" that equal "Jacket" for "2016" in both "Mar" and "Feb". ...
0
votes
2answers
45 views

CSOM not retreiving count of items in a list

I'm trying to get a count of specific items in a SharePoint 2010 list but I keep getting a count of ALL the items in the list. Here is my code: var clientContext = null; var web = null; ...
3
votes
4answers
819 views

Display Announcements List in HTML Table on a SharePoint 2010

Consider this as my code for displaying Announcements list in a site page on my SharePoint 2010 site: <html> <head> <script type="text/javascript" src="/Test_Library/js/jquery-1.9.1....
0
votes
1answer
54 views

List join via CAML with SharePoint Designer for HTML View

is it possible to make a Join over multiple Lists with a CAML query like in C# oder JSOM and show that view on a SharePoint page? I'm using Sharepoint Designer 2013 and Sharepoint 2013. I have the ...
2
votes
2answers
78 views

CAML query for filtering list view

I have a SharePoint list that I need to filter according to this: First of all, the items must be Booked by = Travel and Meeting Support and the Category should never be visible if they are Cancelled....