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
1answer
14 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
23 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
83 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 ...
1
vote
1answer
31 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
21 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 ...
0
votes
0answers
17 views

Code review for Caml Query [closed]

Whether below mentioned code is correct or not? var context = new SP.ClientContext.get_current(); var lists = context.get_web().get_lists(); var associatedProjectsList = lists.getByTitle("Master ...
1
vote
2answers
46 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
25 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
35 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
50 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
54 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 ...
1
vote
1answer
22 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
63 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 ...
1
vote
3answers
32 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
32 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
25 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
41 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
45 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 ...
0
votes
1answer
28 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
41 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 ...
2
votes
2answers
76 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
27 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
34 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
36 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
34 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
17 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
95 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
64 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
308 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
84 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
66 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
36 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" ...
2
votes
1answer
50 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" ...
2
votes
0answers
60 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
135 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 ...
2
votes
1answer
23 views

Querying Standard Rendering Elements in CAML

Folks I'm looking to use the "standard rendering element" <PageUrl/> within a CAML query as per below: <Or> <Eq> <FieldRef Name="Webpage" /> <Value ...
0
votes
0answers
29 views

Providing a custom QueryOverride + Group items by <site> is not working together inside my Content Query web part

I am working on a Team site collection inside my SharePoint 2013. And I added a Content Query web part, and I define to Group the items by the Site:- And I got the following result which is ...
0
votes
0answers
43 views

CAML query is returning extra items that are not part of the filters

I am working on a Team site collection inside SharePoint server 2013. now inside the team site collection i have 5 subsites, and i want to return list items from the subsites that have the following ...
0
votes
0answers
12 views

Unable to Query Document Library on Lookup Column using CAML

I'm trying retrieve all items from a Document Library where a lookup column equals a certain value. The query returns no items for the given value but the same query with the same value returns items ...
1
vote
2answers
91 views

How to programmatically distinguish between simply uploaded documents (not check-out nor check-in) and check-in documents in SharePoint 2010?

I'm using SharePoint 2010 and I want to get the files that are not either checked out nor checked in. Meaning that I want to retrieve all documents that: - were uploaded in the Documents library ...
1
vote
1answer
56 views

Caml Query not applying to my list requests

I have a SharePoint Application that needs to data from lists to be inserted into elements. Here is the JavaScript: Collection.List.DropDown = function (listTitle, element) { //listTitle = ...
3
votes
1answer
225 views

How to filter items inside CQWP, based on Content type + People/ Group site column

I am working on a Team Site collection inside SharePoint 2013. and i want to display items that have specific content type + a people or group site column matches the login user. so i did the ...
1
vote
0answers
41 views

Query for SharePoint 2013 REST search

I have to site columns (column1, column2) that are also crawled by the search and available as Crawled properties, so I can use them as filters in REST query as well. I'm now trying to build the REST ...
1
vote
1answer
166 views

How to specify a CAML Query to return items that have any of two site columns?

I want to define a query to return items that satisfy the following :- if any item have a CT & login user = site column so i wrote the following :- <property name="QueryOverride" ...
1
vote
1answer
83 views

Query a SPList with managed metadata column with CAML including child terms

I have a SharePoint list which has a managed metadata column. This is bound to my term store which look like as following: Cars Mercedes S600 CL65 G BMW 5 6 7 X5 Maybach ... Bentley I ...
1
vote
2answers
131 views

Create a dynamic WHERE clause with LINQ to SharePoint

I have a custom application where the user can select multiple (13) parameters to select data from a SharePoint list. To achieve this, I want to use LINQ to query this data from SharePoint. The ...
2
votes
0answers
31 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
5
votes
1answer
150 views

Ignore Null Values in OrderBy Asc While creating CAML Query

I have 3 Columns in my List Id Name SortBy 1 A 1 2 B 3 C 2 4 D 3 and my CAML query is : Query = @"<OrderBy><FieldRef Name='SortOrder' Ascending='False' ...