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

0
votes
0answers
24 views

Querying Lists in 2013 via Javascript and JQuery [on hold]

I'm having issues trying to load the proper script below to become a customized image rotator on my SharePoint 2013 platform. Can anyone help please? I am using Cycle as my jQuery base I have ...
-1
votes
1answer
37 views

Caml query with more than 2 or conditions [on hold]

var fieldName; var listFields; var CmalQuery; $(document).ready(function () { $('#btnSearch').on('click', function () { txtValue = $('#txtSearch').val(); ...
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 ...
0
votes
1answer
19 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 ...
0
votes
1answer
36 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 = []; ...
1
vote
0answers
16 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
33 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 ...
0
votes
1answer
24 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(); }); ...
4
votes
3answers
128 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
0answers
8 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 ...
1
vote
1answer
37 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 ...
0
votes
0answers
17 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
35 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
39 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\...
0
votes
1answer
18 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
vote
1answer
36 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
98 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
44 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
23 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
59 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 ...
0
votes
1answer
43 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 ...
0
votes
2answers
36 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 ...
0
votes
0answers
71 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
69 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
1answer
28 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(' ')...
1
vote
3answers
78 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
40 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
39 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; ...
0
votes
1answer
44 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 ...
0
votes
1answer
59 views

How to join two sharepoint list data using CAML or LINQ?

I have two lists: Doctors DoctorDetails In list #2 I have a lookup from list #1 i.e. on Doctor Name. Now I want to fetch data on the basis of doctor name as filter from both lists. How can I ...
2
votes
2answers
64 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....
0
votes
1answer
47 views

REST getItems with CAML for proper managed metadata labels

I'm using REST to retrieve some information from a document library. There are some managed metadata fields attached to the items I'm returning. I've found that if the managed metadata column is a ...
1
vote
1answer
54 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
3
votes
4answers
153 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"); ...
1
vote
0answers
11 views

FeatureUpgrading - Providing an updated schema.xml file possible? [duplicate]

I've read a lot now about the FeatureUpgrading method. But I'm still asking myself, if I could provide an updated list definition (schema.xml) file in the ElementManifests. There are new views in this ...
0
votes
0answers
32 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 ...
0
votes
1answer
40 views

Join 3 lists initiating the join from the middle list

I need to join 3 Lists, but i have no access to the on-prem sharepoint to test my idea right now. So I hope anybody can tell me, if it's possible. I have Lists A, B and C. LookupFields are connected ...
0
votes
0answers
43 views

CAML Query using <In> element breaks after >60 values are placed inside

The following CAML Query works on my list that has over 5,000 items because the Title field is indexed: <View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> ...
0
votes
1answer
42 views

Executing multiple REST queries without error

I've pulled the following example of a REST Query from the SharePoint 2010 Documentation. It's working well except when I try to run multiple queries at once by renaming the functions: ...
1
vote
1answer
22 views

How can I move ONE document to another library without looping an entire collection?

Currently I'm looping through all the files in a collection, which is every single document in the library. Once I find the unique document name, I move it. I'm trying to getting away from looping ...
2
votes
1answer
144 views

SP2013 use Rest with CAML query and expand lookup column

I'm trying to query a sharepoint list that contains lookup columns and taxonomyfields. When I use the $expand option I can't expand taxonomyfields, but when I use a camlquery i can't expand lookup ...
2
votes
2answers
67 views

CAML Query Where (x AND y) OR Z

I've been struggling with this all day. I've referenced several SO questions/answers but to no avail. Not quite sure what I'm doing wrong. I also cannot use a CAML Builder, unfortunately, due to some ...
3
votes
3answers
514 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: ...
2
votes
0answers
154 views

SP2013 : CAML query for managed metadata columns for multiple items selected ?

How to write a caml query to fetch data from a managed metadata column ? I have written caml query which works fine for data matching to "Business" . How do my query return results if the data is ...
0
votes
1answer
94 views

Getting a unique reference number when users can only see their own items

I have created a SharePoint List (on 365 Enterprise) for logging accidents and incidents in our business. The list is populated using an InfoPath form that presents the user with the relevant fields ...
0
votes
2answers
43 views

Nested AND OR inside my Content Query web part's CAML query is not working well

I added a content query web part to my team site collection, then i export it , and i modified the QueryOverride tag as follow:- <OrderBy><FieldRef Name="Created" Ascending="FALSE"/></...
2
votes
1answer
61 views

GroupBy site name inside my CAML query

I wrote the following CAML query to be used inside my Content Query Web part, but i am not sure if i can define to Group the retrieved item by site name :- <property name="QueryOverride" type="...
2
votes
0answers
75 views

Is it possible to perform Inner Join with Lookup Multiple Value Field?

I use CAML Query to perform inner join between two lists. It works when the lookup field is single value. However, when this field is multiple value, it always throws error: the value does not ...
2
votes
2answers
158 views

Updating number column in SharePoint programmatically

This is my code which updates single line of text SPQuery query = new SPQuery(); query.Query = string.Concat("<Where><Eq>", "<FieldRef Name=" + txtColumnName.Text + "/>", ...
2
votes
2answers
38 views

Trouble updating rows of data in an External Content Type using Javascript

I've tried a few different ways of doing this, including querying the External Content Type and then updating the current item. However as far as I ever get is an undefined variable error. This is my ...