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-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

0
votes
0answers
4 views

Will a CAML query using Method and Filter against an external list be passed through to the external data source?

I have an external list/content type set up that reads data from a SQL database view. (I only have access to one view, I do not have access to any tables directly.) This database has been around for ...
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 ...
0
votes
2answers
35 views

Get User Name Using CAMLQuery

In a CAMLQuery what token can we use if we want to query against a person or group field with value as our user account?
5
votes
2answers
81 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 ...
1
vote
1answer
600 views

CAML query - examine Contents column used in freetext predicate

In my query I use the freetext predicate: and freetext(Contents, 'my search string') I'm getting some unexpected results from this search, namely the documents contain no relevant content, yet are ...
0
votes
2answers
620 views

SharePoint SPServices query and sum list items

I have 3 dropdown menus, in those 4 fields I have choices to query a SharePoint 2010 list using SPServices Dropdown filters are: Year, Month, Company List fields are: Year, Month, Company, ...
5
votes
4answers
7k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists.
0
votes
1answer
90 views

SharePoint notification

I am trying to make a dynamic notification field which shows the number of for example not approved items in a list. But this needs to be shown always, wherever I am in SP. It should look like: Home ...
0
votes
2answers
620 views

Update filed values based on conditions

i have document library in sharepoint 2010 and i want to update a field values based on some conditions . I need that every parentid has some documents and i want to update those prosessnos which ...
0
votes
1answer
22 views

Filter list data after retrieving the list using JavaScript

I am trying to carry out a number of queries on a share point list. I know you can use CAML queries to filter the list to only show specific information. However I am looking to retrieve the entire ...
0
votes
1answer
647 views

SharePoint Online CSOM CAML query problem in view

I have a pages library in sharepoint online with 2 views. Custom view - (I have added a condition in the view based on a content type) - contains 500 items, It has got 100 items where title starts ...
0
votes
0answers
12 views

Get no data when querying with date in caml query sharepoint

When I am trying to query on any date field I am not able to get any data even with caml query: <Where> <Eq> <FieldRef Name='date' /> <Value IncludeTimeValue='...
2
votes
1answer
675 views

CAML batch query - valid XML?

The standard format of a CAML batch query is as follows: <?xml version="1.0" encoding="UTF-8"?> <ows:Batch OnError="Continue"> <Method ID=""> <SetList>288a3dfc-ec52-45aa-...
0
votes
0answers
17 views
0
votes
1answer
700 views

How to write Join 4 lists using CAML Query (CSOM)

I have four lists in my site. I need to get data from all these lists in CSOM (Provider hosted app). All these lists are connected linearly (one to one). List 1 -> List 2 -> List 3 -> List 4. for eg ...
0
votes
1answer
687 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 ...
2
votes
1answer
768 views

Sharepoint CAML IN operator not working with FileDirRef

I want to retrieve a list of file from two folders. When I combine two <Eq><FieldRef Name="FileDirRef" />... with <Or> it works fine. When I want to use the <In> operator it ...
0
votes
1answer
17 views

sharepoint Image gallery application with lighbox

I want to create Image gallery widget in my sharepoint website that will access the image from sharepoint list.Below is my requirement Image gallery view will display in carousel or slider when we ...
1
vote
2answers
715 views

Multiple CAML query to filter Data list view

My Custom list has four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view. In my page, there are 4 text boxes and a Button is there for the user ...
0
votes
0answers
16 views

Sharepoint application to show image gallery in carousel

create a photo gallery with lightbox feature as well in sharepoint website with carousel as the image will show in slide and when the click the current image that will display on screen it display ...
1
vote
2answers
35 views

Issue while retrieving data in SPFX

I am trying to get data in SPFx using REST and also need to use CAML for making the query. CAML is required as I want to filter based on certain groups the user is present in, so giving that up is not ...
0
votes
0answers
17 views

Sharepoint 2013 CSOM get subfolder items only

