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.

127 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
157 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 ...
6
votes
1answer
2k 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 ...
3
votes
0answers
105 views

Construct CAML Query from ListView Filter URL-Params in SP2013

Im trying to construct a CAML query from the current Listview filter settings. I dont know in prior how many filters the user may set. My goal is to create a CAML query which has the exact same ...
3
votes
0answers
364 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 fall ...
3
votes
0answers
82 views

<In> overrides everything else in SharePoint CAML query

I'm writing a CAML query for SharePoint. The list contains a term set field. I want to get all list items having specific terms, plus items where no term is set. My query contains this: <Or> ...
2
votes
0answers
23 views

Sharepoint CAML Query does not work in IE when searching by Taxonomy Field

I've the code below: function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){ var restUrl = "https://tenant.sharepoint.com/sites/sites/Negocio/...
2
votes
1answer
313 views

Include All day events in CAML query for a date

I'm querying SharePoint for calendar events given a date. This works for events other than all day events. Event dates in SharePoint are stored as UTC except for all day events which are stored as ...
2
votes
1answer
335 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 ...
2
votes
0answers
99 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 ...
2
votes
0answers
72 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 ...
2
votes
0answers
1k 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 ...
2
votes
2answers
65 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
50 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 Type="...
2
votes
0answers
71 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 ...
2
votes
0answers
123 views

CAML Query scheme in depth

I have a plan to develop my own version of the CAML builder app - as a pet project and in order to improve this field. :) It would be nice to support all the capabilities of the CAML query scheme ...
2
votes
3answers
5k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: <...
2
votes
0answers
1k views

How to find out whether or not a list is hidden without writing code (SP2010)?

Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"? I have a CAML query which contains the following and I'd like to eliminate the possibility ...
1
vote
0answers
257 views

CSOM (HighTrust) SP2013 Group by aggregate giving duplicates

Hi I've been reading about group by in SharePoint 2013 CSOM from this article here. https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint I've recently upgraded to 2013 and though ...
1
vote
2answers
409 views

Filter and Sort the List with Caml Query

We are required to display the list data based on below 3 conditions for the based on 3 columns (Customer Category, Test Type ,Exercise Result) and sort with column (stage Plan) . 1. Customer ...
1
vote
0answers
230 views

CAML Query to get filename with the corresponding DocumentSet

I have a document library with Document Sets, and inside document sets I have files. I need a CAML Query to return ONLY the files, but I need to know to which Document Set each file belongs to. I am ...
1
vote
1answer
125 views

CAML query range does not bring correct number of results

I have a CAML Query that brings 53 results. When I add the range below I get 13 results instead of 10. <Range> <StartAt>41</StartAt> <Count>10</Count> </Range&...
1
vote
0answers
58 views

CAML Query preserve line breaks

I am querying a list containing a multi-line text-field using CAML. However - how do I preserve line-breaks when retrieving the content? The field contains HTML-markup using <pre> tags. Any ...
1
vote
1answer
36 views

Internet Explorer 8(Default) Issue, Chrome is Ok

I have created CAML query. Below is the code for searching list item. <input type="text" style="width:350px" id="txtSearch" /> <dl class="dropdown"> <dt> <a href="#"> &...
1
vote
0answers
140 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 ...
1
vote
0answers
33 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 ...
1
vote
0answers
172 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 ...
1
vote
2answers
458 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: ...
1
vote
1answer
332 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 ...
1
vote
2answers
57 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. ...
1
vote
1answer
159 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 ...
1
vote
0answers
192 views

SharePoint REST API & CAML query integration Online Add in/App

I am trying to integrate CAML query in rest API and trying to get data from a SharePoint List residing in host web. I am using method: function getDataWithCaml(listName, caml) { var executor = new SP....
1
vote
0answers
28 views

How can i retrieve only sub folders inside a folder in a document Library?

How can i retrieve folders and documents that are immediate child in a folder (level 1).
1
vote
1answer
404 views

Getting the object values of a hyperlink column using JSOM

I have a column defined as a Hyperlink or Picture. Using JSOM and CAML in the CAML is have specified <FieldRef Name='HyperLinkFieldName' /><Value Type='URL'></value>" I'm able to ...
1
vote
1answer
417 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
0answers
47 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?
1
vote
1answer
707 views

Sharepoint Online REST api CAML query not returning file related columns

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 the ...
1
vote
1answer
162 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
1answer
444 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 are a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
2answers
290 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
0answers
122 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
0answers
220 views

SPServices new item return expanded user information

I'm creating new discussion in a list using SPServices, like this: $().SPServices({ operation: "UpdateListItems", batchCmd: "New", listName: discListName, updates: "<Batch OnError='...
1
vote
1answer
6k views

The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested

I am getting below error on the second request. Strange thing is its not occurring on first request. The collection has not been initialized. It has not been requested or the request has not been ...
1
vote
0answers
90 views

CAML, how to get Fields which are having Unique condition

I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true. IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list =&...
1
vote
0answers
47 views

Is there any way to implement numbered pagination instead of PREV | NEXT using JSOM without using search

I'm wondering if there any way to implement Numbered pagination while retrieving items from a list like "PREV 1,2,3..NEXT" instead of just having "prev | next". I followed this code example MSDN and ...
1
vote
1answer
2k views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
1
vote
1answer
39 views

MINUS Operator in CAML

I need to use MINUS Operator in my CAML Query. Is it available in CAML? Looking for answers. Thanks in advance
1
vote
1answer
37 views

Retriving list items

I am retrieving my list items using the current time, but my code is retrieving nothing. Please anyone help me out on this. Here is my CAML code: camlQuery.set_viewXml("<View><Query><...
1
vote
1answer
416 views

Delete items from document library based on criteria just like WHERE clause in SQL statement

Is there a way to delete items from a document library based on some criteria for e.g. delete all documents whose created date is less than 1/1/2012. I know it can be done through code but I am ...
1
vote
2answers
34 views

How to query Range

Right now my code is is Equals in the query how can i prevent for example that if i book 2014-12-01 01:00 to 2014-12-02 01:00 This is a hole day, that no one else can for example book the same time ...
1
vote
0answers
228 views

CAML Query to get only items from SharePoint Library

I have a large document library with folders, I'd like having all the items except the folders. for now, i use this where columns is a list of all internal name from the list CamlQuery q = CamlQuery....