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
2answers
29 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
78 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 ...
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
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
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 ...
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 ...
0
votes
0answers
16 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 ...
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
1answer
40 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
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
0answers
47 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
26 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.
2
votes
1answer
20 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()
...
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
100 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
54 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
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
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
62 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
3answers
92 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
41 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,...
2
votes
0answers
39 views
SPQuery.viewFields does not return specified fields
I have a list that contains multiple views. I am filtering the view data on the basis of date range using CAML Query. But I don't want all the fields to be return so I used viewFields property of ...
0
votes
1answer
57 views
How to change date display
Currently the below code gives me a date display of: 2019-01-31 00:00:00. I would like to see it displayed as: 31 January 2019 instead...
<table width="35%" align="left" id="myHTMLTable" border=...
1
vote
2answers
168 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 ...
0
votes
2answers
309 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
124 views
Caml Query problem, cannot complete this action
I am new in sharepoint development, Can anyone please help me find an error in this query?
I am using javascript to retrieve records.
The where clause is based on status and priority fields.
Query ...
0
votes
1answer
109 views
wrong datetime returned in caml query in c#
I have custom list in sharepoint 2016 on-premises. There are several columns in DateTime type. I need to query this list in C#, but when I run my query I get wrong dates - I get always the day before ...
1
vote
1answer
29 views
CAML Query issue - OR and AND
I'm working on an application that uses a CAML query to return certain documents based on a number of search and filter parameters. I need some assistance with a query that uses both AND and OR ...
0
votes
1answer
33 views
CAML Query - Results
I've got a mad issue. I'm doing a caml query on a couple of lists.
When I make the query with querying the contenttype I get 2 results. If I remove the contenttype from the query, it returns no ...
0
votes
2answers
128 views
Contains CAML query returns only DISTINCT items
I am trying to write a CAML Query that returns all items from the list where in the "Title" field they contain "No Title". (In order to delete them later).
The deletion is done in Csharp.
I have ...
0
votes
3answers
85 views
CQWP / CAML - Query returned a greater number of results than the web application's query throttling limit
The Issue
I have a CQWP which appears to be configured to run with a CAML query (I'm a complete novice with CAML - I've inherited this set-up). It has been used successfully, until recently, to run ...
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}</...
0
votes
2answers
147 views
CAML Query vs Odata Query string operators
For getting SharePoint list values through rest. I came through two solutions
writing CAML Query in the body of AJAX call
Odata query selector operators(eq: select,expand) in the url
...
1
vote
2answers
316 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({
...
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 ...
0
votes
1answer
140 views
Sort list from camlQuery
I am using SP.CamlQuery.createAllItemsQuery() to grab all items from a custom list in SharePoint, however even though the list itself is sorted in an alphabetical order, when it comes through to 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 ...
0
votes
1answer
30 views
How to Edit/Add to a CAML query return object?
Team,
Is there anyway at all, to add the input parameter "issueItem" into the CAML query result, i.e. tag each row of the result, so that when its passed back I can extract it at the same time as the ...
0
votes
1answer
42 views
Can't return data with CAML Query
i'm new to SharePoint so I might be asking something silly, or maybe doing silly mistakes, but i've looked it up all over and couldn't find a solution.
So Basically I want to access a Sharepoint list ...
1
vote
1answer
225 views
How to count SharePoint list elements using CAML Query
I have got CAML Query. How to count how many elements is in the list checked ?
Here is javascript code:
var siteUrl = '/sites/MCUW-IT/kostka-pilotaze/restauracje-pilotaże/';
var clientContext =...
1
vote
2answers
87 views
How to perform nested CAML operations using promises?
Team,
I have 3 lists, (a) Issues (b) Risks (c) Incidents. I want to...
1 - Run a CAML query against (a) Issues list to get all the issues not closed.
2 - then run a loop through the titles, and use ...
0
votes
1answer
44 views
Pass number of site from one list to another: Need assistance
I need to pass from one site to another number of site and shiow this record on the View. If I passing record by ID it's all work great, but when I pass by caml Query nothing happening. I tried many ...
2
votes
2answers
255 views
How to get all the files which is 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);
clientContext.Load(...
0
votes
0answers
19 views
Need help on SPSiteDataQuery
I like to retrieve data from two linked lists. Tried CQWP but the XML was too difficult.
The parent list is PIR, the child is SIR. They are linked through the field PIR2SIR (lookup) in the child list.
...
0
votes
1answer
197 views
Value does not fall under expected range - caml query view fields
i am trying to update 2 hyperlink fields (internal names=Hlink1,Hlink2) in powershell,but i am getting "Value does not fall under expected range" error once it hits $Item.SystemUpdate(), but if i ...
0
votes
1answer
217 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);
...