I want to get particular folder or subfolders items only on demand, not all recursive. My code so far: private static void GetListItems(string relativeUrl) { var context = new ...
0
votes
1answer
724 views

Concatenating a javascript variable into a camlQuery

I have a caml query that I'm concatenating with a javascript variable of type string. It queries the column names 'Audience' and returns the first 3 ordered by the newest. The variable subsite gets ...
0
votes
2answers
442 views

sharepoint CAML query in Ascending order

we have webpart that fetch the data from the sharepoint list camlQuery.set_viewXml("<View></View>); now i am trying to do sort the display by enddate (ascending order) camlQuery....
0
votes
3answers
93 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" /...
1
vote
1answer
771 views

Manage files with no checked in version - CAML query

I am using Office 365. We have a document library containing more than 12000+ documents, with a number of folders and subfolders. I need to find a way to get all document which have no checked in ...
2
votes
3answers
6k views

Unable to return items under folder using CAML

I have a folder in the default "Images" library under my site, called Menu Icons: /PublishingImages/Menu Icons I want to retrieve only the images under this folder, and not all images under the root ...
0
votes
1answer
41 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
0answers
50 views

Check if Parent Folder contains more than 1 document and then delete particular document CAML Query SharePoint 2013 CSOM

I want to delete document with name 'Test' in CSOM. this document is present in subfolder. whereas code should delete this document only if its parent folder(i.e subfolder) has more than 1 document. I ...
1
vote
1answer
18 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 ...
1
vote
1answer
27 views

How can I get a subfolder's GUID which is under a document library with soap and javascript or CAML query?

I want to fetch this subfolder's documents. but CAML is not showing the documents clearly . thak you.
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/...
2
votes
1answer
21 views

Order By Ascending with CamlBuilder()

How to write a function to order by ascending: true for date field. There is a picture library in our site. I find .OrderByDesc('year'), but I need it's opposite: var query = new CamlBuilder() ...
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
0answers
105 views

JSOM: CAML Query List view threshold error for large lists

This is a topic discussed many times before but I have a peculiar case now and need some expert opinion on this.Below is a sample scenario I am trying to test: My List Set up: List has 10k items. ...
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 ...
1
vote
0answers
17 views

Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS

where DocumentOwner(People Group Type Column) = Me (Current Logged in User) Here i save current logged in user in a variable named as OwnerTitle and RequestStatus(Choice Type Filed) is equals to ...
0
votes
2answers
951 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
38 views

Camlquery Datetime strange problem

Sharepoint hosted app where saving and reading data from sharepoint list. Getting time to Datetimepicker and convert it to current timezone: var Time1 = $('#TextBox_Startdate').val(); var ...
0
votes
1answer
976 views

Document Library File GUID

I used a CAML query to get file information in a document library. In the CAML query I get the GUID in order to get the unique id of the document. <FieldRef Name='GUID'/> In a different ...
0
votes
1answer
37 views

Build caml query in javascript in sharepoint designer

<script type="text/javascript"> $(document).ready(function () { var listName = "Leave Request"; var context = new SP.ClientContext.get_current(); var list = context.get_web()....
0
votes
1answer
61 views

Caml Query weekly and monthly

I want to build a CAML query that show the data on monthly and weekly basis. Please help me to provide the best solutions for the query In SharePoint there is a list created for leave application ...
0
votes
1answer
65 views

Searching through REST API and CAML with Paging

I have requirement to filter two fields with substring but I found out that substring is not working in REST API it have some kind of bug. So below question stackexchange.com suggested to use listdata....
0
votes
1answer
42 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 ...
2
votes
4answers
2k views

Sp Services and calendar list

I have a SP Service call which uses GetListItems from a calendar list in SharePoint. I'm using it with the FullCalendar plugin. The events render fine that is not my question, my question is this: Is ...
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,...
11
votes
2answers
15k views

CAML query for field of type “Person or Group” which allows multiple selections

Consider a list which has a column of type "Person or Group" (single selection) witch contains a SharePoint group. I want to return all rows for which the group is within a list. I know the IDs of the ...
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 ...
4
votes
2answers
317 views

Filter Fields using Caml Query

Normally I have this query, filtered with MostrarHome eq 'No' var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&...