Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

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 ...
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 ...
5
votes
2answers
83 views

Create list alert with filter on managed metadata field

I'm trying to create an alert on a list. The alert should only trigger on a subset of the list items for which a certain managed metadata field has a certain value. So I'm setting the Filter-Property ...
2
votes
1answer
5k 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 ...
2
votes
1answer
30 views

unable to create a list view to filter my Wiki Pages which contain the following text 'T:\' inside their “Page Content” field

I am working on an enterprise wiki site collection inside our sharepoint on-premises 2013. and i want to create a list view which shows all the wiki pages which contain the following "T:\" inside ...
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: <...
0
votes
3answers
597 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, OtherValue: ...
1
vote
1answer
640 views

How to JOIN two lists by lookup column in Sharepoint Online

I'm a newbie in javascript and i'm using jsom to retrieve list items in Sharepoint Online. I have two lists BnzPersons and Sessions. This is my first code variant: <div id="divListItems"></...
1
vote
1answer
662 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 ...
0
votes
1answer
777 views

Sharepoint Online CAML query very large list checked out files, csom powershell or c#

I have poured over a ton of posts and code and none seem to work with checked out files and really large lists. I am newish to sharepoint, especially online. I moved a doc repo up there for testing ...
0
votes
1answer
688 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
27 views

How to print the result of caml query?

I've got a list with 2 columns col1 and col2. I wrote a CAML query and I want to print the value from the second column corresponding to the value from the first using (SPSite site = new SPSite(...
0
votes
1answer
27 views

javascript plugin working only ctrl+F5

im test new template and using camljs lib. next step to read javascript not work a loop, becouse read htmlcollection aint return length. i can view returns only refreshing with ctrl+F5 or ctrl+shift+...
0
votes
3answers
94 views

caml query won't return rows with null value in contains query

I have written a CAML query using <Or> with <Contains>. the query looks similar to below: <Where> <Or> <Or> <Contains><FieldRef Name="Field1" /...
0
votes
1answer
43 views

how to change caml query with condition <OR> for 5000+ list items

I have this CAML query that wouldn't work if i change it to but works with HOWEVER. since our list no has 15k items using OR doesnt work. basically this remote event receiver gets list items with ...
1
vote
1answer
19 views

Retrieve a Value From A List Based On Who Is Logged In

I currently have the vacation days for all the employees saved in a SharePoint list. I would like to display the number of vacation days the employee that is logged in has on the Home page. For ...
0
votes
1answer
57 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
1
vote
2answers
2k views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed 01/12/...
3
votes
2answers
3k views

Caml Query - skip X first results

Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
1
vote
1answer
35 views

CAML Query with more than one condition

Hi I am currently writing a sharepoint add in application which reads and writes to sharepoint lists. For one of the lists I want to retrieve a list item based on the user logged in and also based on ...
1
vote
1answer
55 views

CAML query returns different data

I created a CAML query that I need to use as a workaround for REST API and the 5k threshold limit: However when I was testing it using the SharePoint CAML Query Helper Online, it returns the correct ...
0
votes
2answers
952 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 ...
0
votes
1answer
1k 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": { "...
0
votes
1answer
1k 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 ...
0
votes
2answers
36 views

SharePoint List Query fails with error “Request failed, cannot complete this action”

I'm trying to query a SharePoint list on my root site collection but keep getting the error "Request failed, cannot complete this action". I messed around with the CAML query below and have figured ...
0
votes
2answers
21 views

Is there a sotfware to create, manager and CAML query SharePoint Lists without having SharePoint installed on a computer?

I'm working on a SharePoint site at work, however due to PCI compliance I am not able to access SharePoint at my house, I was trying to find a software on which I can be able to create lists and use ...
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 ...
0
votes
1answer
44 views

How To: Filter A Query on All Lists Based on Title Contains

I have queried all of the lists within a subsite but need to filter based on criteria in the title. I then need to display the filtered list contents. Is this possible if the list contents are not ...
0
votes
4answers
57 views

How To: Query & Display items from ALL lists within a subsite

I am looking to query and display items from all of the lists that exist (and will exist in the future) on a specific subsite (SP 2013). Below is what I have so far but it is not producing any alert,...
1
vote
1answer
36 views

