Questions tagged [caml-query]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
694 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
1answer
725 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
14 views

how to get file from library which stored in unknown folder( need c# csom)

I have library which has many folders and I have file name and want to find using name of the file from those folders (dont know in which folder that file placed). please help to write code using c# ...
0
votes
1answer
710 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 ...
2
votes
2answers
740 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
2answers
15 views

Order List Using Caml Query in a text field as a number on SP 2010

How can I order a Column where the type is text, but all the values stored are numeric, I want to order it descending but considering the Column a Numeric field without changing the column type ...
2
votes
1answer
798 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
749 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 ...
2
votes
1answer
688 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
1answer
390 views

CAML Query Where Items are Approved is Ignored

I am working with some custom web parts recently. Those web parts will only display items which have been already approved. To get the items, I use CAML Query and filter the modstat value like: <...
2
votes
1answer
783 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 ...
0
votes
0answers
11 views

Possible to get tasks based on a local custom field value using Project Server JSOM?

I have been working on a web part that lives on a SharePoint site in a Project Web App instance, and interacts with Project Server using the Project REST API. I need to be able to get tasks based on ...
0
votes
1answer
19 views

CAML Query to search comma separated values similar to SQL query

Instead of below query, is possible to write dynamic CAML query for below CAML query. because below query will not work for dynamic data: <Where> <Or> <Or> &...
0
votes
2answers
32 views

Caml query to retrieve image from a document library

I am currently facing an obstacle where I have to create a webpart that uses CAML to get the latest image from a document library in Visual Studio. May someone share their code with me on how to do ...
2
votes
0answers
20 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/...
0
votes
1answer
19 views

Fetch All fields from a people group field using Caml Query

I have a SharePoint list which contains a people or group field where I want to fetch the Id which is stored internally and name is displayed. Can anyone tell me how to fetch all the values from ...
1
vote
1answer
741 views

Uncaught Error: Sys.ArgumentNullException: Value cannot be null. SharePoint 2013 JSOM

I am trying to retrieve items from a Sharepoint 2013 list using JSOM with CAML query. camlQuery.set_viewXml('<View><Query><Where><Eq><FieldRef Name=\"Title\" /><...
0
votes
1answer
1k 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
0answers
19 views

Accessing and counting from same list only works once

I've been trying to show a count subtracted from a maximum of 35 for a seating count. I've tried everything I can think of and have come to a dead end for myself. What am I doing wrong in my below ...
0
votes
1answer
23 views

CAML query to enable/disable custom ribbon button

I have a custom list and when the user open the list item Display form there is a custom ribbon. This ribbon should be enabled if the current user is a member of a particular Group. Here is the caml ...
0
votes
2answers
970 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 ...
1
vote
1answer
18 views

CAML QUERY does not work in IE11 when searching by content type

I've this code below: function BuscarDocumentosHoje(Departamento,NivelAutorizacao,NumeroColaborador,todayfinal){ var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/Precario/_api/web/...
0
votes
1answer
11 views

Using Count values in another function for my Chart.js Pie Chart

Using Chart.js to display a Pie Chart. However, I'm hard coding the data values. Below is the entire code: $(function(){ //Start Data Pull //End Data Pull //get the pie chart canvas var ctx1 =...
0
votes
1answer
17 views

CAML - Querying with multiple WHERE Clause

Getting my feet wet on CAML. I was able to get a query that shows a count for a list. Now I need to do count based on multiple information. Dog Dog Cat Cat Cat fish fish fish fish Loops through and ...
0
votes
1answer
21 views

Count to display in a page

I received this fix via StackExhange Sharepoint but I can't seem to locate it again for my post (sorry)...but it did work using CAML Query to count items in a list.I want to change one thing...I want ...
0
votes
1answer
33 views

Create custom webpart that uses CAML Query

I am quite new to Sharepoint and I am supposed to create a webpart that can display all the titles with a specific value from a managed metadata column(TAGS). I am required to write a CAML Query to ...
1
vote
1answer
55 views

Get unique value using Sharepoint CAML Query JavaScript

I've this code below: function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){ var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/OfertaParticulares/...
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 ...
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 ...
0
votes
0answers
19 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
70 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
114 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
602 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
652 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
8k 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
92 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
631 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
28 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
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='...
0
votes
0answers
17 views

How to retrieve all the SharePoint surveys I didn’t answer yet?

How to retrieve all the SharePoint surveys I didn’t answer yet using Rest API?
0
votes
1answer
28 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 ...
0
votes
0answers
17 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
50 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
2answers
509 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
133 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" /...
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
60 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
62 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 ...