Skip to main content

Questions tagged [caml]

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.

Filter by
Sorted by
Tagged with
1 vote
2 answers
2k views

CSOM C# Caml Query on managed metadata field not working

I am trying to find an item in a list where the managed metadata field is equal to a certain text value. This is the code that I have which is not getting any items in the list (ListItemCollection ...
cooper's user avatar
  • 245
6 votes
1 answer
179 views

SharePoint 2010 list Item Query

We have a big list in SharePoint 2010. I'm gonna query SharePoint 2010 list item in the web part based on country. I used CAML and JS. I have got errors in different browser" Internet explorer says ...
Sara's user avatar
  • 897
3 votes
2 answers
6k views

How to query a list's user field for a given login name in Javascript?

I need to build a query a custom list with a user field. The where clause filters the results to a given list of user login names of a dynamic length, so I build the query according to the numbers of ...
elsni's user avatar
  • 471
0 votes
2 answers
527 views

caml or linq to get data from list

I am new with sharepoint development. I read more articles to read data from sharepoint list. I find Caml and linq i want to know what is the diff between Caml and linq to learn
SP-Mzoooooo's user avatar
3 votes
2 answers
2k views

CSOM: fetching items using ViewFields and non-default properties

I'm trying to get a particular set of columns for items in a list, as well as RoleAssignments which is a non-default property. Assuming my CAML, where I define my ViewFields, is in a variable ...
sasfrog's user avatar
  • 314
0 votes
2 answers
891 views

Caml query - Created By AND Title OR Comments OR Status

Can someone please help me with this caml query? I have a list view and the list view should only return items created by the current user. Then I also have a textbox to provide values for Title and ...
Dixit Mirza's user avatar
1 vote
2 answers
5k views

CAML query to filter by more than one ID

I have to send more than one ID to CAML query. But got struck with the or condition. How can we implement or condition for unknown number of ID's to be passed to the query. I have done in for two ID'...
KumarV's user avatar
  • 2,690
0 votes
1 answer
428 views

caml query is not working to get checked out files by specific user only

Loop through all the folders in document library and fetch checked out files by specific user only
raju's user avatar
  • 153
0 votes
1 answer
3k views

Recursive CAML query

I would like to search items between two dates in a DocumentLibrary. The query find the files at root just right. However the query doesn't seem to be considering files in folders. Here is my attempt ...
Ythio Csi's user avatar
  • 185
0 votes
1 answer
478 views

What is the point in Group By in Caml

Hi I've been working on my csom application and needed a way to group list items via an attribute. This also needed to be paginated as well. Initially I just went for groupBy, seemed to be what I ...
Richard   Housham's user avatar
1 vote
1 answer
1k views

CAML Query not ordering, returns all items

I am working on a powershell script to start the workflow on items in a list, $url = “https://xxxxx.sharepoint.com/sites/xxxxxxxxxxxx” $username = "username" $password = Read-Host -Prompt "Enter ...
Alex de Groot's user avatar
1 vote
3 answers
3k views

Searching for multiple values in a field with CAML, Sharepoint 2013

We have a SharePoint 2013 list that stores a list of work hazards. One of the columns is called "Hazard" and contains words which relate to the type of hazard it is. Two Examples of data in the ...
Dana Victoria's user avatar
0 votes
1 answer
431 views

SharePoint CAML query returns nothing

I need to find all items from Tasks history (Workflow history) list from SharePoint 2013, but I don't manage to get it exactly right, I have managed to get all items and no items at all. Any idea, ...
Taurib's user avatar
  • 315
0 votes
2 answers
764 views

Whats wrong in given caml query?

I am trying to get the data based on some datetime string using CAML query. Here is my CAML query: <View> <Query> <Where> <And> <Le&...
Trimantra Software Solution's user avatar
0 votes
2 answers
983 views

SharePoint 2013 - Library - Update an item of type Managed Metadata

I have a document Library. It contains many columns out of which I want to update the value for managed metadata column. Suppose, the Value which I want to update is "My Value" and this value "My ...
user2598808's user avatar
1 vote
0 answers
281 views

Extract data from ows_MetaInfo

I'm trying to extract all data from an SPListItem. Most of the data is in the ows_MetaInfo attribute in some strange format. Is there a way to either deserialize ows_MetaInfo, or get the fields in an ...
Bohdan's user avatar
  • 111
2 votes
1 answer
552 views

Can't get Document Library CAML Query to work

I have a document library with 5 content types. Each content type has the same lookup on another list. I need a caml query that checks if a document with the same content type and lookup value exists ...
LeonidasFett's user avatar
5 votes
1 answer
4k views

SharePoint 2013 Batch update list items C# SSOM

I am trying to use batch update for one of the list in SP2013 site. I am trying to run a simple batch request as follows. using (var spSite = new SPSite(siteName)) using (var spWeb = ...
Nikhil Chavan's user avatar
1 vote
0 answers
49 views

How Do SPViewScope Enum Members Map to CAML Scope Options?

The SharePoint CSOM library defines an enum named SPViewScope with the members Default, Recursive, RecursiveAll, and FilesOnly. The CAML specification defines the Scope attribute of the element as ...
Emmanuel's user avatar
  • 111
1 vote
1 answer
969 views

Is it possible to get all list items using CAML-query?

I'm trying to retrieve items from all lists on current site collection. Is it possible to do that using a CAML-query?
Akshay Dattatray Nangare's user avatar
2 votes
0 answers
106 views

Move documents from one subfolder to another/root folder

I have a document library with sub folders. I would like to move the document(s) from one folder to another/root folder. Is this possible using CSOM/CAML? I am pretty new to Sharepoint development so ...
Suraj Nair's user avatar
0 votes
2 answers
583 views

SharePoint CAML query - to retrieve column value with certain pattern from Library

I need to query from pages library to get a HTML column. This column contains rich text and references to various URLs(anchor tag). The query should return items which contain a column value with ...
user2598808's user avatar
3 votes
2 answers
615 views

How to fix CAMLJS undefined error?

I am running a simple CamlJs, it works from Chrome Console and from the Chrome Extension. However when I try from a Content Editor Webpart (Sharepoint Online / O365) it gives me an error. <script ...
dinnouti's user avatar
  • 155
1 vote
0 answers
543 views

How to create a CAML query comparison that works on both numbers and strings?

I am working with a system that makes requests to SharePoint lists that have latitude and longitude columns. One of the most common use cases is requesting list items that fall within a certain ...
Frank Tan's user avatar
  • 111
2 votes
1 answer
14k views

SP Online - Get items from list(CAML) with JSOM

I want to get list item with caml query for SharePoint Hosted Add'in. Query will returned one item.. This is my code: function getUserData() { var employeeList = clientContext.get_site()....
Goshky's user avatar
  • 2,058
4 votes
3 answers
475 views

Cannot Query Document Library with > 5K folders

I have some SP .NET Object library code that will allow me to query for the contents of a specific folder in a document library. It worked fine in a UAT environment where there were only a few dozen ...
Chris Harrington's user avatar
2 votes
0 answers
101 views

CAML Designer through ADFS authentication

I cannot seem to authenticate via CAML Designer for a SharePoint 2013 on premise installation that is using ADFS and Windows auth for authentication. In my case, all Windows Users have a deny access ...
James Grizzle's user avatar
1 vote
2 answers
829 views

Create View with dynamic Filter using Contains and OR : CAML syntax errors

I'm trying to dynamically add filters to an existing view, with an OR between two columns and using CONTAINS constraints, using purely client side javascript The solutions to me seem to be either: ...
southskies's user avatar
0 votes
2 answers
1k views

Using javascript variable or function inside caml query on sharepoint list view page with sharepoint designer

I am trying to put custom JavaScript variable or function into the sharepoint's list view page, inside caml query, using sharepoint designer for example: i am opening list view i want to modify. ...
wol's user avatar
  • 135
0 votes
2 answers
888 views

CAML query seems to be ignored

My CAML query seems to be ignored as I'm getting the same result no matter which dates I send. I found an JavaScript example which seemed to work fine until I started to edit my query function ...
Ben's user avatar
  • 3
1 vote
3 answers
3k views

CAML query on special characters

I am trying to get a specific item from sharepoint list, representing the username of the current logged in user. The list has a column called UserName, which has values like: i:0#.f|...
Jacky's user avatar
  • 319
1 vote
1 answer
587 views

CAML Query multiple Lists with same fields

I have 4 different lists with different fields. Now I would like to retrieve items from all 4 of these lists ordered by user "Created By" ("Author") field using CAML. Also, all of the lists have a ...
Gintas K's user avatar
  • 1,237
0 votes
1 answer
597 views

Query List with Geq Today Condition using CAML/SPServices

So I'm using CMAL and SPServices to query a custom Events List to an HTML table. It works just fine with just a SortBy tag with the following code: function getEventList() { var method = "...
Akhmad Agosto's user avatar
1 vote
1 answer
2k views

CAML query order by not being applied with SpServices GetListItems

I am trying to use SP Services to get a filtered and sorted list of data. My service call looks like this. var query = "<Query>" + "<Where>" + "<Eq&...
Sean Scheetz's user avatar
3 votes
2 answers
2k views

Trying to filter values to a People or group field that has multiple values. Tried Both CAML and REST

I have a list called Teams that has 2 columns, 'Title' and 'Team Members'. Team Members is a Person or Group Field that allows multiple values. There are 3 Teams defined in the list with multiple ...
Brad Fortner's user avatar
1 vote
2 answers
175 views

Getting only powerpoint files via CAML query

This is the query I use to get only Powerpoint files from a list: Guid id = new Guid(reportLibrary); // ID for the Report library. Needs to be configured at the beginning of the class. ...
UsefulUserName's user avatar
3 votes
1 answer
1k views

Retrieving recurrent event from a SharePoint Calendar using a CAML query in Reporting Services

I'm building a report using SSRS, for a report ran within a SharePoint site (integrated mode). I'm using the "SharePoint List" as the data source (not a web service). My dataset retrieves events from ...
Wal's user avatar
  • 33
0 votes
2 answers
1k views

SP.CamlQuery().set_viewXml() returns undefined

I am trying to run a CAML query to sort through some data. Once the page finishes loading i do not get the results i want. I checked the functions and it turns out that for some reason, my CAML query ...
IE5Master's user avatar
  • 255
4 votes
1 answer
217 views

Is CAML process at client side, sharepoint server or sql server?

I am now working on some SSRS reports with Report builder 3.0. I built a datasource with CAML to query (and joined) data from SharePoint lists. In production environment there are over 50,000 records ...
Mark L's user avatar
  • 4,065
0 votes
1 answer
246 views

Multiple AND / OR inside my list views filters using the UI, what is the correct way to apply them?

I want to build a list view which have the following Filter criteria- “Item Status != close” AND “Item status !=reject” AND ( (“Type= Team”) OR (“Type=IT” AND “Approved=True” And “Escalated=True”) ) ...
John John's user avatar
0 votes
1 answer
3k views

CAML query filter for items where the current user is in a "Person or Group" field

I have a list with a "Person or Group" field that allows both people or groups. Is it possible to have a CAML query that gets items where the current user is in that field? It would also have to ...
IMTheNachoMan's user avatar
0 votes
1 answer
2k views

Query with Content Type

I am trying to get the ListItems from a generic List with normal/standard Items in it. I have following query: <Where> <Eq> <FieldRef Name='ContentType' /> ...
Snickbrack's user avatar
1 vote
1 answer
861 views

How to get list item value to use in CAML query of SPServices function

I'm using SPFilterDropdown in a NewForm for a drop-down list which will be huge. I'm using the cascaded dropdown function (SPCascadeDropdowns) to reduce the size but I'd also like to filter the list ...
Anthony Horner's user avatar
1 vote
1 answer
347 views

CAML Query does not return person field in custom content type and item content type

I have written a CAML query to return all items that have not been approved in a workflow. The query correctly returns the list items, but the person field that I need from the list item is not ...
John Coltrane's user avatar
5 votes
4 answers
27k views

CAML query using 'contains'

I have a CAML query <Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ ...
Vignesh Subramanian's user avatar
1 vote
3 answers
217 views

CAML query not fetching desired results

I have a CAML query <Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ ...
Vignesh Subramanian's user avatar
1 vote
2 answers
182 views

Retrieve all documents from a view

We have a document library with views created based on a column. This views have documents spread out to different folders. How can i retrieve all the documents in a particular view using CAML query ...
TheCoder's user avatar
  • 469
0 votes
1 answer
3k views

SharePoint REST API CAML Query error : “Every two elements in an array and properties of an object must be separated by commas."

While quering with the CAML query in the SharePoint REST API throws following error. { "error": { "code": "-1, Microsoft.Data.OData.ODataException", "message": { "...
Kushan L Perera's user avatar
1 vote
2 answers
264 views

SPO How to get Year value from custom DateTime field?

On Sharepoint Online, using powershell & CSOM, I am trying to move files and their metadata from an existing doclib into folders, either in the same doclib, or another doclib. The doclib and ...
Barry Prentiss's user avatar
2 votes
1 answer
941 views

CAML Query Multiple ORs (4) and an AND

Sorry, probably an obvious one, but how do I do 4 ORs and an AND? I know that 3 look like this <And> Many other Ands and Ors here </And> <Or> A <Or> B ...
user3643344's user avatar

1 2 3
4
5
11