SharePoint 2010 GetListItems - Problem with CAML Query

This works "<Where>" + "<And>" + "<Geq>" + "<FieldRef Name=\"StartDate\"/>" + "<Value Type=\"Date\">" + DateTime.Now....
1
vote
2answers
12k views

CAML Query in Powershell Issues

I have a powershell script that I am running that executes a caml query to get some list items. The problem I am having is that whenever I execute this query in CAML Builder I am only getting 3 ...
0
votes
2answers
315 views

How to load all list items using caml query?

I'm using SP 2013. And I have a Wiki Page Library. I try to load all items from this list. I'm using the following code: var context = new ClientContext("SiteUrl"); context.Load(context.Site); ...
0
votes
1answer
344 views

Can i reach the lookup column's data with CAML query?

I want to reach list's datas. There is look up column. I am using CAML query. But when i create query with CAML, i am seeing look up column like Microsoft.SharePoint.Client.FieldLookupValue[].I want ...
6
votes
3answers
5k 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: ...
1
vote
1answer
48 views

JQuery / CAML Undefined Error

I found some code on line, see below, and changed it to meet my needs but when I run it I get: Due Date undefined This is the only value in the list, but it should look like: Due Date 01/31/2019 ...
0
votes
1answer
118 views

CAML Query : Where clause not working with View tag & RowLimit

I've reached the maximum view threshold limit on a SharePoint List, with a little more than 5000 item in it. When I raise the limit in the webapp's settings, everything is working fine, but I would ...
0
votes
1answer
633 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?
0
votes
3answers
39 views

caml query that searches for specific records

hello everyone form this query to find column records until this moment works for me but when I want to add that look for other records of the column department gives error I would appreciate your ...
0
votes
3answers
29 views

When running a CAML-Query without OrderBy: Are IDs always incremental?

I want to bulk load a few items from a list. The Caml is something like this: <View><Query><Where> <Gt><FieldRef Name=\'ID\'/><Value Type=\'Number\'>{id}</...
6
votes
1answer
154 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 ...
1
vote
1answer
44 views

Get the list specific rows from sharepoint where value exist

I am working in c# and I have a list of strings which contains the projectid of the SharePoint list List<string> guidlist = new List<string>(); // contains project ids On the basis of ...
2
votes
1answer
228 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 ...
1
vote
1answer
277 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 ...
0
votes
0answers
22 views

CAML query inside my List view which contain 19 critiria is not working

I want to create a list view inside sharepoint on-premises team site. the list view need to show items which are under any of the 18 customers + that are not Expired.. so i wrote the following CAML ...
2
votes
1answer
2k views

GetItems from SPList case sensitive

I have troubles with CAML Query and GetItems method from SPList. I get a SPList from web context: SPList docTypeList = _web.GetList(string.Format("{0}{1}", web.ServerRelativeUrl, "DocumentType")); ...
1
vote
2answers
90 views

CAML: Not in Group

Building a CAML query in SP. Want to result item where current user not in group that is in the AssignedTo field. Tried wit Neq, NotIncluded: <View> <Query> <Where> <...
1
vote
2answers
11k views

CAML query OrderBy is not working

SPWeb _SPweb = _SPSite.OpenWeb(); SPList _SPlist = _SPweb.Lists[FL.ToString()]; SPQuery _spquery = new SPQuery(); _spquery.Query = "<Query><Where><Eq><FieldRef Name='Title'/>&...
0
votes
0answers
9 views

Two lists with Site, one with site number, and one with column with many site number Need Assistance

I have got two lists one with one site number in record, and one with many site numbers in one column: -------------------- --------------------------------- | Site | Name | |...
1
vote
1answer
34 views

CAML Query Dynamics with SPServices

I'm developing a web application using SPservices for interaction with Sharepoint lists. My question is on how to create a dynamic Caml Query using the And and Or conditions. The condition below ...
0
votes
1answer
218 views

Get files modified or added yesterday from SharePoint document library

I am trying to get all the files which is modified or added yesterday from SharePoint document library using below code. List list = clientContext.Web.Lists.GetByTitle(listName); ...