Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
881
questions
0
votes
1answer
7 views
SharePoint 2010 CAML - Casting Date Fields?
So I'm trying to build a CAML Query in SharePoint to query a list where Date is greater than a certain value say 1/1/2016, my CAML looks kinda like this
<Where>
<Geq>
<FieldRef name = '...
0
votes
1answer
41 views
CSOM CAML Query - is there a returned fields limit?
I've just noticed that that there is a difference in result when searching for a list item with CAML Query and getting it by ID.
Following piece of code returns item with 100 FieldValues:
var item = ...
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
1answer
22 views
Getting and setting multiple items from a Sharepoint list using CAML query?
I have a SharePoint list Catalog.
Using camlQuery I can get a list item value called Price.
With the following code I get the Price value of the list element which has the ID 5 and store it in a ...
0
votes
1answer
33 views
How to retrieve the SP list items without using CAML Query?
I have a SharePoint list and I need to get all items from that list without using CAML Query in JSOM.
How can I do this?
1
vote
1answer
34 views
Error retrieving items from large list, although the CAML query has a row limit
I'm able to use a console application to connect to a SharePoint Online large list (more than 5,000 items) and retrieve the title. However, even though my CAML query has a row limit, I still get an ...
1
vote
6answers
9k views
Filter list data using SPServices, CAML Query, and dropdown list
I'm trying to create a table using SPServices to fetch the data, and filter it using CAML Query and a drop down list. I would like to create three conditions:
A. If no item from the list is selected, ...
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
1answer
29 views
Query a single line of text filed using CAML <Contain> will return all items
I have a list inside SharePoint online site collection. the list contain a field named Processed which is of type single line of text, and only one item have a value inside this field while the other ...
0
votes
1answer
37 views
CAML Query Help - O365 Sharepoint with Managed Metadata
I'm trying to display only documents from a library named "How to get it done" and I want to show all document types that have the Managed Metadata tag of "HFM".
Some of my documents have multiple ...
0
votes
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
2answers
652 views
CAML Query for retrieving only document library items in only one folder
I'm trying to access the documents in a specific folder in a SharePoint document library. the library has multiple folders but I do know the name of the folder.
here is an example of the file tree (I ...
1
vote
1answer
33 views
Binding certain value from SP List to DropdownList
I am currently trying to grab certain values(choice column) from a SP list into a DropdownList in Visual Studio, for example, currently in the SP List choice column, there're 5 choices altogether but ...
0
votes
3answers
39 views
CAML error when querying SharePoint List for more than one input
I have a CAML query which retrieves data from a SharePoint list. It passes for 1 input, but fails when there are 2 or more.
Error:
Microsoft.SharePoint.SPException: One or more field types are not
...
0
votes
2answers
708 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, ...
0
votes
1answer
17 views
Query Modified Date
I found tons of samples with query for modified. But following keeps giving an exception that the query limit was to large (I gues it is the threshold limit).
var query =
$@"<View Scope='...
2
votes
5answers
12k views
CAML Query Filtering with OffsetDays
I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this:
If a date is not specified on the Query String, then show me items
created in the last 30 days
If a date is ...
1
vote
1answer
606 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 ...
1
vote
1answer
679 views
using SSRS to generate a report based on a Calendar in Sharepoint 2013
We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
2
votes
3answers
84 views
How can i add CAML query to my page?
Sorry for this basic question.I want to read list items. I will use CAML query . But i dont want to use Visual Studio and C#. Is there any way to do this?
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
608 views
Programmatically get pages which are created using custom page layout
I have custom ArticlePage.aspx page layout.
I have created some pages in Pages library using ArticlePage layout.
Now programmatically. I'm trying to get that pages with their properties.
I did ...
0
votes
1answer
29 views
'n' number of CAML queries in a single executeQueryAsync function
How to execute 'n' number of CAML queries to get a different list of objects? We can use multiple clientContext.load() if we have a defined number of queries like clientContext.load(collListItem); ...
9
votes
3answers
13k views
Make CAML query with in rest api call
I have a SharePoint list and i need to get the list items by using JSOM.how to add CAML query with in the API method?
i have used the below code
var url = "/_api/Web/Lists/GetByTitle('list')/...
0
votes
2answers
697 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
733 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
597 views
Run CAML Query on DataTable SharePoint
I have a DataTable having Some rows. Is there any way to execute CAML Query on it.
Or Alternatively, How can I convert this DataTable into a SPList so tha CAML can be executed on SPList.
private ...
1
vote
2answers
692 views
How to use CAML query with rest
I am trying to get list data with an id from my SharePoint online through REST. I have my ajax call like below.
getFunction:function(id){
return new Promise(function (resolve, reject) {
$.ajax({
...
0
votes
1answer
795 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 ...
3
votes
1answer
720 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
794 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
2answers
772 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
1answer
18 views
If Else in the CAML Append Method
I have been trying to do an if else condition in the append method however for some reason it's not reading the condition. Here is the code. Towards the bottom I want to show signNow if the list ...
0
votes
1answer
23 views
CAML - Getting the URL's ID for the Where Clause
Is there a way to get the ID from the SPGetCurrentSite? I want to use in my Where clause for my CAML Statement/ID field in the SharePoint list item. I'm new to CAML and I was using the below but I'm ...
0
votes
1answer
30 views
Help with using Caml in rest api calls - filtering doesn't work for me
I'm trying to filter a Posts list(Blog) by month and year.
I created a calculated column and used the Published Date to extract month and year.
But my below code doesn't filter correctly when i use ...
0
votes
2answers
641 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....
2
votes
1answer
916 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
0answers
13 views
Having trouble with SPServices AutoComplete pulling from specific columns
I have 2 issues really. I have set this up successfully for some of my fields on my Nintex form. The autocomplete works perfectly.
Issue 1: I attempted to set this up on another field on another ...
2
votes
1answer
797 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
1answer
46 views
CAML Query “Neq” not working with choice field
I an writing one CALM query as below. But seems like Neq is not working for choice field. I am getting wrong results.
Does anyone know the work around.
<View><Query><Where>
<...
1
vote
2answers
52 views
CAML Query: filter items between dates
How to filter items between two dates with camel query?
For example, I want to retrieve items created between 2019-9-1 and 2019-10-5.
0
votes
2answers
39 views
CAML - How to handle filter?
SP 2010. I have a value "East & West" and list name Region. How do I handle special characters?
here is the caml that breaks
<ViewFields>
<FieldRef Name='ActionStatus' />
&...
1
vote
1answer
19 views
Combine 3 queries for different lists into one
I am building API for client side apps. There are 3 API requests for 3 different lists as following:
tasksQuery = string.Format(@"<Where><And><Geq><FieldRef Name='Created' />&...
0
votes
1answer
24 views
How to set InfoPath form fields values in task list without using workflow?
I have 5x action items fields on the InfoPath form. This form have more than 500 fields so get touching the boundary limits in terms text box fields datatype. Is there any way that we can set the form'...
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
2answers
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 ...
0
votes
2answers
132 views
SharePoint CSOM list group by and filter
I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3?
ClientContext ctx = new ClientContext("https://sharepoint.blah.com");
List list = ctx....
0
votes
0answers
16 views
Populate Fields when Clicking “Save” on Custom List
I have a SP 2013 Custom List with 2 automatically generated numbers. Currently, they are queried and populated upon selection of input values for the first 2 fields. The form works great for a single ...
0
votes
1answer
78 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 ...
1
vote
3answers
223 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 ...
