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.
541
questions
1
vote
1
answer
89
views
How to speed up file reading using SharePoint CSOM?
I have created a function using the SharePoint CSOM to extract all files within a Document Collection (List) using the below code however it takes over 5 minutes to get a list of 3671 files.
Is it ...
- 113
0
votes
1
answer
254
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 ...
- 307
0
votes
1
answer
229
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 ...
- 307
0
votes
2
answers
74
views
how to get this CAML query to work
I have a javascript and i can't get the CAML or listitems.
//http://vadimtabakman.com/nintex-forms-multilingual-form.aspx
NWF$(document).ready(function () {
var language = NWF$('#' + ...
- 177
1
vote
1
answer
29
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' />&...
- 111
1
vote
3
answers
178
views
CAML queries suddenly quit working; SP Online; SPServices
I have CAML queries performed against SharePoint Online lists through SPServices that have worked beautifully for 5 years. Sometime in the last couple of weeks they started returning incorrect results....
- 35
0
votes
1
answer
174
views
Get single field value for all items from a list having very large number of items
I have a list with about 100K items. There could be gaps in the beginning and in between for SharePoint generated Ids of these items (due to deletions). List items data is live and keep changing. My ...
- 666
0
votes
1
answer
55
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); ...
- 115
0
votes
2
answers
2k
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....
- 1
1
vote
1
answer
162
views
CAML Query not Working Correctly
I want to return the events in an Event Calendar for the current week for a web page. I would prefer the current week Friday through Sunday, but that seemed too complicated.
When I use this code it ...
- 37
0
votes
1
answer
733
views
Get-PnPListItem : Cannot complete this action
I am trying to get an item in a SharePoint list using a CAML query so that I can update it. I am using data in a CSV file but when I run the script, it's failing on Get-PnPListItem. Based on some ...
- 3
0
votes
1
answer
179
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>
&...
2
votes
0
answers
38
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/...
- 385
1
vote
1
answer
4k
views
CSOM CAML query with ID row limit 1 returning list threshold error
I'm using the following CAML query in my CSOM code to try to determine the highest list ID in a list. I'm getting the standard list threshold limit error (because the list contains over 23000 items).
...
- 155
0
votes
1
answer
79
views
SharePoint CAML Query - Chinese Site
Trying to select from Library(Chinese Characters) getting -Object reference not set to an instance of an object - This working for English sites - Not sure how to convert?
ClientContext context = ...
1
vote
1
answer
71
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/...
- 385
0
votes
1
answer
167
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 ...
- 307
1
vote
1
answer
434
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/...
- 385
0
votes
1
answer
210
views
Not understanding why one CAML query is throttled, but not another
I am not understanding why this CAML query from CSOM is getting throttled:
<Query>
<Where>
<And>
<Eq>
<FieldRef Name="Period" />
<Value ...
- 155
2
votes
1
answer
47
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 ...
5
votes
2
answers
610
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 ...
- 162
0
votes
1
answer
303
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
1
answer
50
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
1
answer
206
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 ...
- 284
1
vote
1
answer
34
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
1
answer
308
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 ...
- 551
1
vote
1
answer
113
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 ...
- 17
1
vote
1
answer
451
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 ...
- 284
0
votes
2
answers
425
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 ...
- 11
0
votes
2
answers
36
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 ...
0
votes
3
answers
826
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
1
answer
444
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 ...
- 71
0
votes
4
answers
275
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,...
- 71
1
vote
1
answer
70
views
SharePoint 2010 GetListItems - Problem with CAML Query
This works
"<Where>" +
"<And>" +
"<Geq>" +
"<FieldRef Name=\"StartDate\"/>" +
"<Value Type=\"Date\">" +
DateTime.Now....
- 13
2
votes
2
answers
1k
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);
...
- 313
1
vote
1
answer
162
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
...
- 37
1
vote
1
answer
809
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 ...
- 13
0
votes
3
answers
99
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 ...
- 15
0
votes
3
answers
104
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}</...
- 774
1
vote
1
answer
673
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 ...
- 321
1
vote
2
answers
298
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>
<...
- 428
1
vote
1
answer
158
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 ...
- 13
0
votes
1
answer
748
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);
...
- 31
2
votes
1
answer
860
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 ...
- 121
0
votes
1
answer
111
views
Unable to get exact result for CAML Query
I am trying to execute below condition in REST , But OData in Rest
doesn't support null . I would like to execute below condition in
CAML Query and Pass to REST.
Tried using CAML Query ,But I am ...
- 1,155
0
votes
1
answer
364
views
Unable to Query list's items using Rest API + CAML. Error "One or more field types are not installed properly...."
I want to query my custom list using REST API + CAML. And I have to use POST request to be able to get the managed metadata values (mainly Label), so I tried the below Ajax request:
var body = {
...
1
vote
2
answers
3k
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 ...
- 21
1
vote
1
answer
113
views
How to get all documents in given Documents Set in SP2016 using JSOM?
I have client-side Javascript on a SharePoint page. It must change the Title of every Document present in a specific Documents Set.
That Documents Set is one of many, in a huge documents library (...
- 278
0
votes
0
answers
129
views
CAML Query Type as text, show all items
I have this query
camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>21094460</Value></Eq></Where></...
- 25
0
votes
0
answers
38
views
How can i fetch custom list columns with javascript?
I created a list and it has got GroupName and EmailName columns. I want to fetch the data but this code is not working. How can i solve this?
var GroupName=$(this).attr("GroupName");
all the ...
- 641